LU07.A02 - SQL-DDL: Table Management [BZZ

Diese Seite ist nicht editierbar. Sie können den Quelltext sehen, jedoch nicht verändern. Kontaktieren Sie den Administrator, wenn Sie glauben, dass hier ein Fehler vorliegt.

====== LU07.A02 - SQL-DDL: Table Management ======

===== Requirements  =====
  * Work type: Individual
  * Timeframe: 20 Minutes
  * Means of aid: 
      * Only teaching materials, no websearch, no use of ai.
      * 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-)

==== Task A: CREATE TABLE ====
Create a table called employees with the following columns:

  * employee_id (INT) as the primary key
  * first_name (VARCHAR 50)
  * last_name (VARCHAR 50)
  * hire_date (DATE)
  * 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 =====
^ English ^ German ^ 
| ... | ... |
| ... | ... |


----
[[https://creativecommons.org/licenses/by-nc-sa/4.0/|{{https://i.creativecommons.org/l/by-nc-sa/4.0/88x31.png}}]] Volkan Demir