Question:
- Draw a dependency diagram to show the functional dependencies in the relation
- Decompose the relation into a set of 3NF relations
- Draw a relational schema for your 3NF relations and show the referential integrity constraints
- Create an ERD that represents your 3NF relations
Answer
