Knowledge is of no value unless you put it into practice.
—Anton Chekhov

Logical data model: exercises

The exercises below give you the opportunity to practice creating logical data models. For the different exercises we always give a model solution.

Exercise 1: car rental

Convert the following conceptual data model to a logical data model based on the relational data model. Use draw.io.

Opgave oefening autoverhuur
Oplossing oefening autoverhuur

Exercise 2: youth association

Convert the following conceptual data model to a logical data model based on the relational data model. Use draw.io.

Opgave oefening jeugdvereniging
Oplossing oefening jeugdvereniging

Exercise 3: board game association

Convert the following conceptual data model to a logical data model based on the relational data model. Use draw.io.

Opgave oefening bordspellenvereniging
Oplossing oefening bordspellenvereniging

Exercise 4: technical maintenance and repair

Convert the following conceptual data model to a logical data model based on the relational data model. Use draw.io.

Opgave oefening technisch onderhoud en reparatie
Oplossing oefening technisch onderhoud en reparatie

Exercise 5: library

Convert the following conceptual data model to a logical data model based on the relational data model. Use draw.io.

Opgave oefening autoverhuur
Oplossing oefening autoverhuur