db_exam2023

db_exam

group: Exam
Student = {
name, sid
'Peter Verbeeke',1

'Jan Degreef',2

'Natacha Nisez',3

'Tine Vercauteren',4

'Joshua Verkest',5

'Ferdinando Volkaert',6

'Sam Seghers',7

'Emanuel Roels',8

'Peter Vantomme',9

'Gunter Degrootte',10

'Nk Adam',11

'Bart Bonduelle',12

'Lindsey Claes',13

'Davy Kerkaert',14

'Dirk Dewulf',15

'Vincent Soens',16

'Steven Konincks',17

'Michael Bundervoedt',18

'Pieter Salieu',19

'Francis Eeckhout',20

'Alex Maes',21

'Peter Moens',22

'Piet Bergez',23

'Stijn Antonissen',24

'Karen Dujardin',25

'Koen Vandeneinde',26

'Bruno Huybrechts',27

'John Coppens',28

'Hans Winnock',29

'Gert Peeters',30

'Kristof Riviere',31

'Joachim Titeca',32

'Inge Quirynen',33

'Olivier Corvelein',34

'Laurent Naessens',35

'Stefaan Kroon',36

'Elke Everts',37

'David Devey',38

'Sarah Lindekens',39
}

Course = {
cid, name, ECTS
0,'Adaptieve systemen',10

1,'Analytische wiskunde',20

2,'Artificiele Intelligentie',10

3,'Databanken',10

4,'Integraalrekening',20

5,'Internet Systemen',10

6,'Kernfysica',20

7,'Logica',20

8,'Programmeren en design',10

9,'Quantum Fysica',20

10,'Wetenschapsfilosofie',20
}



CourseItem = {
cid, itemname, maxscore, weight
0,'Exam',30,0.5

0,'Project',20,0.5

1,'Exam',50,0.30

1,'Project',20,0.30

1,'Assitance',100,0.40

2,'Exam',40,0.40

2,'Project',40,0.30

2,'Assitance',10,0.30

3,'Exam',25,0.25

3,'Project',25,0.25

3,'Assitance',25,0.25

3,'Forum',25,0.25

4,'Exam',100,0.25

4,'Project',100,0.25

4,'Assitance',100,0.25

4,'Forum',100,0.25

5,'Exam',33,0.33

5,'Project',33,0.33

5,'Forum',33,0.33

6,'Exam',100,1

7,'Project',30,1

8,'Exam',100,0.4

8,'Project',10,0.20

8,'Assitance',10,0.20

8,'Forum',10,0.20

9,'Exam',40,0.4

9,'Project',30,0.30

9,'Assitance',40,0.4

10,'Forum',50,0.5

10,'Assitance',50,0.5
}

Grade = {
cid, itemname, sid, obtainedscore
0,'Exam',1,20
0,'Exam',2,25
0,'Exam',3,14
0,'Exam',4,30
0,'Exam',5,29
0,'Exam',6,22
0,'Exam',7,21
0,'Exam',8,22
0,'Exam',9,10
0,'Project',1,20
0,'Project',2,10
0,'Project',3,19
0,'Project',4,10
0,'Project',5,18
0,'Project',6,17
0,'Project',7,16
0,'Project',8,15
0,'Project',9,11
0,'Project',10,12
1,'Exam',20,40
1,'Exam',21,43
1,'Exam',22,25
1,'Exam',23,42
1,'Exam',24,14
1,'Exam',25,49
1,'Exam',26,24
1,'Exam',27,34
1,'Exam',28,39
1,'Exam',29,38
1,'Exam',30,36
1,'Exam',31,23
1,'Exam',32,25
1,'Exam',33,30
1,'Project',20,6
1,'Project',21,19
1,'Project',22,17
1,'Project',23,15
1,'Project',24,14
1,'Project',25,10
1,'Project',26,11
1,'Project',27,9
1,'Project',28,8
1,'Project',29,10
1,'Project',30,14
1,'Project',31,17
1,'Assitance',10,90
1,'Assitance',20,80
1,'Assitance',21,70
1,'Assitance',22,50
1,'Assitance',23,60
1,'Assitance',24,70
1,'Assitance',25,80
1,'Assitance',26,60
1,'Assitance',27,95
1,'Assitance',28,99
1,'Assitance',29,100
1,'Assitance',30,90
1,'Assitance',11,30
2,'Exam',10,30
2,'Exam',11,20
2,'Exam',12,34
2,'Exam',13,18
2,'Exam',14,25
2,'Exam',15,37
2,'Project',10,32
2,'Project',11,25
2,'Project',12,18
2,'Project',13,20
2,'Project',14,28
2,'Project',15,40
2,'Assitance',10,9
2,'Assitance',11,8
2,'Assitance',12,5
2,'Assitance',13,2
2,'Assitance',14,6
2,'Assitance',15,10
3,'Exam',5,22
3,'Exam',6,10
3,'Exam',7,19
3,'Exam',8,17
3,'Exam',9,18
3,'Exam',10,20
3,'Exam',11,23
3,'Exam',12,15
3,'Exam',13,10
3,'Exam',14,25
3,'Exam',15,20
3,'Project',5,20
3,'Project',6,14
3,'Project',7,15
3,'Project',8,16
3,'Project',9,17
3,'Project',10,10
3,'Project',11,13
3,'Project',12,25
3,'Project',13,20
3,'Project',14,15
3,'Project',15,10
3,'Assitance',5,20
3,'Assitance',6,14
3,'Assitance',7,15
3,'Assitance',18,16
3,'Assitance',19,17
3,'Assitance',20,10
3,'Assitance',11,13
3,'Assitance',12,25
3,'Assitance',13,20
3,'Assitance',14,15
3,'Assitance',15,10
3,'Forum',25,20
3,'Forum',16,14
3,'Forum',17,15
3,'Forum',18,16
3,'Forum',9,17
3,'Forum',10,10
3,'Forum',11,13
3,'Forum',12,25
3,'Forum',13,20
3,'Forum',14,15
3,'Forum',15,10
4,'Exam',32, 90
4,'Exam',33, 40
4,'Exam',34, 50
4,'Exam',35, 60
4,'Exam',36, 70
4,'Exam',37, 80
4,'Exam',38, 100
4,'Project',32, 40
4,'Project',33, 60
4,'Project',34, 70
4,'Project',35, 80
4,'Project',36, 90
4,'Project',37, 90
4,'Project',38, 80
4,'Assitance',32, 100
4,'Assitance',33, 80
4,'Assitance',34, 80
4,'Assitance',35, 90
4,'Assitance',36, 60
4,'Assitance',37, 80
4,'Assitance',38, 70
4,'Forum',32, 50
4,'Forum',33, 60
4,'Forum',34, 90
4,'Forum',35, 70
4,'Forum',36, 70
4,'Forum',37, 60
4,'Forum',38, 65
5,'Exam',15,30
5,'Exam',16,20
5,'Exam',17,23
5,'Exam',18,16
5,'Exam',19,28
5,'Exam',20,33
5,'Exam',21,26
5,'Exam',22,18
6,'Exam',20,80
6,'Exam',21,90
6,'Exam',22,70
6,'Exam',23,60
6,'Exam',24,85
6,'Exam',25,90
6,'Exam',26,50
6,'Exam',27,84
6,'Exam',28,99
7,'Project',35, 20
7,'Project',36, 22
7,'Project',37, 21
7,'Project',38, 18
7,'Project',1, 14
7,'Project',2, 18
}