Textbook Notes (369,072)
Canada (162,367)
Commerce (596)
COMM 190 (19)
Chapter 5

Chapter 5 notes.docx

4 Pages
82 Views

Department
Commerce
Course Code
COMM 190
Professor
Yasmeen Mufti

This preview shows page 1. Sign up to view the full 4 pages of the document.
Description
Chapter 5: Database and Content Management (Q1 to Q7) Q1. What is Content? - Content is property, close to o Intellectual property: form of creative endeavor that can be protected through a trademark, patent, copyright, industrial design or integrated circuit topography - Challenge: not collecting & distributing, but presenting it appropriately for various stakeholders inside and outside of organizations Q2. How Can Content Be Organized? - Challenge: indexing or cataloguing the right information, processing & storing it, and then getting it to the right person in the right format at the right time - Separate management of content data from the presentation of content - Data management: efficiently and effectively store and process bytes through organizational database management systems (DBMS) -> central - Content management system (CMS): when an employee wants to place some content on the organization’s web site, he/she will access this o Located on the company’s website server o Employee loads content into CMS, copy editor reviews, passes it to layout artists who prepares content for presentation (stored with help of DBMS), manager will review and publish -> web CMS manages each step and offers a standardized look o Grown from organizing documents for corporate websites to seeking out documents and automatically manage access o Example: Open Text and EMC Q3. What Is the Purpose of a Database? - Lists for single theme: spreadsheet, lists for multiple themes: databases - Purpose of a database: to keep track of things that involve more than one theme Q4. What Does a Database Contain? - Database: self-describing collection of integrated records - Hierarchy of data elements: o Byte: character of data, grouped into columns/fields, grouped into rows/records, grouped into tables/files - Database ≠ group of tables/files - Database = collection of tables plus relationships among the rows in those tables plus special data called metadata Relationships among Records - Key: column or group of columns that identifies a unique row in a table o Ex: EmailNum for Email Table, Student Number for Student table, can’t be student Number for Email Table because students can email more than once therefore Student Number wouldn’t be unique - Foreign keys: columns are key, but for a different (foreign) table o Ex: Student Number for the Email Table - Relationship databases: databases that carry their data in the form of tables and represents relationships using foreign keys (another name for a table is relation) Metadata - “Self-describing” means that a database contains, within itself, a description of its contents o Ex: library - Metadata: data that describe data - Databases more useful than spreadsheets, because you don’t have to guess/remember/record what is in the database with metadata Q5. What Is a DBMS, and What Does It Do? - Database application system: makes databa
More Less
Unlock Document

Only page 1 are available for preview. Some parts have been intentionally blurred.

Unlock Document
You're Reading a Preview

Unlock to view full version

Unlock Document

Log In


OR

Join OneClass

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

Sign up

Join to view


OR

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.


Submit