Database Modeling and Design - Electrical Engineering and ...
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).
* Student registration system—cannot go to a 4-digit or hexadecimal course numbering system because of difficulty changing programs *Y2K (year 2000) problem—many systems store 2-digit years (e.g. ‘02-OCT-98’) in their programs and databases, that give incorrect results when used in date arithmetic (especially
Download Database Modeling and Design - Electrical Engineering and ...
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: