Advertisement
Guest User

Untitled

a guest
Feb 20th, 2019
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.70 KB | None | 0 0
  1. drop table studenten cascade constraints;
  2. drop table cursussen cascade constraints;
  3. drop table opleidingen cascade constraints;
  4. create table studenten (studnr varchar2(3) primary key,
  5. studnaam varchar2(10),
  6. leeftijd number(2)
  7. );
  8. create table cursussen (cursnmr varchar2(3) primary key,
  9. cursusnaam varchar2(10),
  10. lokaal varchar(10),
  11. aant_uren number(2)
  12. );
  13. create table opleidingen (studnr varchar2(3),
  14. cursnr varchar2(3),
  15. punten number(4,2),
  16. primary key(studnr,cursnr),
  17. foreign key(studnr) references studenten,
  18. foreign key(cursnr) references cursussen
  19. );
  20.  
  21.  
  22.  
  23. -----------------------------------------
  24. insert into studenten values('s1','jan',20);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement