Computer Science 1032A/B Study Guide - Final Guide: Database, Customer Relationship Management, Content Management System

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

Document Summary

Design reflects the organization that exists within the data. Model: representation of reality that retains only selected details: powerful tool for validating necessary details and eliminating irrelevant ones, associate or map elements in reality to elements in the model. Data model: captures organization of the data in a logical representation of the data. Database development steps: developers analyze forms, reports, queries to judge requirements for system, requirements summarized in a data model, containing descriptions of data and relationships, database design implemented, database created and filled with user data. Most popular for data modeling, introduced by peter chen in 1976: now has many variants. Consists of: entities (with attributes, relationships (with attributes, cardinality, participation) Entity: represents a discrete object (person, place, thing, event) in rectangle: i. e. Attributes: describe properties of the entity in oval: i. e. Student attributes: student number, name, address, phone, email, etc.