Textbook Notes (280,000)
CA (170,000)
Queen's (4,000)
COMM (600)
Chapter 5

COMM 190 Chapter Notes - Chapter 5: Database Application, Foreign Key, Unique Key


Department
Commerce
Course Code
COMM 190
Professor
Mosey Nicholas J
Chapter
5

This preview shows half of the first page. to view the full 3 pages of the document.
Chapter 5: Database and Content Management
What is Content?
In the broadest sense, content is property content varies by industry
o Closely related to intellectual property creative endeavor that can be protected
through a trademark, patent, copyright, design, or integrated circuit topography
o Content can be advertisements, pictures, word documents, videos, account info…
There is a huge volume on content and there are many ways content can be formatted
o This makes it harder for firms to effectively use content & present it appropriately
How Can Content be Organized?
The challenge is indexing the right info, processing and storing it, then getting it to the
right person in the right format at the right time
One way to think of content mgmt. is to separate the mgmt. of the content data from the
presentation of the content
o Data mgmt. focuses on how to efficiently and effectively store and process data
which is usually handled by database mgmt. systems (DBMS)
o Presentation of content is increasingly handled through a series of step supported
by software content mgmt. systems (CMS) was developed to help this process
What is the Purpose of a Database?
It keeps track of things when you need to track a lot of things this becomes very useful
o This way, the data is all in one place and is easy to access
What does a Database Contain?
A database is a self-describing collection of integrated records
A byte is a character of data; bytes are grouped into columns or fields; fields are grouped
into rows or records; a group of similar records are called a table or file
A database is a collection of tables + relationships among the rows in those tables +
special data (called metadata) that describe the structure of the database
Relationships among Records (Rows)
A key is a column, or group of columns, that identifies a unique row in a table
A foreign key is a column or group of columns used to represent relationships
o Values of the foreign key match values of the primary key in a different (foreign)
table appear in more than one table
Relational databases are databases that carry their data in the form of tables and that
represent relationships using foreign keys
You're Reading a Preview

Unlock to view full version