Q1: What is content?
Content is property. It is often closely related to intellectual property, which in Canada is defined as a
form of creative endeavor that can be protected through a trademark, patent, copyright, industrial design,
or integrated circuit topography.
----- Content varies by industry.
----- The expanding volume of content and the growing number of formats in which it is provided can
make it difficult for individuals and corporations to effectively utilize that content. Managing content is
therefore am important challenge for business students to understand and appreciate.
The data, graphics, sound, images, and video that areof importance to the organization
Creating, storing, and editing the content anorganization has captured.
Q2: How can content be organized?
The challenge in content management is indexing or cataloguing the right information, processing, and
storing it, and then getting it to the right person in the right format at the right time.
----- One way of thinking about content management is to separate the management of content data from
the presentation of content.将要展现的信息分类，保存
The management of many types of data has traditionally been handled through organizational database
management systems. These DBMS are central to the management of content data.
Content management includes
Database management systems (DBMS)
• Enables integration with multiple applications
Content management system (CMS)
• Used to format the presentation of data to a uniformstandard
Q3: What is the purpose of a database?
A database keeps track of things.
Different between using spreadsheet and database: Lists that involve a single theme can be stored in a
spreadsheet; lists that involve multiple themes require a database. To summarize, the purpose of a database is to keep track of things that involve more than one
Q4: What does a database contain?
A database is self-describing collection of integrated records.
Bit: smallest unit is a bit which represents either 1 or 0.
Byte: a byte = 8 bits the most common storage unit.
A byte is a character of data.
Bytes are grouped into columns, also called fields.
-----A field is a representation of one fact that is an attribute of a thing or an event.
For example: student number and student name.
A record is a group of logically related field.
For example: (student name, student number, HW1, HW2, and midterm)
The collection of data for all columns (student name, student number, HW1, HW2, and midterm) is
called a row or a record.
Finally, a group of similar rows or records is called a table or a file.
A database is a collection of tables plus relationships among the rows in those tables, plus special
data, called metadata, that describe the structure of the database.
A database is a set of tables that are related logically.
Databases are normally stored on magnetic disks.
Relationships among records
A key is a column or group of columns that identifies a unique row in a table.
----- Every table must have a key. Columns that fulfill a role like that of student number in the email and Office Visit table are called
foreign keys. This term is used because such columns are keys, but they are keys of a different
(foreign) table from the one in which they reside.
Databases that carry their data in the form of tables and that represent relationships using foreign keys are
called relational databases.
Databases are self-describing: it means that a database contains, within itself, a description of its
Metadata are data that describe data
---- makes data