Computer Science 1032A/B Final: COMPSCI FINAL EXAM

• 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 details. Associate or map, elements in reality to elements in the model. Analyze existing reports, forms, and user activities. Reports requirements create data model (entities and relationships) data model create database design (tables with foreign keys) database design create database. First make an entity relationship model (er diagram) Once the er model is build it is used as a blueprint for the real database. Represents a discrete object: person, place, thing, or event. An instance of the entity is a set of data items that exist. Necessary to uniquely identify the instance of each entity. Captures how the entities are related to one another. Person works for company: hire date for the person is a detail that describes the relationship.