Computer Science 1032A/B Lecture Notes - Lecture 2: Office Open Xml, Computer File, Relational Database

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

Document Summary

A computer file is comprised of two parts: a file name and the type of file. (ex, file 1 (name) type of. You must know every dime or every dollar coming in and coming out. How? (av) database: definition: a collection of data: storing and grouping, relational database: groups of data are related to each other in a meaningful way. Table: comprised of 5 fields, comprised of 8 records (insert the table) Tables or files + relationships among rows in tables + metadata (description of the structure of 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, and foreign keys. Databases are self-describing: contain description of its content. Metadata: data that describes data, makes databases more useful, makes databases easier to use.