PMG2224 4/DB Beleg/Markus

Wiki-Quelltext dieser Seite.

<language>SQL</language>
 

<code id="65facc1e60af5"  >

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');
 


</code>


<run id="65df20eb37672"></run>