Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- modul:m290:learningunits:lu03:aufgaben:a07_erd [2024/09/12 11:55] – angelegt vdemir
+++ modul:m290:learningunits:lu03:aufgaben:a07_erd [2024/10/17 13:27] (aktuell) – vdemir
@@ Zeile 1: / Zeile 1: @@
-====== LU03.A07 - ERD: Reingeneering from the database  ======
+====== LU04.A07 - ERD: Reingineering of an existing database  ======
 From time to time, we may need to analyze an existing database in order to optimize the structure, e.g. for the next software version.
@@ Zeile 5: / Zeile 5: @@
   * Work type: Peer
   * Means of aid: [[https://www.w3schools.com/sql/trysql.asp?filename=trysql_editor | W3Schools-SQL-Editor]]
-  * Timeframe: 50 Minutes
+  * Timeframe: 45 Minutes
   * Expected result: ERD as a PDF-File, that describes the content of the given date-base in Crow's Foot Notation.
@@ Zeile 12: / Zeile 12: @@
 {{:modul:m290:learningunits:lu03:aufgaben:screenshot_2024-09-12_151200.png?800| Given data-struture of W3Schools-SQL database}}
+  - Identify all enties.
+  - Add the attributes and the corresponding data-types to each entity.
+  - Relate the tables to each other by analysing the primary keys and the foreign keys.
 ===== Solution =====
-[[modul:m290:learningunits:lu03:loesungen:l06|Lösung]]
+[[modul:m290:learningunits:lu03:loesungen:l07|Lösung]]
 ===== Vocabulary =====
@@ Zeile 20: / Zeile 24: @@
 | prerequisite | Grundvoraussetzung |
 | given| gegebene, vorausgesetzt |
-| to be commissioned |
 ----
 [[https://creativecommons.org/licenses/by-nc-sa/4.0/|{{https://i.creativecommons.org/l/by-nc-sa/4.0/88x31.png}}]] Volkan Demir