https://wiki.bzz.ch/ 2026-04-07T21:57:02+00:00 https://wiki.bzz.ch/ https://wiki.bzz.ch/_media/wiki/logo.png text/html 2024-10-24T10:50:33+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bzz.ch/en/modul/m290/learningunits/lu05/theorie/01?rev=1729767033&do=diff LU07a - SQL-DDL: DB Management Learning Objectives In this session, we will learn some thrilling details about how to properly manage our databases. To achieve this, we need to know more about: * What a db schema / db instance is. * How to create database instances. text/html 2024-10-17T10:43:22+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bzz.ch/en/modul/m290/learningunits/lu05/theorie/02?rev=1729161802&do=diff LU07b - SQL-DDL: Table Management Source: * W3Schools | CREATE TABLE * W3Schools | ALTER TABLE * W3Schools | DROP TABLE Learning Objectives In this learning unit, we will learn how to manage database tables, i.e. * how to create * how to modify and * how to delete database tables CREATE TABLE Let's start by creating a table based on the ERD of the student management tool, as shown below: text/html 2024-10-17T10:42:57+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.bzz.ch/en/modul/m290/learningunits/lu05/theorie/03?rev=1729161777&do=diff LU07c - SQL-DDL: Constraint Management Source: * W3Schools | Constraints | Overview * W3Schools | Constraints | PRIMARY KEY * W3Schools | Constraints | AUTO_INCREMENT * W3Schools | Constraints | FOREIGN KEY * W3Schools | Constraints | NOT NULL * W3Schools | Constraints | UNIQUE Learning Objectives * Discuss what database CONSTRAINTS are and for they are needed * Explain the four most important CONSTRAINTS in database systems * Apply CONSTRAINTS to entity and realati…