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. 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.
to be able to define database components. Collect two types of data: natural data (input to the database) and processing data (output from the database). Natural data requirements (what goes into the database) 1. Organizational objectives - sell more cars this year - move into to recreational vehicle market 2. Information system objectives
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document:
{{id}} {{{paragraph}}}