Textbook Notes (367,766)
Canada (161,379)
Commerce (596)
COMM 190 (19)
Chapter 5

Chapter 5

3 Pages
Unlock Document

COMM 190
Mosey Nicholas J

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 Metadata  This is data that describes data  a description of the contents of the data  The presence of metadata makes databases much more useful than a spreadsheet or data in other lists  Because of metadata no one needs to guess, remember, or record what is in the database What is a DBMS and What Does it Do?  A pure database in its raw form is not very useful  Database application systems make database data more accessible and useful o Employ a database application that consists of forms, formatted reports, queries, and application programs  each of these is known as a DBMS The Database Management System  This is a program used to create, process, and administer a database  almost no org makes their own and instead license products from vendors  Important to remember that DBMS is not the same as a database Creating the Database and Its Structures  Database developers use DBMS to create tables, relationships, and other structures  To create a new tables, the de
More Less

Related notes for COMM 190

Log In


Join OneClass

Access over 10 million pages of study
documents for 1.3 million courses.

Sign up

Join to view


By registering, I agree to the Terms and Privacy Policies
Already have an account?
Just a few more details

So we can recommend you notes for your school.

Reset Password

Please enter below the email address you registered with and we will send you a link to reset your password.

Add your courses

Get notes from the top students in your class.