Guest User

Untitled

a guest
Dec 12th, 2019
77
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE edituri
  2. (
  3. cod number(5) primary key,
  4. nume varchar2(20) not null,
  5. adresa varchar2(50) not null,
  6. telefon varchar2(15)
  7. )
  8.  
  9.  
  10. CREATE TABLE carti
  11. (
  12. cod number(5) not null references edituri(cod),
  13. ide number(5) primary key,
  14. titlu varchar2(30) not null,
  15. autor varchar2(20) not null,
  16. pret number(3) not null
  17. )
  18.  
  19. insert into edituri valeus(1 'NEMIRA 1 Mai, 40, Bucureşti' 0744123567)
  20. insert into edituri valeus(2 'NICULESCU Calea Unirii 23,Bucureşti' 0744123566)
  21. insert into edituri valeus(3 'ALL Calea Unirii 67,Bucureşti' 0744123565)
  22. insert into edituri valeus(4 'ERC PRESS Florilor 1, Bucureşti' 0744123564)
  23. insert into edituri valeus(5 'PETRION Pandurilor 67, Bucureşti' 0744123563)
RAW Paste Data