Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE dobavljac
- (
- idd INTEGER NOT NULL,
- nazd varchar2(20) NOT NULL,
- mesd varchar2(20),
- CONSTRAINT dobavljac_PK PRIMARY KEY (idd)
- );
- INSERT INTO dobavljac VALUES (1, 'Alfa', 'Novi Sad');
- INSERT INTO dobavljac VALUES (2, 'Omega', 'Beograd');
- INSERT INTO dobavljac VALUES (3, 'Kurir', 'Novi Sad');
- INSERT INTO dobavljac VALUES (4, 'Hermes', 'Subotica');
- INSERT INTO dobavljac VALUES (5, 'MB Trade', 'Beograd');
- commit;
- CREATE TABLE projekti
- (
- idp INTEGER NOT NULL,
- nazp varchar2(20) NOT NULL,
- mesp varchar2(20),
- CONSTRAINT projekti_PK PRIMARY KEY (idp)
- );
- ALTER TABLE projekti MODIFY (nazp varchar2(40));
- ALTER TABLE projekti MODIFY (idp varchar2(2));
- INSERT INTO projekti VALUES ('p1', 'Rekonstrukcija vodovoda', 'Novi Sad');
- INSERT INTO projekti VALUES ('p2', 'Rekonstrukcija kanalizacije', 'Beograd');
- INSERT INTO projekti VALUES ('p3', 'Rekonstrukcija necega', 'Beograd');
- INSERT INTO projekti VALUES ('p4', 'Rekonstrukcija nekakve centrale', 'Novi Sad');
- commit;
- CREATE TABLE deo
- (
- iddeo varchar2(2) NOT NULL,
- nazp varchar2(20) NOT NULL,
- cena INTEGER,
- CONSTRAINT deo_PK PRIMARY KEY (iddeo)
- );
- INSERT INTO deo VALUES ('d1', 'pvc cev', 1000);
- INSERT INTO deo VALUES ('d2', 'celicna cev', 1510);
- INSERT INTO deo VALUES ('d4', 'gorionik', 7000);
- INSERT INTO deo (iddeo, nazp) VALUES ('d3', 'sraf');
- INSERT INTO deo (iddeo, nazp) VALUES ('d5', 'cement 50');
- commit;
- CREATE TABLE nabavka
- (
- idd INTEGER NOT NULL,
- idp varchar2(2) NOT NULL,
- iddeo varchar2(2) NOT NULL,
- kol INTEGER,
- CONSTRAINT nabavka_PK PRIMARY KEY (idd, idp, iddeo),
- CONSTRAINT nabavka_dobavljac_FK FOREIGN KEY (idd) REFERENCES dobavljac (idd),
- CONSTRAINT nabavka_projekat_FK FOREIGN KEY (idp) REFERENCES projekti (idp),
- CONSTRAINT nabavka_deo_FK FOREIGN KEY (iddeo) REFERENCES deo (iddeo)
- );
- INSERT INTO nabavka VALUES (1, 'p2', 'd1', 500);
- INSERT INTO nabavka VALUES (3, 'p1', 'd1', 300);
- INSERT INTO nabavka VALUES (1, 'p2', 'd2', 400);
- INSERT INTO nabavka VALUES (3, 'p3', 'd2', 320);
- INSERT INTO nabavka VALUES (3, 'p2', 'd1', 2000);
- INSERT INTO nabavka VALUES (2, 'p1', 'd1', 1200);
- INSERT INTO nabavka VALUES (4, 'p3', 'd2', 750);
- INSERT INTO nabavka VALUES (5, 'p2', 'd4', 750);
- commit;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement