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:aufgaben:a06 [2024/09/05 12:02] – vdemir | modul:m290:learningunits:lu03:aufgaben:a06 [2024/10/02 15:13] (aktuell) – vdemir | ||
|---|---|---|---|
| Zeile 1: | Zeile 1: | ||
| - | ====== | + | ====== |
| + | |||
| + | In the previous lessons, you learnt what the term ERM means and what is generally understood by ERD. It is high time to consolidate these two technical terms. | ||
| ===== Prerequisites | ===== Prerequisites | ||
| - | * Work type: Individual/Peer | + | * Work type: Peer |
| - | * Means of aid: only teaching materials, no web-search, no use of ai. | + | * Means of aid: only teaching materials, no use of ai. |
| - | * Timeframe: | + | * Timeframe: |
| - | * Expected result: A Word/PDF/JPG file with an ERM that visualises | + | * Expected result: A Word/PDF file with an a comparison of the terms ERM vs. ERD. |
| - | ===== Introduction | + | ===== Task |
| - | One of the most important business areas that use RDS extensively are webshops that have a great interest in efficiently storing their data on customers, suppliers or stock levels. This task is about how to set up a suitable data structure for such a webshop. | + | Compare both terms, ERM and ERD, |
| - | + | ||
| - | ===== Given business case ===== | + | |
| - | You are assigned with designing a database to manage the webshops effienctly, that means consistently | + | |
| - | + | ||
| - | - The shop has several customers, who have Name, ContactName... PostalCodes. | + | |
| - | - Each customer can place several orders, which can be placed on different dates, but also on the same date. | + | |
| - | - For each order there are several order-details that contain the product and the quantity. | + | |
| - | - Each order has a one shipper, but one shipper can deliver several orders. | + | |
| - | - Each order has a employee with some according details, who fulfils the order. | + | |
| - | - Products have suppliers | + | |
| - | - Each product can be categorized, | + | |
| - | + | ||
| - | ===== 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 ===== | ===== Solution ===== | ||
| - | [[modul: | + | [[modul: |
| ===== Vocabulary ===== | ===== Vocabulary ===== | ||
| ^ English ^ German ^ | ^ English ^ German ^ | ||
| - | | prerequite | + | | prerequisite |
| - | + | | given| gegebene, vorausgesetzt | | |
| ---- | ---- | ||
| [[https:// | [[https:// | ||