BEGIN TRANSACTION; CREATE TABLE IF NOT EXISTS "fahrschueler" ( "nr" INTEGER, "vorname" TEXT, "nachname" TEXT, "gebdatum" DATE, "theorie_bestanden" INTEGER, "anz_fahrstunden" INTEGER, "fl_kuerzel" TEXT, FOREIGN KEY("fl_kuerzel") REFERENCES "fahrlehrer"("kuerzel"), PRIMARY KEY("nr" AUTOINCREMENT) ); CREATE TABLE IF NOT EXISTS "fahrzeug" ( "kennzeichen" TEXT, "hersteller" TEXT, "ist_automatik" INTEGER, PRIMARY KEY("kennzeichen") ); CREATE TABLE IF NOT EXISTS "fahrlehrer" ( "kuerzel" TEXT, "vorname" TEXT, "nachname" TEXT, "telefonnr" TEXT, "fahrzeug" TEXT, PRIMARY KEY("kuerzel") ); INSERT INTO "fahrzeug" VALUES ('B-AB 1234','Volkswagen',1), ('M-CD 5678','BMW',0), ('HH-EF 9101','Audi',1), ('D-GH 1122','Mercedes-Benz',0), ('S-IJ 3344','Ford',1), ('F-KL 5566','Toyota',0), ('K-MN 7788','Hyundai',1), ('L-OP 9900','Nissan',0); INSERT INTO "fahrlehrer" VALUES ('Mus','Max','Mustermann','123-456-7890','B-AB 1234'), ('Mu','Maria','Musterfrau','987-654-3210','HH-EF 9101'), ('Pet','Peter','Petersen','555-123-4567','M-CD 5678'), ('Schm','Elaine','Schmidt','111-222-3333','D-GH 1122'), ('Mul','Edgar','Müller','444-555-6666','S-IJ 3344'), ('Schu','Sabine','Schubert','777-888-9999','F-KL 5566'), ('Hof','Markus','Hoffmann','888-777-6666','K-MN 7788'), ('Ko','Christine','Koch','666-555-4444','L-OP 9900'), ('Bu','Andreas','Burmann','333-222-1111','N/A'), ('Rad','Katrin','Rademacher','222-333-4444','N/A'), ('Be','Michael','Becker','444-333-2222','N/A'); INSERT INTO "fahrschueler" VALUES (1,'Hans','Tiedemann','2000-01-01',0,10,'Rad'), (2,'Lisa','Terhoog','2002-02-02',1,15,'Mu'), (3,'Karl','Scholz','2004-03-03',0,12,'Pet'), (4,'Marie','Korting','2006-04-04',1,20,'Schm'), (5,'Fritz','Feidel','2004-05-05',0,8,'Rad'), (6,'Marie','Hermes','2001-12-02',1,17,'Mus'), (7,'Jana','Bisslich','2001-06-06',1,18,'Schu'), (8,'Paul','Wagner','1999-07-07',1,14,'Hof'), (9,'Boris','Czerban','2003-09-01',0,0,NULL), (10,'Laura','Beckmann','2006-08-08',1,22,'Ko'), (11,'Max','Abdelaziz','2002-09-09',1,16,'Bu'), (12,'Lena','Feierabend','2004-10-10',1,24,'Rad'), (13,'Kai','Nussbaum','2005-11-11',1,7,'Mu'), (14,'Lara','Hoffmann','2001-12-12',1,15,'Mu'), (15,'Jan','Koch','2004-01-01',1,12,'Pet'), (16,'Mia','Seßmann','2006-02-02',1,20,'Schm'), (17,'Ben','Stein','2004-03-03',0,4,'Mul'), (18,'Emma','Kunkel','2002-04-04',1,18,'Schu'), (19,'Tim','Renneberg','2000-05-05',1,14,'Hof'), (20,'Luisa','Keller','1998-06-06',1,22,'Ko'), (21,'Jonas','Stab','1996-07-07',1,16,'Bu'), (22,'Emily','Hoffmann','1994-08-08',1,24,'Mu'), (23,'Finja','Samuel','1992-09-09',1,1,'Mus'), (24,'Lukas','Wittkewitz','1990-10-10',1,15,'Mu'), (25,'Lara','Wong','1988-11-11',1,12,'Pet'), (26,'Leon','Becker','1986-12-12',1,20,'Schm'), (27,'Simon','Guillaume','1984-01-01',1,0,'Mul'), (28,'Juli','Nassar','1982-02-02',1,18,'Schu'), (29,'Sarah','Schultheiss','1980-03-03',1,14,'Hof'), (30,'Luca','Hoffmann','1978-04-04',1,22,'Ko'), (31,'Marlon','Pohl','1976-05-05',1,16,'Bu'), (32,'Melanie','Tekampe','2004-01-28',1,0,NULL), (33,'Mila','Hankel','1974-06-06',1,24,'Rad'), (34,'Felix','Gates','1972-07-07',0,7,'Mus'), (35,'Emilia','Hartmann','1970-08-08',1,15,'Mu'), (36,'Elias','Mrasok','1968-09-09',1,12,'Pet'), (37,'Hannah','Amani','2000-01-01',1,10,'Mus'), (38,'Paul','Granger','2002-02-02',1,15,'Mu'), (39,'Erik','Hoffmann','2004-03-03',1,12,'Pet'), (40,'Finn','Sachs','2006-04-04',1,20,'Schm'), (41,'Lina','Schwesig','2004-05-05',0,0,'Mul'), (42,'Leon','Vogt','2001-06-06',1,18,'Schu'), (43,'Lara','Roth','1999-07-07',1,14,'Hof'), (44,'Julian','Maaßen','2006-08-08',1,22,'Ko'), (45,'Sarah','Temiz','2002-09-09',1,16,'Bu'), (46,'Luca','Rowling','2004-10-10',1,24,'Rad'), (47,'Marlon','Hoffmann','2005-11-11',0,4,'Mus'), (48,'Mila','Dierksen','2001-12-12',1,15,'Mu'), (49,'Jonte','Eigner','2004-01-01',1,12,'Pet'), (50,'Emilia','Berger','2006-02-02',1,20,'Schm'), (51,'Elias','Friedmann','2004-03-03',0,2,'Mul'), (52,'Hannah','Turan','2002-04-04',1,18,'Schu'), (53,'Paul','Malik','2000-05-05',1,14,'Rad'), (54,'Emma','Laut','1998-06-06',1,22,'Ko'), (55,'Rasmus','Hoffmann','1996-07-07',1,16,'Bu'), (56,'Serdar','Kilic','2004-10-10',1,24,'Mu'), (57,'Cem','Korkmaz','2005-11-11',1,10,'Mus'), (58,'Zeynep','Yildiz','2001-12-12',1,15,'Mu'), (59,'Selim','Kaya','2004-01-01',1,12,'Pet'), (60,'Ebru','Aydin','2006-02-02',1,20,'Schm'), (61,'Mojtaba','Moradi','2005-03-04',0,0,NULL), (62,'Burak','Kilic','2004-03-03',1,8,'Mul'), (63,'Selin','Kara','2002-04-04',1,18,'Schu'), (64,'Yusuf','Cetin','2000-05-05',1,14,'Hof'), (65,'Sibel','Sari','1998-06-06',1,22,'Ko'), (66,'Kai','Zaech','2000-01-01',1,10,'Mus'), (67,'Mariam','Erakat','2002-02-02',1,15,'Mu'), (68,'Jan','Abshoff','2004-03-03',1,12,'Pet'), (69,'Mia','Hoffmann','2006-04-04',1,20,'Schm'), (70,'Ben','Böhm','2004-05-05',0,8,'Rad'), (71,'Emma','Haarmann','2001-06-06',1,18,'Schu'), (72,'Tim','Waltz','1999-07-07',0,14,'Hof'), (73,'Luisa','Rüdiger','2006-08-08',1,22,'Ko'), (74,'Jonas','Bell','2002-09-09',1,16,'Bu'), (75,'Emily','Winston','2004-10-10',1,24,'Mu'), (76,'Evgeny','Sunderland','2005-11-11',1,10,'Mus'), (77,'Tobias','Westendorf','1998-10-16',0,0,NULL), (78,'Lukas','Hoffmann','2001-12-12',1,15,'Mu'), (79,'Lara','Jäger','2004-01-01',1,12,'Pet'), (80,'Leon','Beth','2006-02-02',1,20,'Schm'), (81,'Lina','Bernhard','2004-03-03',0,8,'Mul'), (82,'Julian','Schlimme','2002-04-04',1,18,'Schu'), (83,'Sarah','Münster','2000-05-05',1,14,'Hof'), (84,'Luca','Poletta','1998-06-06',1,22,'Rad'), (85,'Dennis','Dragowski','1999-03-07',0,0,NULL), (86,'Anita','Kamphoff','1999-03-10',1,0,NULL); COMMIT;