modul:m290:learningunits:lu07:aufgaben:03

Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

Link zu dieser Vergleichsansicht

Beide Seiten der vorigen Revision Vorhergehende Überarbeitung
Nächste Überarbeitung		 Vorhergehende Überarbeitung
modul:m290:learningunits:lu07:aufgaben:03 [2024/10/01 10:47] – vdemirmodul:m290:learningunits:lu07:aufgaben:03 [2024/10/17 12:45] (aktuell) – vdemir
Zeile 1: Zeile 1:
-====== LU07.A03 - INSERT INTO ======+====== LU08.A03 - UPATE ======
  
 ===== Requirements  ===== ===== 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. 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. 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.
  
-  UPDATE employees +==== C: Update with AND ==== 
-  SET sex = '' +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.
-  WHERE sex = 'M' OR sex = 'F'; +
-   +
-After performing the update statement, the select on the table 'employee' shows that the column 'sex' is now empty. +
- +
-{{:modul:m290:learningunits:lu07:aufgaben:lu07.s03a.png?800|}} +
- +
- +
-==== B: 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 CHF 70,000. Create a DML update command that covers the requirements. +
- +
-to make sure, that the outcome is correct we first need to find the rows concorned. The following SQL statements will give us the correct resultset. +
- +
-  Select * +
-  FROM employees +
-  WHERE department = 'IT' +
-  AND salary < 70000; +
-  +
-This execution of the select results in the following image: +
- +
-{{:modul:m290:learningunits:lu07:aufgaben:lu07.s03b1.png?800|}}  +
- +
-After executing the following update command, we check the result, in which the 4 lines the ‘Salary’ column are now updated to CHF 70'0000,-. +
- +
-  UPDATE employees +
-  SET salary = 70000 +
-  WHERE department = 'IT' +
-  AND salary < 70000; +
- +
-  Select * +
-  FROM employees +
-  WHERE department = 'IT'; +
-   +
-{{:modul:m290:learningunits:lu07:aufgaben:lu07.s03b2.png?800|}}+
  
 ===== Solution ===== ===== Solution =====
-[[modul:m290:learningunits:lu07:loesungen:l02|Lösung]]+[[modul:m290:learningunits:lu07:loesungen:l03|Lösung]]
  
 ===== Vocabulary ===== ===== Vocabulary =====
  • modul/m290/learningunits/lu07/aufgaben/03.1727772429.txt.gz
  • Zuletzt geändert: 2024/10/01 10:47
  • von vdemir