Transcription of Database Modeling and Design - Electrical Engineering and ...
{{id}} {{{paragraph}}}
1 Database Modeling and Design3rd EditionToby J. TeoreyUniversity of MichiganLecture NotesContentsI. Database Systems and the Life Cycle (Chapter 1)..2 Introductory concepts; objectives of Database management 2 Relational Database life cycle 3 Characteristics of a good Database Design process 7II. Requirements Analysis (Chapter 3)..8 III. Entity-Relationship (ER) Modeling (Chapters 2-4)..11 Basic ER Modeling concepts 11 Schema integration methods 22 Entity-relationship 26 Transformations from ER diagrams to SQL Tables 29IV.
Security level 0 (customer list is public) Subtypes adults, minors Key attribute(s) cust-no Non-key attribute(s) cust-name, addr, phone, payment-status Relationship to other entities salesperson, order, product Used in which applications billing, advertising Attribute description (data elements in a data dictionary) Name cust-no Reference-no 4202
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}