Database Modeling and Design
1Database Modeling and Design3rd EditionToby J. TeoreyUniversity of MichiganLecture NotesContentsI. Database Systems and the Life Cycle (Chapter 1)........................2 Introductory concepts; objectives of Database management 2Relational Database life cycle 3Characteristics of a good Database Design process 7II. Requirements Analysis (Chapter 3)...................................... ..8 III. Entity-Relationship (ER) Modeling (Chapters 2-4)..................11Basic ER Modeling concepts 11Schema integration methods 22Entity-relationship 26Transformations from ER diagrams to SQL Tables 29IV. Normalization and normal forms (Chapter 5)...........................35First normal form (1NF) to third normal form (3NF) and BCNF 353NF synthesis algorithm (Bernstein) 42Fourth normal form (4NF) 47V.
- dependency conflicts - connectivity is different for different views (e.g. job-title vs. job-title-history) - key conflicts - same concept but different keys are assigned (e.g. ID-no vs. SSN) - behavioral conflicts - different integrity constraints (e.g. null rules for optional/mandatory: insert/delete rules) * determine inter-schema properties
Download Database Modeling and Design
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: