Transcription of Database Modeling and Design
{{id}} {{{paragraph}}}
Example: dental hygienist
Database Modeling and Design
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. Normalization and normal forms (Chapter 5)..35 First normal form (1NF) to third normal form (3NF) and BCNF 353NF synthesis algorithm (Bernstein) 42 Fourth normal form (4NF) 47V. Access Methods (Chapter 6)..50 Sequential access methods 50 Random access methods 52 Secondary Indexes 58 Denormalization 62 Join strategies 64VI. Database Distribution Strategies (Chapter 8)..66 Requirements of a generalized DDBMS: Date s 12 Rules 68 Distributed Database requirements 72 The non-redundant best fit method 74 The redundant all beneficial sites method 77 VII.
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 Range of legal values 1 to 999,999 Synonyms cno, customer-number
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: