Skip to content

Exercise 3: Car rental enterprise (modelling exercise)

Read the following assignment below. Then perform

  • a conceptual analysis,
  • create a conceptual model (UML Class diagram containing 3-5 main classes without attributes) and
  • logical model (crow's feet)

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

Assignment:

Design a database for a car rental enterprise.

The database should include the following information:

  • basic information about cars: license number (unique for each car), model, purchase date
  • basic customer information: customer number, name, phone number
  • rentals: which car, for which customer, when (date), for how long (hours or a specific date/time)

In addition, consider including car services: - dates (for the assignment and the actual scheduled service) + description (what has been agreed upon) - note: for one car can there can be many services, e.g. changing oil