Skip to content

HW4: EER to Relational Mapping

Due: Friday, Mar 13

Hotel Madison guest room
Image source: hotelmadison.com

Work with your HW4 team (not the same as your HW3 team) to complete this assignment.

Required Files

In this assignment, you will create a relational model based on the conceptual (EER) model you developed with your HW3 team for the hotel database.

You may approach this task by * using the mySQL Workbench ER Tool to draw the model, OR * using dbdiagram.io to draw the model.

Whichever approach you choose, these are the files required for HW4:

  • PNG format image of your relational model
  • PNG format image of your updated ER model
  • PDF document - explain the changes you made to your ER model (post HW3 submission) and explain any assumptions and design choices you made in your relational model.

The ER model and relational model must match. Changes to the ER model are expected, based on the advice I gave your HW3 teams.

Submission

Submit the 3 files into Canvas. Make sure your names are on all of them. Please do not use a black background on any parts of the model images, because I like to print them.