PMG2426 1/DB Beleg/Sarah

Aus ProgrammingWiki
Wiki-Quelltext dieser Seite.
<language>SQL</language>
=='''''Musik-Streaming-Dienst-Datenbank'''''==

<code id="697094687f3b7">
DROP TABLE IF EXISTS Nutzer;

CREATE TABLE Nutzer (
 Nutzer_ID varchar (20),
 Name varchar (20),
 Vorname varchar (20),
 Geb_datum varchar (10),
 Email varchar (30)
PRIMARY KEY ( Nutzer_ID)
);


INSERT INTO Nutzer VALUES ('123456', 'Meier', 'Fred', '12.04.1998','fred_meier235@gmail.com')
INSERT INTO Nutzer VALUES ('123457', 'Franz', 'Frieda', '01.01.1984', 'f_franz786@gmail.com')
INSERT INTO Nutzer VALUES ('123458', 'März', 'Paul', '22.12.2000', 'P_M12345@gmail.com')
INSERT INTO Nutzer VALUES ('123459', 'Mafai', 'Peter', '16.08.2005', 'P_M654mtr@gmail.com')
INSERT INTO Nutzer VALUES ('123451', 'Röhnsch', 'Lauren', '09.07.2001', 'L_Röhnsch123@gmail.com')

DROP TABLE IF EXISTS Playlist;

CREATE TABLE Playlist (
 Playlist_ID varchar (10),
 Name varchar (20),
 Nutzer_ID varchar (30),
 Anzahl_S varchar (2),
PRIMARY KEY ( Playlist_ID),
FOREIGN KEY ( Nutzer_ID)
);


INSERT INTO playlist VALUES ('65989', 'Jazzy','123456 ', '80')
INSERT INTO playlist VALUES ('27385', 'Boogie', '123459', '34')
INSERT INTO playlist VALUES ('27384', 'Chillout', '123451', '13')
INSERT INTO playlist VALUES ('27389', 'Study musik', '123457', '67')
INSERT INTO playlist VALUES ('27386', 'Rock', '123456', '40')


DROP TABLE IF EXISTS Song;

CREATE TABLE Song (
 Song_ID varchar (10),
 Titel varchar (20),
 Künstler_ID varchar (30)
 Künstler_N varchar (20)
 Dauer varchar ( 4)
 Album_ID varchar (23)
);


INSERT INTO Song VALUES ('098766', 'Starlight','65748 ', 'Rhianna', '2.34','08976')
INSERT INTO Song VALUES ('098764', 'party time', '68654', 'Paris Hilten', '5.00', '02534')
INSERT INTO Song VALUES ('095763', 'summertime', '62974', 'Ed Sheeran', '3.20', '03745')
INSERT INTO Song VALUES ('098762', 'hörst du die Regenwürmer husten', '62938', 'Mark Forster', '3.87', '01632')
INSERT INTO Song VALUES ('094763', 'Rocking Around the Tree', '61429', 'Arianna Grande', '4,21', '06025')
INSERT INTO Song VALUES ('098765', 'breakfast club','65249 ', 'Amy Winehouse', '5.64', '00617')
INSERT INTO Song VALUES ('098753', 'apple pen', '69352', 'Paul Panzer', '3.54', '08907')
INSERT INTO Song VALUES ('098763', 'hit the road jack', '63206', 'Eminem', '6,01', '03420' )


DROP TABLE IF EXISTS enthält;

CREATE TABLE enthält (
 Playlist_ID varchar (10),
 Song_ID varchar (10),
 FOREIGN KEY (Playlist_ID),
 FOREIGN KEY (Song_ID)
);

INSERT INTO enthält VALUES ('65989', '098765')
INSERT INTO enthält VALUES ('65989', '098764')
INSERT INTO enthält VALUES ('27385', '098765')
INSERT INTO enthält VALUES ('27385', '098763')
INSERT INTO enthält VALUES ('27385', '098766')
INSERT INTO enthält VALUES ('27384', '098765')
INSERT INTO enthält VALUES ('27384', '')
INSERT INTO enthält VALUES ('27389', '')
INSERT INTO enthält VALUES ('27389', '098764')
INSERT INTO enthält VALUES ('27389', '098753')
INSERT INTO enthält VALUES ('27386', '098763')
INSERT INTO enthält VALUES ('27386', '098763')



</code>

<run id="697094687f438">
uuu
</run>
PMG2426 1/DB Beleg/Sarah

Suche
