====== LU04.A02 - ERM: Travel_DB ======

===== Prerequisites  =====
  * 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.  


===== 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

===== Task: Design a ERM  ====
Analyse the given business cases and design an ERM that meets the requirements of the business cases below.

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

===== Solution =====
[[modul:m290:learningunits:lu03:loesungen:l02|Lösung]]


===== Vocabulary =====
^ English ^ German ^ 
| prerequite | Grundvoraussetzung |



----
[[https://creativecommons.org/licenses/by-nc-sa/4.0/|{{https://i.creativecommons.org/l/by-nc-sa/4.0/88x31.png}}]] Volkan Demir