DROP Table If EXISTS Hersteller; Create Table Hersteller ( H_ID varchar PRIMAY KEY, Name varchar, Herkunftsland varchar, Gegründet varchar, ); DROP Table If EXISTS Modell; Create Table Modell ( M_ID varchar PRIMARY KEY, Name varchar, Leistung varchar, Hubraum varchar, Sitzhöhe varchar, Höchstgeschwindigkeit varchar, ); INSERT INTO Hersteller VALUES ('Aprilia', 'Italien', 1945); INSERT INTO Hersteller VALUES ('BMW-Motorrad', 'Deutschland', 1917); INSERT INTO Hersteller VALUES ('Ducati', 'Italien', 1926); INSERT INTO Hersteller VALUES ('KTM', 'Österreich', 1954); INSERT INTO Hersteller VALUES ('Honda', 'Japan', 1948); INSERT INTO Modell Values ('Aprilia RS660', '100 PS','659 ccm','820mm', '200km/h'); INSERT INTO Modell Values ('Aprilia SL 1000 Falco', '118 PS', '998 ccm', '820mm','255km/h'); INSERT INTO Modell Values ('BMW S 1000 RR', '156 PS', '999 ccm', '820mm', '324km/h); INSERT INTO Modell Values ('BMW HP2', '86 PS', '750 ccm', '810mm', '240km/h); INSERT INTO Modell Values ('Ducati 1299 Panigale', '186 PS', '1299 ccm', '820mm', '314km/h'); INSERT INTO Modell Values ('Ducati Hypermotard 821', '72 PS', '821 ccm', '810mm', '186km/h'); INSERT INTO Modell Values ('KTM 690 Enduro', '76 PS', '689 ccm', '810mm', '190km/h'); INSERT INTO Modell Values ('KTM 890 Duke R', '95 PS', '889 ccm', '820mm', '224km/h'); INSERT INTO Modell Values ('Honda CBR 1000 RR Fireblade', '204 PS', '999 ccm', '820mm', '286km/h'); INSERT INTO Modell Values ('Honda CBR 600 RR', '75 PS', '599 ccm', '810mm', '167km/h');
ausführen
