https://wiki.bzz.ch/ 2026-04-28T07:59:01+00:00 https://wiki.bzz.ch/ https://wiki.bzz.ch/_media/wiki/logo.png text/html 2024-10-24T06:21:32+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bzz.ch/modul/m290/learningunits/lu05/loesungen/l01?rev=1729750892&do=diff LU07.S01 - SQL-DDL: DB Management Solutions Task A Make sure, that your MySQL database system is running and connect with you webstorm editor to your database with your DBA credentials (user: root, password: yourPW). Windows CTRL + Shift + ESC -- text/html 2024-10-17T10:42:07+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bzz.ch/modul/m290/learningunits/lu05/loesungen/l02?rev=1729161727&do=diff LU07.S02 - SQL-DDL: Table Management Case studies / Assignments 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) text/html 2024-10-17T10:41:55+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bzz.ch/modul/m290/learningunits/lu05/loesungen/l03?rev=1729161715&do=diff LU07.S03 - SQL-DDL: Constraint Management Assignments & Solutions A: PRIMARY KEY Create a table books that has a book_id as a unique identifier for each book, with book_id as the primary key. Include columns for book_title (VARCHAR) and author_name (VARCHAR). The book_id should be an integer and cannot be NULL.