Computer Science 1032A/B Lecture Notes - Lecture 2: Database, Mysql, Content Management

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

Document Summary

Before computers, paper - write it down. After computers - database on a computer. Definition: a collection of data: storing and grouping. Relational database: groups of data are related to each other in a meaningful way. Table is comprised of x number fields and y number of records. Tables or files + relationship among rows in tables + meta data (description of the structure of database) Values in one table relating to rows in other tables. Column(s) that identify unique row in table. Databases using tables, primary keys and foreign keys. Translate the model to create your database. Representation of reality that retains only selected details. Powerful tool for validating necessary details and eliminating irrelevant details. First, you create a blueprint, a plan, a model. Graphical method of mapping the real world. Is the association between two or more entities. Captures how the entities are related to one another. Necessary to uniquely identify the distance of each entity.