SHARE
TWEET

Untitled

a guest Feb 20th, 2019 48 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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);
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top