Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- modul:m290:learningunits:lu07:aufgaben:03 [2024/10/01 10:50] – vdemir
+++ modul:m290:learningunits:lu07:aufgaben:03 [2024/10/17 12:45] (aktuell) – vdemir
@@ Zeile 1: / Zeile 1: @@
-====== LU07.A03 - UPATE ======
+====== LU08.A03 - UPATE ======
 ===== Requirements  =====
@@ Zeile 11: / Zeile 11: @@
 In assignment A2 you imported 30 lines of date to the table 'employees'. In this assignment your task is to perform some DML update commands.
-==== A: Update with OR ====
+==== A: Basic Update ====
+The employee ‘Laura Clark’ got divorced and therefore took her maiden name. Update her data record in the table.
+==== B: Update with OR ====
 As a company policy the attribute 'sex' is not required anymore and is to be emptied. Formulate the corresponding SQL statement that deletes all content from that column.
-==== B: Update with AND ====
+==== C: Update with AND ====
 The performance of our company's IT department was outstanding last year, resulting in a pay rise to 70'000 for all IT employees earning less than 70,000. Create a DML update command that covers the requirements.
 ===== Solution =====
-[[modul:m290:learningunits:lu07:loesungen:l02|Lösung]]
+[[modul:m290:learningunits:lu07:loesungen:l03|Lösung]]
 ===== Vocabulary =====