Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE PRODUSE
- ( ID_PRODUS NUMBER(3) PRIMARY KEY,
- PRET NUMBER(8,2),
- DENUMIRE VARCHAR2(30),
- TIP VARCHAR2(10)
- );
- CREATE TABLE CLIENTI
- ( ID_CLIENT NUMBER(7) PRIMARY KEY,
- NUME VARCHAR2(30),
- PRENUME VARCHAR2(30)
- );
- CREATE TABLE VANZARI
- ( ID_PRODUS NUMBER(3),
- DATA_VANZARII DATE,
- ID_CLIENT NUMBER(7),
- CANTITATEA NUMBER(5),
- CONSTRAINT PK_VANZARI
- PRIMARY KEY( ID_PRODUS,
- DATA_VANZARII,
- ID_CLIENT),
- CONSTRAINT FK_VANZARI_PRODUSE
- FOREIGN KEY( ID_PRODUS)
- REFERENCES PRODUSE( ID_PRODUS),
- CONSTRAINT FK_VANZARI_CLIENTI
- FOREIGN KEY( ID_CLIENT)
- REFERENCES CLIENTI( ID_CLIENT)
- );
- DESC PRODUSE;
- DROP TABLE VANZARI;
- DROP TABLE PRODUSE;
- DROP TABLE CLIENTI;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement