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