Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE buch (bnr INTEGER PRIMARY KEY NOT NULL,
- titel VARCHAR(255), seiten INTEGER,
- jahr INTEGER, autor VARCHAR(255));
- CREATE TABLE charakter (cnr INTEGER PRIMARY KEY NOT NULL,
- name VARCHAR(255), vname VARCHAR(255),
- haus VARCHAR(255), rolle VARCHAR(255));
- CREATE TABLE film (fnr INTEGER PRIMARY KEY NOT NULL,
- titel VARCHAR(255), laenge INTEGER,
- jahr INTEGER, buch INTEGER,
- FOREIGN KEY (buch) REFERENCES buch(bnr));
- CREATE TABLE spielt_mit (cnr INTEGER, fnr INTEGER,
- woerter INTEGER,
- FOREIGN KEY (cnr) REFERENCES charakter(cnr)
- FOREIGN KEY (fnr) REFERENCES film(fnr));
- INSERT INTO buch VALUES ('1',
- 'Harry Potter und der ORden des Phoenix',
- '1124',
- '2002',
- 'J.K. Rowling');
- INSERT INTO charakter VALUES('1',
- 'Snape',
- 'Severus',
- 'Slytherin',
- 'Lehrer');
- INSERT INTO film VALUES ('1',
- 'Harry Potter und der Orden des Phoenix',
- '180',
- '2003',
- '1');
- INSERT INTO spielt_mit VALUES ('1','1','8000');
- ALTER TABLE charakter ADD geburtsjahr INTEGER;
- UPDATE charakter SET geburtsjahr=1953 WHERE cnr=1;
- /* Lösungen Abfragen */
- SELECT titel,jahr FROM Album WHERE aid=1;
- SELECT name FROM band WHERE gruendung >= 2000 ORDER BY gruendung DESC;
- SELECT COUNT(kuenstlername) FROM Kuenstler WHERE kuenstlername LIKE 'A%';
- SELECT SUM(gage) FROM ist_mitglied;
- SELECT MAX(preis), MIN(preis) FROM Album;
- SELECT gruendung FROM Band WHERE name LIKE '%/%';
- SELECT name, kid FROM Kuenstler WHERE kuenstlername = 'Tom' OR kuenstlername LIKE 'A%';
- SELECT titel FROM Album WHERE anz_tracks = (SELECT MAX(anz_tracks) FROM Album);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement