Tuesday, February 7, 2012

DVD Diagram

Shorthand for Normalization

These three rules will get you through most of database design


1. Every table should be only about one thing. Split out every separate topic into its own entity

2. any multivalued attributes should be removed to their own entity

3. Whenever you have a many to many relationship you must resolve the relationship into two one to many relationships by adding a linking table


Here is the diagram for the DVD we did in class. Click on it to get a larger image.

No comments:

Post a Comment