drop table NBStudents;
create table NBStudents
(
	Name char(40),
	CprNr char(10),
	HoldNr char(1),
	Semester int,
	PRIMARY KEY(CprNr)
);
insert into NBStudents values ('Arkibald Hansen', '0404191012', 'e', 3);
insert into NBStudents values ('Bertram Fuskefod', '1010092020', 'a', 2);
insert into NBStudents values ('Karl koder', '1006805151', 'b', 4);

drop table NBFag;
create table NBFag
(
	Name char(40),
	FagID int,
	Type int,
	Semester int, 
	PRIMARY KEY(FagID)
);
insert into NBFag values ('Programmering', 1, 2, 1);
insert into NBFag values ('Mundtlig Programmering', 2, 1, 2);
insert into NBFag values ('SystemUdvikling', 3, 1, 2);
insert into NBFag values ('Datamatiske Systemer', 4, 2, 3);
insert into NBFag values ('SystemUdvikling af Store systemer', 5, 1, 3);
insert into NBFag values ('Valgfag', 6, 1, 4);
insert into NBFag values ('Systemudvikling i perspektiv', 7, 1, 4);
insert into NBFag values ('HovedOpgave', 8, 1, 5);

drop table NBgraduate;
create table NBgraduate
(
	CprNr char(10),
	FagID int,
	Result char(2),
	PRIMARY KEY(CprNr, FagID)
);
insert into NBgraduate values ('0404191012', 1, '10');
insert into NBgraduate values ('0404191012', 2, '8');
insert into NBgraduate values ('0404191012', 3, '9');
insert into NBgraduate values ('1010092020', 1, '6');
insert into NBgraduate values ('1006805151', 1, '11');
insert into NBgraduate values ('1006805151', 2, '10');
insert into NBgraduate values ('1006805151', 3, '10');
insert into NBgraduate values ('1006805151', 4, '11');
insert into NBgraduate values ('1006805151', 5, '9');
insert into NBgraduate values ('1006805151', 6, '11');






