LU04.A02 - ERM: Travel_DB

• Work type: Peer
• Means of aid: only teaching materials, no websearch, no use of ai.
• Timeframe: 10 Minutes
• Expected result: A Word/PDF file with an ERM that visualises the given business case.

As overreaching goal, we want to manage our vacations. Therefore, the following information is to be stored in our database.

• which countries we visited so far
• how long we stayed in each country
• on which continent each country is located
• the price for each trip
• the date of each trip

Analyse the given business cases and design an ERM that meets the requirements of the business cases below.

1. Identify the entities (tables)
2. Determine the attributes of each table, including the primary keys
3. Connect the base tables by adding relations to your data model
4. Determine the cardinality of the tables involved.

Lösung

Volkan Demir