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;
