Assignment 4
Due date: Monday, Nov. 4, 11:59PM.
NOTES:
- Start early!
- This is an individual assignment; no groups allowed.
This assignment is meant to give you practice with ER Modelling and Relational Database Design.
Problem 1:
- Solve Exercise 7.20 page 319 in the textbook.
- Solve Exercise 7.21 page 319 in the textbook.
Problem 2:
- Give the Relation Schema for your solution to Exercise 7.20. Include all the constraints.
- Give the Relation Schema for your solution to Exercise 7.21. Include all the constraints.
Deliverables
- a document with the solutions to the above problems.
Upload the document in canvas.