Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- modul:m290:learningunits:lu05:aufgaben:02 [2024/09/27 13:17] – vdemir
+++ modul:m290:learningunits:lu05:aufgaben:02 [2024/10/24 08:30] (aktuell) – [TASK F: DROP TABLE] vdemir
@@ Zeile 1: / Zeile 1: @@
-====== LU06.A02 - SQL-DDL: Table Management - Under Construction ======
+====== LU07.A02 - SQL-DDL: Table Management ======
 ===== Requirements  =====
-  * Work type: individual
+  * Work type: Individual
-  * Timeframe: .. Minutes
+  * Timeframe: 20 Minutes
   * Means of aid:
-      * only teaching materials, no websearch, no use of ai.
+      * Only teaching materials, no websearch, no use of ai.
-      * [[https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_columns | W3Schools | SQL Editor]]
+      * Webstorm including MySQL
   * Expected result: Semsntically and syntactically correct SQL statements according to the requirements of the case studies.
 ===== Case studies / Assignments =====
-...
+Here are six tasks related to MySQL table management, covering CREATE TABLE, ALTER TABLE, and DROP TABLE commands.Have fun 8-)
-===== Assignments =====
+==== Task A: CREATE TABLE ====
+Create a table called employees with the following columns:
-  * a) ...
+  * employee_id (INT) as the primary key
-  * b) ...
+  * first_name (VARCHAR 50)
+  * last_name (VARCHAR 50)
-===== Solution =====
+  * hire_date (DATE)
-[[modul:m290:learningunits:lu06:loesungen:l02|Lösung]]
+  * salary (DECIMAL)
+==== Task B: CREATE TABLE ====
+Create a table called products to store inventory information. The table should have:
+  * product_id (INT) as an auto-incrementing primary key.
+  * product_name (VARCHAR 100).
+  * category (VARCHAR 50).
+  * price (DECIMAL).
+  * stock_quantity (INT).
+==== Task C: ALTER TABLE ====
+Add a new column email (VARCHAR 100) to the employees table.
+==== TASK D: MODIFY COLUMN ====
+Change the salary column's data type to FLOAT in the employees table.
+==== TASK E: DROP COLUMN ====
+Remove the stock_quantity column from the products table.
+==== TASK F: DROP TABLE ====
+Completely remove the PRODUCTS table from the database.
+===== Solution =====
+[[modul:m290:learningunits:lu05:loesungen:l02|Lösung]]
 ===== Vocabulary =====