Database Design: From Conceptual Design to Physical Implementation
Review
Database Design Process
Normalization
Normal Forms
Unnormalized Relations
Unnormalized Relation
First Normal Form
Second Normal Form
Third Normal Form
Most 3NF Relations are also BCNF
PPT Slide
Today: New Design
Cookie Requirements
Cookie Database
BIBFILE
Books/BIBFILE
CALLFILE
LocalInfo/CALLFILE
LIBFILE
Libraries/LIBFILE
PUBFILE
Publisher/PUBFILE
SUBFILE
Subjects/SUBFILE
INDXFILE
Linking Subjects and Books
Some examples of Cookie Searches
Cookie ER diagram
What Problems?
Problems Identified
Problems (Cont.)
Original Cookie ER diagram
Cookie3: Keywords
Cookie 4: Series
Cookie 5: Circulation
Mapping to Relations
Implementing the Physical Database...
Email: ray@sherlock.berkeley.edu
Home Page: http://sims.berkeley.edu/~ray
Download presentation source