Exericse: Invoices for a carsharing company

2020-10-18| YouTube explanation (German) | IHK final exam Summer 2001, GH1 Exercise 4

A carsharing company provides two Excel tables and an invoice. Those artifacts are used for creating invoices for their customers.

Based upon this information we have to model the ER diagram.

Stamdata

Those two tables are containing the stamdata:

Stamdata

Invoice

This is the invoice the carsharing company sends to its customers:

Invoice

How has the ER diagram to be modelled?