Computer Science 1032A/B Study Guide - Final Guide: Unique Key, Foreign Key, Database

• School: Western University
• Department: Computer Science
• Course: Computer Science 1032A/B

Document Summary

How? (bc) paper (ac) database: database: collection of data; storing and grouping, relational database: groups of data are related to each other in a meaningful way. Tables or files + relationships among rows in tables + metadata = database. Values in one table relating to rows in other tables. Primary keys: column(s) that identify unique row in table, each table has a key. Foreign keys: primary keys from a different table. Relational database: databases using tables, primary keys & foreign keys. Challenge is not collecting but distributing and presenting the content. *****exam q *****content management challenge: *processing and storing the right content, *getting the right content to the right person in the right format at the right time. Management of content data: database management systems (dbms) **exam** spreadsheets: keeps list of single concept. **exam** databases: keeps lists that involve multiple themes. Program: creates database, processes database, administers database.