Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- drop table studenten cascade constraints;
- drop table cursussen cascade constraints;
- drop table opleidingen cascade constraints;
- create table studenten (studnr varchar2(3) primary key,
- studnaam varchar2(10),
- leeftijd number(2)
- );
- create table cursussen (cursnmr varchar2(3) primary key,
- cursusnaam varchar2(10),
- lokaal varchar(10),
- aant_uren number(2)
- );
- create table opleidingen (studnr varchar2(3),
- cursnr varchar2(3),
- punten number(4,2),
- primary key(studnr,cursnr),
- foreign key(studnr) references studenten,
- foreign key(cursnr) references cursussen
- );
- -----------------------------------------
- insert into studenten values('s1','jan',20);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement