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
)

drop table edituri

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