PMG2426 1/DB Beleg/Sarah

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

==='' Ziel der Datenbank ''===

===''ERM''===
[[Bild:SaLng_Playlist.png|800px]] 



<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) REFERENCES Nutzer(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),
PRIMARY KEY (Song_ID)
);


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) REFERENCES Playlist(Playlist_ID),
 FOREIGN KEY (Song_ID) REFERENCES Song(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', '098762');
INSERT INTO enthält VALUES ('27389', '098762');
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
