LU03.A04 - ERD: Travel DB

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.

Create an ERD to the given ERM in the Crow's Foot Notation.

• Identify additional attributes
• Establish relation with inkl. the primary keys and foreign keys
• Connect the tables and finish your work by fixing the entities (0:1, :1, 0:n)

1. Relationships:

• One-to-Many:
  • A Continent can have many Countries.
  • A Country can have many Trips.

2. ERM in Crow's feet notation

• Continent (1) ————< has >———— (∞) Country
• Country (1) ————< hosts >———— (∞) Trip

3. ERM visualisation

Volkan Demir