Exercise 2: Hotel-room-reservation (modelling exercise)

Read the following assignment below. Then perform

a conceptual analysis,
create a conceptual model (UML Class diagram) and
logical model (crow's feet)

You can use any drawing or CASE tool such as diagrams.net, Violet or Visio for UML class diagram (conceptual data model = CDM and logical data model = LDM). MySQL Workbench suits well for designing the logical and physical data models. Document your solution properly (e.g. explaining your decisions). Write the learnings to your learning report.

Assignment:

Create a database model for a reservation system of hotel rooms considering the following facts:

hotel contains several rooms
customer can reserve one or more rooms
one room contains one, two, or three beds
bed can be normal (for one person), double, or spare (less expensive)