Economics 1021A/B Lecture Notes - Lecture 6: John Zachman, Single Sign-On, Bulldozer

• School: Western University
• Department: Economics
• Course: Economics 1021A/B
• Professor: Elizabeth Torrens

Document Summary

Content- form of creative endeavor protected trough trademark, patent, copyright, industrial design. Content varies by industry: advertising industry- pictures, commercials, text to promote, publishing industry- words, cover art. Used to only be on paper, movies or photographs. Computers create digital content: stored, distribute, large amounts, webpages, blog text, twitter, discussion boards, videos, audio. Keeps track of more than 1 theme. Spreadsheet- only grades, database- grades, emails, office visits: spreadsheet has 1 theme, database has multiple. Tables + relationships w/ rows in tables + special data (metadata: table: columns=fields, rows=records, characters=bytes. Key- column/group of columns that identifies unique row in table: student number key of student table. Given student number, only 1 row corresponds to it: foreign key- column is a key but from a different table. Relational databases- carry data in tables that represents relationships using foreign keys. Data that describes the data in the database: column descriptions, field properties,