Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --a
- CREATE TABLE Lagerort (
- KompNr INT NOT NULL,
- FilialID INT NOT NULL,
- Fach text,
- Regalnummer INT,
- Bestand INT,
- PRIMARY KEY (KompNr, FilialID),
- FOREIGN KEY FilialID REFERENCES Filiale(FilialID)
- );
- --b
- CREATE ROLE read_Lagerort;
- GRANT SELECT ON Lagerort TO read_Lagerort;
- --c
- SELECT m.name, k.bezeichnung
- FROM Moebelstueck m
- LEFT OUTER JOIN Katagorie
- ON k.katnr = m.katnr;
- --d
- SELECT *
- FROM Komponente
- ORDER BY preis DESC;
- --e
- SELECT m.name, (k.preis*mk.anzahl) AS "Gesamtpreis"
- FROM Moebelstueck m
- INNER JOIN Moebelstueck_Komponente mk
- ON m.msid = mk.msid
- INNER JOIN Komponente k
- ON k.KompNr = mk.KompNr
- WHERE m.msid = 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement