AE-DB-2.4

-- 2.4.1
INSERT INTO person (personennummer,nachname,vorname,strasse,ort,postleitzahl,land,geburtsdatum)
VALUES (1, "Blotzek", "Ulrich", "Großkopf 4", "Arnsberg", 59823, "Deutschland", "1960-10-05"),
(2, "Schatter", "Peter", "Försterstrasse 56", "Augsburg", 86179, "Deutschland", "1980-01-01"), (3, "Wojack", "Albert", "Westendstrasse 92", "Berlin", 12234, "Deutschland", "1955-06-15"), (4, "Virtanen", "Veera", "Oyi Keilasatama 21", "Espoo", 02150, "Finnland", "1992-12-30"),
(5, "Hämmäläinen", "Ahvo", "Tapulikuja 56", "Forssa", 30100, "Finnland", "1977-04-23"),
(6, "Huisman", "Fenna", "Spoordreef 87", "Almere", 1315, "Niederlande", "1971-08-17"),
(7, "Prins", "Lieke", "Noordgeest 21", "Bergen op Zoom", 4600, "Niederlande", "1987-05-08"),
(8, "David", "Paula", "Murielstrasse 47", "Klagenfurt", 9020, "Österreich", "1970-01-21"),
(9, "Hardiff", "Joseph", "Bischofsstrasse 139", "Klagenfurt", 9020, "Österreich", "1962-08-09");

-- 2.4.2
UPDATE person SET postleitzahl = 9900, ort = "Lienz" WHERE personennummer = 9
UPDATE person SET postleitzahl = 12557 WHERE nachname = "Wojack" AND vorname = "Albert";

-- 2.2.3
INSERT INTO hersteller (herstellernummer,herstellername,land)
VALUES
(10, "Logitech", "Schweiz"),
(20, "SONY", "Japan"),
(30, "Maxtor", "USA"),
(40, "Medion", "Deutschland"),
(50, "Hewlett Packard", "USA");
INSERT INTO artikel (artikelnummer, artikelname, herstellernummer, preis)
VALUES
(1, "Maus", 10, 10),
(2, "Tastatur", 10, 20),
(3, "Drucker", 50, 300),
(4, "Festplatte", 30, 400),
(5, "Monitor", 20, 500);
INSERT INTO bestellung (bestellnummer,artikelnummer,kundennummer,artikelanzahl,bestellsumme)
VALUES
(1, 1, 4, 2, 20),
(2, 2, 1, 1, 20),
(3, 1, 2, 3, 30),
(4, 3, 3, 1, 300),
(5, 5, 5, 5, 2500);