Database: Functional Dependencies and Normalization

Database Design Guideline

1. Design each relation schema so that it is easy to explain its meaning. Intuitively, each schema should correspond to one entity or one relationship type in the real life.
2. Design relation schema so that no insertion, deletion, or modification anomalies are present.
   
3.