Baze de date

TABELE DE DATE:

Clienti

Cnp Nume Prenume Telefon oras

2450119170042 Morov Violeta 021567456 Bucuresti

1840916510612 Amariei Catalin 0236442492

2530214511616 Bichir Cristina 067342123 Bacau

1680715512615 Carp Nicu 0745678345 Sibiu

2701010511618 Munteanu Alina 0785674345 Bucuresti

1700102511610 Necula Alexandru 0723456789 Bucuresti

Facturi

Codfact Cnp Codprod Cantitate Pret data

98675 1680715512615 10 100 5 10-10-2008

87654 1700102511610 14 80 3 11-10-2008

34545 1680715512615 30 50 8 08-08-2008

23432 1680715512615 20 150 2 20-12-2008

12232 2530214511616 45 90 10 07-01-2009

12233 2530214511616 20 30 15 12-12-2008

Produse

Codprod Numeprod Cantitate um

30 Banane 100 Kg

14 Kiwi 231 Buc

10 Mere 508 Kg

20 Portocale 120 Kg

45 Pere 340 buc

Import

Numeprod Cantitate pret

Banane 260 5

Kiwi 300 2

Cocos 80 10

Mere 670 3

Pere 500 11

Portocale 150 11

DROP TABLE clienti CASCADE CONSTRAINTS;

DROP TABLE facturi CASCADE CONSTRAINTS;

DROP TABLE produse CASCADE CONSTRAINTS;

DROP TABLE importuri CASCADE CONSTRAINTS;

--crearea tabelelor

create table clienti

( cnp varchar2(13) constraint cnp_pk primary key,

nume varchar2(15) not null,

prenume varchar2(32) not null,

tel number(12) not null,

oras varchar2(16)

);

create table facturi

( codfact number(13) constraint codfact_pk primary key,

cnp varchar2(13) constraint cnp_fk foreign key(cnp) references(clienti),

codprod number(7) constraint codprod_fk foreign key(codprod) references (produse),

cantitate number(4),

pret number(4),

dataf data

);

create table produse

( codprod number(13) constraint codprod_pk primary key,

numeprod varchar2(13) constraint cnp_fk foreign key(numeprod) references(import),

cantitate number(5) not null,

um varchar2(16)

);

create table import

( numeprod varchar2(13) constraint codprod_pk primary key,

cantitate number(5),

pret number(3)

);

POPULAREA TABELELOR

INSERT INTO CLIENTI VALUES('2450119170042','Morov','Violeta','021567456','Bucuresti');

INSERT INTO CLIENTI VALUES('1840916510612','Amariei','Catalin',' 0236442492');

INSERT INTO CLIENTI VALUES('2530214511616','Bichir','Cristina', '0454534354','Bacau');

INSERT INTO CLIENTI VALUES('1523425382894','Carp','Nicu','0765350982','Sibiu');

INSERT INTO CLIENTI VALUES('2728331142134','Munteanu','Alina','0731122995','Bucuresti');