PHYSICS 102 Lecture Notes - Lecture 6: Database, Data Modeling, Database Design
Document Summary
8. 1 explain the role of conceptual data modeling in the overall analysis and design of an information system; 8. 2 describe the information gathering process for conceptual data modeling; 8. 3 describe how to represent an entity-relationship model and be able to define the terms: entity type, attribute, identifier, multivalued attribute, and relationship; 8. 4 distinguish among unary, binary, and ternary relationships as well as associative entities, providing an example of each; 8. 5 define supertypes and subtypes, showing how to represent these entity types with entity-relationship diagramming notation; A detailed model that captures the overall structure of organizational data that is independent of any database management system or other implementation considerations. No matter how the information is stored, it is essential that the process, logic, and data model descriptions of a system are consistent and complete because each describes different, but complementary, views of the same information system.