ZdW87sj3

1DROP TABLE IF EXISTS admin_test.Bibliothek;
2DROP TABLE IF EXISTS admin_test.Person;
3DROP TABLE IF EXISTS admin_test.Buch;
4
5CREATE TABLE admin_test.Bibliothek (
6BID int UNIQUE PRIMARY KEY,
7Name varchar(100) NOT NULL,
8Adresse varchar(100) NOT NULL,
9UNIQUE(Name, Adresse),
10Leiter varchar(100),
11CONSTRAINT fk_Leiter FOREIGN KEY (Leiter) References Person(Vorname) 
12);
13
14CREATE TABLE admin_test.Buch (
15Title varchar(100) NOT NULL PRIMARY KEY,
16ISBN INT NOT NULL UNIQUE KEY);
17
18CREATE TABLE admin_test.Person (
19Vorname varchar(100) NOT NULL,
20Nachname varchar(100) NOT NULL,
21PRIMARY KEY (Vorname, Nachname),
22Geburtsdatum TIMESTAMP,
23Wohnort varchar(100) NOT NULL,
24Lieblingsbuch varchar(100),
25CONSTRAINT fk_Lieblingsbuch FOREIGN KEY (Lieblingsbuch) REFERENCES admin_test.Buch(Title) );