Assignment 2


CS451/551, Spring 2024
due Monday, April 29
    You may use either Chen notation (consistent with our text) or Crowsfoot (from MySQL Workbench).

  1. Exercise 2.3, pp 52-53.

  2. Exercise 2.5, p 53.

  3. Exercise 2.6, pp 53-54 (ignore sub-question 2).

  4. Convert the ER diagram below to the relational model (that is, show the tables you should get). Indicate foreign keys and not null constraints.

Ship Movement Diagram