-- Erstelle die Tabelle "fahrlehrer"
CREATE TABLE IF NOT EXISTS fahrlehrer (
    kuerzel TEXT PRIMARY KEY,
    vorname TEXT,
    nachname TEXT,
    telefonnr TEXT
);

-- Erstelle die Tabelle "fahrschueler"
CREATE TABLE IF NOT EXISTS fahrschueler (
    nr INTEGER PRIMARY KEY AUTOINCREMENT,
    vorname TEXT,
    nachname TEXT,
    gebdatum DATE,
    theorie_bestanden BOOLEAN,
    anz_fahrstunden INTEGER,
    fl_kuerzel TEXT,
    FOREIGN KEY (fl_kuerzel) REFERENCES fahrlehrer(kuerzel)
);

-- Füge 10 Fahrlehrer hinzu
INSERT INTO fahrlehrer (kuerzel, vorname, nachname, telefonnr)
VALUES
    ('Mus', 'Max', 'Mustermann', '123-456-7890'),
    ('Mu', 'Maria', 'Musterfrau', '987-654-3210'),
    ('Pet', 'Peter', 'Petersen', '555-123-4567'),
    ('Schm', 'Elaine', 'Schmidt', '111-222-3333'),
    ('Mul', 'Edgar', 'Müller', '444-555-6666'),
    ('Schu', 'Sabine', 'Schubert', '777-888-9999'),
    ('Hof', 'Markus', 'Hoffmann', '888-777-6666'),
    ('Ko', 'Christine', 'Koch', '666-555-4444'),
    ('Bu', 'Andreas', 'Burmann', '333-222-1111'),
    ('Rad', 'Katrin', 'Rademacher', '222-333-4444'),
    ('Be', 'Michael', 'Becker', '444-333-2222');

