After developing our conceptional data model, the next step to establish a physical data base is shape a ERD, the Entity Relationship Diagram.

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

Below figure of a conceptual data-model illustrates the basic database structure of a Travel_DB. It consists of three base tables and two relations.

Your assignment is to analyze the given ERD (coneptual datamodel), which is in fact the last step before creating the actual db in our Mysql database system, and draw the ERD as a logial data model. The sub-tasks are:

1. develop the logical datamodel (tables, attributes, data types, fk/pk) by using the Crow's Foot Notation
2. realize the relation as relation tables (id, fk_tab1, fk_tab2, …)
3. finalize the ERM by adding the cardinalities (1:1, 1:many, …)

Lösung

Volkan Demir