Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
| Beide Seiten der vorigen Revision Vorhergehende Überarbeitung Nächste Überarbeitung | Vorhergehende Überarbeitung | ||
| modul:m290:learningunits:lu04:aufgaben:a02 [2024/09/03 14:43] – vdemir | modul:m290:learningunits:lu04:aufgaben:a02 [2024/10/17 12:35] (aktuell) – vdemir | ||
|---|---|---|---|
| Zeile 1: | Zeile 1: | ||
| - | ====== | + | ====== |
| ===== Requirements | ===== Requirements | ||
| Zeile 8: | Zeile 8: | ||
| * [[https:// | * [[https:// | ||
| * Expected result: Semantically and syntactically correct SQL statements according to the requirements of the case studies. | * Expected result: Semantically and syntactically correct SQL statements according to the requirements of the case studies. | ||
| - | |||
| ===== Case studies / Assignments ===== | ===== Case studies / Assignments ===== | ||
| Zeile 16: | Zeile 15: | ||
| ===== Assignments ===== | ===== Assignments ===== | ||
| - | You general assignment is to develop DQL commands that matches the requirements below: | + | The general assignment is to develop DQL commands that matches the requirements below: |
| - | ==== Assignment | + | ==== Assignment |
| - | Supplier and PrWe need a list with product details as following: | + | We need a list with product details as following: |
| - | * Supplier name | + | * Name of the supplier |
| * Supplier phone | * Supplier phone | ||
| - | * ProductID | + | * Product ID |
| - | * ProductName | + | * Name of the product |
| * Units | * Units | ||
| * Price | * Price | ||
| - | The list must be be sorted by SupplierName | + | The list must be be sorted by the suppliername |
| - | ==== Assignment | + | ==== Assignment |
| Extend the the result of the Select statement from assignment a), so that it must contain only produtcs of the supplier "Leka Trading" | Extend the the result of the Select statement from assignment a), so that it must contain only produtcs of the supplier "Leka Trading" | ||
| - | ==== Assignment | + | ==== Assignment |
| We would like to know what products the customer " | We would like to know what products the customer " | ||
| * CustomerID | * CustomerID | ||
| Zeile 42: | Zeile 41: | ||
| * CategoryName | * CategoryName | ||
| - | arningunits:lu04:aufgaben:screenshot_2024-09-03_143510.png? | + | ===== Solution ===== |
| + | [[modul: | ||
| | | ||
| - | ===== Solution ===== | ||
| - | |||
| - | |||
| ===== Vocabulary ===== | ===== Vocabulary ===== | ||
| ^ English ^ German ^ | ^ English ^ German ^ | ||