Exercise: 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 Violet or Visio for UML class diagram (conceptual model) and MySQL Workbench for the logical model. 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)