INSERT INTO fahrschueler (vorname, nachname, gebdatum, theorie_bestanden, anz_fahrstunden, fl_kuerzel)
VALUES
    ('Hans', 'Tiedemann', '2000-01-01', FALSE, 10, 'Rad'),
    ('Lisa', 'Terhoog', '2002-02-02', TRUE, 15, 'Mu'),
    ('Karl', 'Scholz', '2004-03-03', FALSE, 12, 'Pet'),
    ('Marie', 'Korting', '2006-04-04', TRUE, 20, 'Schm'),
    ('Fritz', 'Feidel', '2004-05-05', FALSE, 8, 'Rad'),
    ('Marie', 'Hermes', '2001-12-02', TRUE, 17, 'Mus'),
    ('Jana', 'Bisslich', '2001-06-06', TRUE, 18, 'Schu'),
    ('Paul', 'Wagner', '1999-07-07', TRUE, 14, 'Hof'),
    ('Boris', 'Czerban', '2003-09-01', FALSE, 0, NULL),
    ('Laura', 'Beckmann', '2006-08-08', TRUE, 22, 'Ko'),
    ('Max', 'Abdelaziz', '2002-09-09', TRUE, 16, 'Bu'),
    ('Lena', 'Feierabend', '2004-10-10', TRUE, 24, 'Rad'),
    ('Kai', 'Nussbaum', '2005-11-11', TRUE, 7, 'Mu'),
    ('Lara', 'Hoffmann', '2001-12-12', TRUE, 15, 'Mu'),
    ('Jan', 'Koch', '2004-01-01', TRUE, 12, 'Pet'),
    ('Mia', 'Seßmann', '2006-02-02', TRUE, 20, 'Schm'),
    ('Ben', 'Stein', '2004-03-03', FALSE, 4, 'Mul'),
    ('Emma', 'Kunkel', '2002-04-04', TRUE, 18, 'Schu'),
    ('Tim', 'Renneberg', '2000-05-05', TRUE, 14, 'Hof'),
    ('Luisa', 'Keller', '1998-06-06', TRUE, 22, 'Ko'),
    ('Jonas', 'Stab', '1996-07-07', TRUE, 16, 'Bu'),
    ('Emily', 'Hoffmann', '1994-08-08', TRUE, 24, 'Mu'),
    ('Finja', 'Samuel', '1992-09-09', TRUE, 1, 'Mus'),
    ('Lukas', 'Wittkewitz', '1990-10-10', TRUE, 15, 'Mu'),
    ('Lara', 'Wong', '1988-11-11', TRUE, 12, 'Pet'),
    ('Leon', 'Becker', '1986-12-12', TRUE, 20, 'Schm'),
    ('Simon', 'Guillaume', '1984-01-01', TRUE, 0, 'Mul'),
    ('Juli', 'Nassar', '1982-02-02', TRUE, 18, 'Schu'),
    ('Sarah', 'Schultheiss', '1980-03-03', TRUE, 14, 'Hof'),
    ('Luca', 'Hoffmann', '1978-04-04', TRUE, 22, 'Ko'),
    ('Marlon', 'Pohl', '1976-05-05', TRUE, 16, 'Bu'),
    ('Melanie', 'Tekampe', '2004-01-28', TRUE, 0, NULL),
    ('Mila', 'Hankel', '1974-06-06', TRUE, 24, 'Rad'),
    ('Felix', 'Gates', '1972-07-07', FALSE, 7, 'Mus'),
    ('Emilia', 'Hartmann', '1970-08-08', TRUE, 15, 'Mu'),
    ('Elias', 'Mrasok', '1968-09-09', TRUE, 12, 'Pet'),
    ('Hannah', 'Amani', '2000-01-01', TRUE, 10, 'Mus'),
    ('Paul', 'Granger', '2002-02-02', TRUE, 15, 'Mu'),
    ('Erik', 'Hoffmann', '2004-03-03', TRUE, 12, 'Pet'),
    ('Finn', 'Sachs', '2006-04-04', TRUE, 20, 'Schm'),
    ('Lina', 'Schwesig', '2004-05-05', FALSE, 0, 'Mul'),
    ('Leon', 'Vogt', '2001-06-06', TRUE, 18, 'Schu'),
    ('Lara', 'Roth', '1999-07-07', TRUE, 14, 'Hof'),
    ('Julian', 'Maaßen', '2006-08-08', TRUE, 22, 'Ko'),
    ('Sarah', 'Temiz', '2002-09-09', TRUE, 16, 'Bu'),
    ('Luca', 'Rowling', '2004-10-10', TRUE, 24, 'Rad'),
    ('Marlon', 'Hoffmann', '2005-11-11', FALSE, 4, 'Mus'),
    ('Mila', 'Dierksen', '2001-12-12', TRUE, 15, 'Mu'),
    ('Jonte', 'Eigner', '2004-01-01', TRUE, 12, 'Pet'),
    ('Emilia', 'Berger', '2006-02-02', TRUE, 20, 'Schm'),
    ('Elias', 'Friedmann', '2004-03-03', FALSE, 2, 'Mul'),
    ('Hannah', 'Turan', '2002-04-04', TRUE, 18, 'Schu'),
    ('Paul', 'Malik', '2000-05-05', TRUE, 14, 'Rad'),
    ('Emma', 'Laut', '1998-06-06', TRUE, 22, 'Ko'),
    ('Rasmus', 'Hoffmann', '1996-07-07', TRUE, 16, 'Bu'),
    ('Serdar', 'Kilic', '2004-10-10', TRUE, 24, 'Mu'),
    ('Cem', 'Korkmaz', '2005-11-11', TRUE, 10, 'Mus'),
    ('Zeynep', 'Yildiz', '2001-12-12', TRUE, 15, 'Mu'),
    ('Selim', 'Kaya', '2004-01-01', TRUE, 12, 'Pet'),
    ('Ebru', 'Aydin', '2006-02-02', TRUE, 20, 'Schm'),
    ('Mojtaba', 'Moradi', '2005-03-04', FALSE, 0, NULL),
    ('Burak', 'Kilic', '2004-03-03', TRUE, 8, 'Mul'),
    ('Selin', 'Kara', '2002-04-04', TRUE, 18, 'Schu'),
    ('Yusuf', 'Cetin', '2000-05-05', TRUE, 14, 'Hof'),
    ('Sibel', 'Sari', '1998-06-06', TRUE, 22, 'Ko'),
    ('Kai', 'Zaech', '2000-01-01', TRUE, 10, 'Mus'),
    ('Mariam', 'Erakat', '2002-02-02', TRUE, 15, 'Mu'),
    ('Jan', 'Abshoff', '2004-03-03', TRUE, 12, 'Pet'),
    ('Mia', 'Hoffmann', '2006-04-04', TRUE, 20, 'Schm'),
    ('Ben', 'Böhm', '2004-05-05', FALSE, 8, 'Rad'),
    ('Emma', 'Haarmann', '2001-06-06', TRUE, 18, 'Schu'),
    ('Tim', 'Waltz', '1999-07-07', FALSE, 14, 'Hof'),
    ('Luisa', 'Rüdiger', '2006-08-08', TRUE, 22, 'Ko'),
    ('Jonas', 'Bell', '2002-09-09', TRUE, 16, 'Bu'),
    ('Emily', 'Winston', '2004-10-10', TRUE, 24, 'Mu'),
    ('Evgeny', 'Sunderland', '2005-11-11', TRUE, 10, 'Mus'),
    ('Tobias', 'Westendorf', '1998-10-16', FALSE, 0, NULL),
    ('Lukas', 'Hoffmann', '2001-12-12', TRUE, 15, 'Mu'),
    ('Lara', 'Jäger', '2004-01-01', TRUE, 12, 'Pet'),
    ('Leon', 'Beth', '2006-02-02', TRUE, 20, 'Schm'),
    ('Lina', 'Bernhard', '2004-03-03', FALSE, 8, 'Mul'),
    ('Julian', 'Schlimme', '2002-04-04', TRUE, 18, 'Schu'),
    ('Sarah', 'Münster', '2000-05-05', TRUE, 14, 'Hof'),
    ('Luca', 'Poletta', '1998-06-06', TRUE, 22, 'Rad'),
    ('Dennis', 'Dragowski', '1999-03-07', FALSE, 0, NULL),
    ('Anita', 'Kamphoff', '1999-03-10', TRUE, 0, NULL);