Assignment 4

Due date: Monday, Nov. 4, 11:59PM.
NOTES:
This assignment is meant to give you practice with ER Modelling and Relational Database Design.

Problem 1:

  1. Solve Exercise 7.20 page 319 in the textbook.
  2. Solve Exercise 7.21 page 319 in the textbook.

Problem 2:

  1. Give the Relation Schema for your solution to Exercise 7.20. Include all the constraints.
  2. Give the Relation Schema for your solution to Exercise 7.21. Include all the constraints.

Deliverables

  1. a document with the solutions to the above problems.
Upload the document in canvas.