Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
| Beide Seiten der vorigen Revision Vorhergehende Überarbeitung Nächste Überarbeitung | Vorhergehende Überarbeitung | ||
| modul:m290:learningunits:lu03:loesungen:l02 [2024/08/16 11:31] – gelöscht vdemir | modul:m290:learningunits:lu03:loesungen:l02 [2024/10/02 15:13] (aktuell) – vdemir | ||
|---|---|---|---|
| Zeile 1: | Zeile 1: | ||
| + | ====== LU04.S02 - ERM: Travel DB ====== | ||
| + | For this scenario, the following entity(-types) are identified: | ||
| + | |||
| + | 1. Country | ||
| + | * Attributes | ||
| + | * CountryID (Primary Key) | ||
| + | * CountryName | ||
| + | * ContinentName | ||
| + | |||
| + | 2. Trip | ||
| + | * Attributes | ||
| + | * TripID (Primary Key) | ||
| + | * CountryID (Foreign Key) | ||
| + | * StartDate | ||
| + | * EndDate | ||
| + | * Price | ||
| + | * Relationships: | ||
| + | * Country: A trip occurs in one country. | ||
| + | * Duration: Calculated as the difference between EndDate and StartDate. | ||
| + | |||
| + | 3. Continent | ||
| + | * Attributes: | ||
| + | * ContinentID (Primary Key) | ||
| + | * ContinentName | ||
| + | * Relationships: | ||
| + | * Country: Each country is located on one continent. | ||
| + | |||
| + | 4. Relationships: | ||
| + | * One-to-Many: | ||
| + | * A Continent can have many Countries. | ||
| + | * A Country can have many Trips. | ||
| + | |||
| + | |||
| + | 5. ERM in Crow's feet notation | ||
| + | * Continent (1) ————< | ||
| + | * Country (1) ————< | ||
| + | |||
| + | {{: | ||
| + | |||
| + | ===== Vocabulary ===== | ||
| + | ^ English ^ German ^ | ||
| + | | prerequisite | Grundvoraussetzung | | ||
| + | | given| gegebene, vorausgesetzt | | ||
| + | |||
| + | ---- | ||
| + | [[https:// | ||