Computer Science 1032A/B Lecture Notes - Lecture 2: Cardinality, Peter Chen, Data Modeling

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

Document Summary

How was tracking done (ac): database. Tracking: a collection of data; storing and grouping: relational database: groups of data are related in a meaningful manner. How to track: build database, create tables and fields, populate data, create a model of the database. What is a model: representation of reality that retains only selected details, a model is something that is not complete. Models: powerful tool for validating necessary details and eliminating irrelevant details. How to build a database: first make a model (entity relationship model) E. r model: visualization (diagram) of the data, describes the logical database, graphical method of mapping the real world. An e-r model consists of: entities. How do i build the database: once the e-r model is built, it is used as a blueprint to build the real database, model is mapped to an actual relational database. E-r model: most popular for data modeling, introduced in 1976 by peter chen, there are many variants.