Unterschiede
Hier werden die Unterschiede zwischen zwei Versionen angezeigt.
| Nächste Überarbeitung | Vorhergehende Überarbeitung | ||
| modul:m290:learningunits:lu04:aufgaben:a02 [2024/09/03 12:47] – angelegt vdemir | modul:m290:learningunits:lu04:aufgaben:a02 [2024/10/17 12:35] (aktuell) – vdemir | ||
|---|---|---|---|
| Zeile 1: | Zeile 1: | ||
| - | ====== | + | ====== |
| ===== Requirements | ===== Requirements | ||
| * Work type: individual | * Work type: individual | ||
| - | * Timeframe: | + | * Timeframe: |
| * Means of aid: | * Means of aid: | ||
| * only teaching materials, no websearch, no use of ai. | * only teaching materials, no websearch, no use of ai. | ||
| Zeile 10: | Zeile 10: | ||
| ===== Case studies / Assignments ===== | ===== Case studies / Assignments ===== | ||
| - | Go to the W3-Schools SQL Editore and develop DQL-SELECT commands to the following | + | The following |
| + | |||
| + | {{: | ||
| ===== Assignments ===== | ===== Assignments ===== | ||
| + | The general assignment is to develop DQL commands that matches the requirements below: | ||
| - | * a) Create a adress-list of the customers | + | ==== Assignment A ==== |
| - | * b) Generate a list with ProductNames, | + | We need a list with product details as following: |
| - | * c) Find all employees who graduated from a university. | + | * Name of the supplier |
| + | * Supplier phone | ||
| + | * Product ID | ||
| + | * Name of the product | ||
| + | * Units | ||
| + | * Price | ||
| + | The list must be be sorted by the suppliername in descending order. | ||
| - | ===== Solution ===== | ||
| - | [[modul: | ||
| + | ==== Assignment B ==== | ||
| + | Extend the the result of the Select statement from assignment a), so that it must contain only produtcs of the supplier "Leka Trading" | ||
| + | ==== Assignment C ==== | ||
| + | We would like to know what products the customer " | ||
| + | * CustomerID | ||
| + | * CustomerName | ||
| + | * OrderID | ||
| + | * OrderDate | ||
| + | * Quantity | ||
| + | * ProductName | ||
| + | * CategoryName | ||
| + | |||
| + | ===== Solution ===== | ||
| + | [[modul: | ||
| + | | ||
| ===== Vocabulary ===== | ===== Vocabulary ===== | ||
| ^ English ^ German ^ | ^ English ^ German ^ | ||
| - | | respectively | + | | ... | ...| |
| - | | assignment | Auftrag | + | |
| ---- | ---- | ||
| [[https:// | [[https:// | ||