Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE Stand(
- nr_standului int CONSTRAINT pk_nrstand PRIMARY KEY,
- numele_vanzatorului varchar2(30) CONSTRAINT nn_numele NOT NULL,
- telefon varchar2(10) CONSTRAINT nn_telefon NOT NULL
- )
- CREATE TABLE Articole(
- cod_articol NUMBER(4) CONSTRAINT pk_cod_articol PRIMARY KEY
- CONSTRAINT ck_cod_articol CHECK (cod_articol>100),
- denumire_articol varchar2(30) CONSTRAINT nn_denumire_articol NOT NULL,
- pret number(6,2) CONSTRAINT nn_pret NOT NULL,
- cantitate number(4) CONSTRAINT nn_cantitate NOT NULL,
- cod_stand number(3) CONSTRAINT nn_cod_stand NOT NULL
- )
- CREATE TABLE Tranzactii(
- cod_tranzactie number(5) CONSTRAINT pk_cod_tranzactie3 PRIMARY KEY
- CONSTRAINT nn_cod_tranzactie3 NOT NULL,
- cod_stand number(3) CONSTRAINT nn_cod_stand3 NOT NULL,
- tipTranzactie varchar2(10) CONSTRAINT nn_tipTranzactie3 NOT NULL,
- cod_articol NUMBER(4) CONSTRAINT nn_cod_articol3 NOT NULL,
- cod_furnizor NUMBER(4) CONSTRAINT nn_cod_furnizor3 NOT NULL,
- cantitate number(4) CONSTRAINT nn_cantitate3 NOT NULL,
- pret_total NUMBER(6,2) CONSTRAINT nn_pret_total3 NOT NULL
- )
- CREATE TABLE Furnizori(
- cod_furnizor NUMBER(4) CONSTRAINT pk_cod_furnizor4 PRIMARY KEY,
- nume_furnizor VARCHAR2(30) CONSTRAINT nn_nume_furnizor4 NOT NULL,
- adresa VARCHAR2(30) CONSTRAINT nn_adresa4 NOT NULL,
- telefon VARCHAR2(10) CONSTRAINT nn_telefon4 NOT NULL
- )
- --LEGATURI DE TABELE--
- ALTER TABLE Tranzactii ADD CONSTRAINT fk_tranz1 FOREIGN KEY (cod_stand) REFERENCES Stand(nr_standului);
- ALTER TABLE Tranzactii ADD CONSTRAINT fk_tranz2 FOREIGN KEY (cod_articol) REFERENCES Articole(cod_articol);
- ALTER TABLE Tranzactii ADD CONSTRAINT fk_tranz3 FOREIGN KEY (cod_furnizor) REFERENCES Furnizori(cod_furnizor);
- ALTER TABLE Articole ADD CONSTRAINT fk_articol FOREIGN KEY (cod_stand) REFERENCES Stand(nr_standului);
- -- CREARE SECVENTA--
- CREATE SEQUENCE cod_articol_seq
- INCREMENT BY 1
- MINVALUE 101
- MAXVALUE 999
- NOCYCLE
- NOCACHE
- ORDER;
- INSERT INTO Stand VALUES (1,'Gigel','1234567890');
- INSERT INTO Stand VALUES (2,'Marcel','0234567891');
- INSERT INTO Articole VALUES(cod_articol_seq.NEXTVAL,'hartie',23.67,5,1);
- INSERT INTO Articole VALUES(cod_articol_seq.NEXTVAL,'pix',27,100,2);
- INSERT INTO Furnizori VALUES(1,'Mihai','Craiova','0123556679');
- INSERT INTO Furnizori VALUES(2,'Ion','Bals','0123564329');
- INSERT INTO Tranzactii VALUES(1,1,'numerar',101,1,4,10);
- select *from Tranzactii;
- INSERT INTO Tranzactii VALUES(1,3,'numerar',101,1,4,10);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement