PDF4PRO ⚡AMP

Modern search engine that looking for books and documents around the web

Example: tourism industry

Database Modeling and Design

Back to document page

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. Access Methods (Chapter 6)...................................... ............50Sequential access methods 50Random access methods 52Secondary Indexes 58Denormalization 62Join strategies 64VI.

data —a fact, something upon which an inference is based (information or knowledge has value, data has cost) data item —smallest named unit of data that has meaning in the real world (examples: last name, address, ssn, political party) data aggregate (or group ) -- a collection of related data items that form a

  Database, Data

Download Database Modeling and Design


Information

Domain:

Source:

Link to this page:

Please notify us if you found a problem with this document:

Spam in document Broken preview Other abuse

Related search queries