https://wiki.bzz.ch/ 2026-04-07T20:17:04+00:00 https://wiki.bzz.ch/ https://wiki.bzz.ch/_media/wiki/logo.png text/html 2024-10-17T10:44:52+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bzz.ch/en/modul/m290/learningunits/lu07/loesungen/l01?rev=1729161892&do=diff LU08.S01 - Preparatory work A: Creating the data schema First of all we need a database schema (database workspace). Execute the following two lines on your MySQL installation. CREATE DATABASE hr_database; SHOW DATABASES; USE hr_database; After executing the three SQL commands above, the feedback from your database would look like in the image below: text/html 2024-10-17T10:44:44+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bzz.ch/en/modul/m290/learningunits/lu07/loesungen/l02?rev=1729161884&do=diff LU08.S02 - INSERT INTO A: Separate INSERT statements Below you will find ten lines with employee data that you should insert into the ‘employees’ table, but with 10 separate INSERT commands. INSERT INTO EMPLOYEES (employee_id, name, surname, birthdate, sex, pronomen, employment_date, salary, department) VALUES (1, 'John', 'Doe', '1985-03-25', 'M', 'He/Him', '2015-01-15', 55000.00, 'Finance'); INSERT INTO EMPLOYEES (employee_id, name, surname, birthdate, sex, pronomen, employment_date, salary, … text/html 2024-10-17T10:44:36+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bzz.ch/en/modul/m290/learningunits/lu07/loesungen/l03?rev=1729161876&do=diff LU08.S03 - UPDATE A: Basic Update The employee ‘Laura Clark’ got divorced and therefore took her maiden name. Update her data record in the table. Update employees SET surname = 'Suter' WHERE employee_ID = 8; 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. text/html 2024-10-17T10:44:28+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bzz.ch/en/modul/m290/learningunits/lu07/loesungen/l04?rev=1729161868&do=diff LU08.S04 - DELETE A: Delete of one row Sarah Johnson has left the company and is therefore to be deleted from the table. Formulate the according DML DELETE statement. DELETE FROM employees WHERE name = 'Sarah' AND surname = 'Johnson'; Alternatively, the commands is likewise possible with using the employee_id.