CREATE TABLE edituri
(
 cod number(5) primary key,
 nume varchar2(20) not null,
 adresa varchar2(50) not null,
 telefon varchar2(15)
)


CREATE TABLE carti
(
 cod number(5) not null references edituri(cod),
 ide number(5) primary key,
 titlu varchar2(30) not null,
 autor varchar2(20) not null,
 pret number(3) not null
)

insert into edituri valeus(1 'NEMIRA 1 Mai, 40, Bucureşti' 0744123567)
insert into edituri valeus(2 'NICULESCU Calea Unirii 23,Bucureşti' 0744123566)
insert into edituri valeus(3 'ALL Calea Unirii 67,Bucureşti' 0744123565)
insert into edituri valeus(4 'ERC PRESS Florilor 1, Bucureşti' 0744123564)
insert into edituri valeus(5 'PETRION Pandurilor 67, Bucureşti' 0744123563)