PMG2224 4/DB Beleg/Magdalena

Aus ProgrammingWiki
Wiki-Quelltext dieser Seite.
<language>SQL</language>
===DBMS für den Musikgeschmack von Konsumenten===

==Ziel der Datenbank==





<code id="65f9f20ebf697">

CREATE TABLE Musik (
    Künstler_ID INT PRIMARY KEY,
    Künstler_Name VARCHAR(255),
    Genre VARCHAR(50),
    Albumanzahl INT,
    Zuhörer_pro_Monat INT
);

CREATE TABLE Person (
    Person_ID INT PRIMARY KEY,
    Vorname VARCHAR(50),
    Nachname VARCHAR(50),
    Musikgeschmack VARCHAR(100),
    Lieblingskünstler VARCHAR(100)
);

</code>

<code id="65f9f20ebf6eb">

INSERT INTO Musik VALUES (1, 'The Beatles', 'Rock', 12, 5000000);
INSERT INTO Musik VALUES (2, 'Beyoncé', 'Pop', 8, 3000000);
INSERT INTO Musik VALUES (3, 'Mozart', 'Classical', 25, 100000);
INSERT INTO Musik VALUES (4, 'Eminem', 'Hip Hop', 10, 2000000);
INSERT INTO Musik VALUES (5, 'Adele', 'Pop', 3, 1500000);
INSERT INTO Musik VALUES (6, 'Queen', 'Rock', 15, 4000000);
INSERT INTO Musik VALUES (7, 'Taylor Swift', 'Pop', 9, 2500000);
INSERT INTO Musik VALUES (8, 'Beethoven', 'Classical', 30, 80000);
INSERT INTO Musik VALUES (9, 'Jay-Z', 'Hip Hop', 11, 1800000);
INSERT INTO Musik VALUES (10, 'Coldplay', 'Rock', 7, 3500000);
INSERT INTO Musik VALUES (11, 'Rihanna', 'Pop', 6, 2800000);
INSERT INTO Musik VALUES (12, 'Chopin', 'Classical', 20, 90000);
INSERT INTO Musik VALUES (13, 'Kendrick Lamar', 'Hip Hop', 5, 2200000);
INSERT INTO Musik VALUES (14, 'Ed Sheeran', 'Pop', 4, 1700000);
INSERT INTO Musik VALUES (15, 'Led Zeppelin', 'Rock', 9, 3800000);

INSERT INTO Person VALUES (1, 'Anna', 'Schmidt', 'Pop', 'Adele');
INSERT INTO Person VALUES (2, 'Max', 'Müller', 'Rock', 'Queen');
INSERT INTO Person VALUES (3, 'Lena', 'Fischer', 'Electronic', 'Daft Punk');
INSERT INTO Person VALUES (4, 'Tom', 'Wagner', 'Hip Hop', 'Kendrick Lamar');
INSERT INTO Person VALUES (5, 'Sophie', 'Keller', 'Classical', 'Mozart');
INSERT INTO Person VALUES (6, 'Paul', 'Becker', 'Indie', 'Arctic Monkeys');
INSERT INTO Person VALUES (7, 'Laura', 'Hoffmann', 'Jazz', 'Miles Davis');
INSERT INTO Person VALUES (8, 'Felix', 'Schulz', 'Country', 'Johnny Cash');
INSERT INTO Person VALUES (9, 'Julia', 'Weber', 'Reggae', 'Bob Marley');
INSERT INTO Person VALUES (10, 'Simon', 'Lehmann', 'Metal', 'Metallica');
INSERT INTO Person VALUES (11, 'Maria', 'Bauer', 'Blues', 'B.B. King');
INSERT INTO Person VALUES (12, 'David', 'Koch', 'Funk', 'James Brown');
INSERT INTO Person VALUES (13, 'Nina', 'Schneider', 'R&B', 'Beyoncé');
INSERT INTO Person VALUES (14, 'Tim', 'Hansen', 'Alternative', 'Radiohead');
INSERT INTO Person VALUES (15, 'Lisa', 'Schwarz', 'Soul', 'Aretha Franklin');

</code>

<run id="65f9f20ebf774"></run>
PMG2224 4/DB Beleg/Magdalena

Suche
