thomas-schuster · November 24, 2023 11:43
diff --git a/courses.csv b/courses.csv
diff --git a/enrollments.csv b/enrollments.csv
diff --git a/grades.csv b/grades.csv
diff --git a/lecturers.csv b/lecturers.csv
diff --git a/modules.csv b/modules.csv
diff --git a/rooms.csv b/rooms.csv
diff --git a/students.csv b/students.csv
course_id	course_name	lecturer_id	room_id	module_id	ECTS
1	Course 1	84	32	67	4
2	Course 2	32	44	32	4
3	Course 3	40	46	29	4
4	Course 4	72	41	53	6
5	Course 5	83	15	74	3
6	Course 6	10	15	18	4
7	Course 7	62	2	47	3
8	Course 8	72	32	42	3
9	Course 9	11	40	68	6
10	Course 10	24	37	57	6
11	Course 11	17	24	31	3
12	Course 12	94	17	14	4
13	Course 13	39	2	22	4
14	Course 14	88	10	29	4
15	Course 15	17	27	75	3
16	Course 16	22	18	75	6
17	Course 17	7	17	20	3
18	Course 18	61	35	1	6
19	Course 19	54	9	34	4
20	Course 20	10	35	49	3
21	Course 21	25	26	57	6
22	Course 22	73	5	50	3
23	Course 23	29	45	52	4
24	Course 24	33	34	25	6
25	Course 25	47	24	35	4
26	Course 26	28	30	66	6
27	Course 27	9	12	12	3
28	Course 28	100	4	34	3
29	Course 29	1	11	52	4
30	Course 30	97	16	26	3
31	Course 31	47	24	56	3
32	Course 32	93	23	65	3
33	Course 33	69	6	2	3
34	Course 34	8	8	48	4
35	Course 35	20	15	47	3
36	Course 36	88	25	44	3
37	Course 37	90	1	38	4
38	Course 38	88	41	46	4
39	Course 39	15	19	39	4
40	Course 40	25	17	73	3
41	Course 41	12	31	33	3
42	Course 42	18	10	67	4
43	Course 43	96	8	20	6
44	Course 44	36	49	38	4
45	Course 45	8	1	46	4
46	Course 46	44	34	66	6
47	Course 47	87	10	66	6
48	Course 48	98	2	63	4
49	Course 49	92	1	60	6
50	Course 50	55	46	46	3
51	Course 51	40	20	44	3
52	Course 52	33	38	8	4
53	Course 53	67	23	46	3
54	Course 54	68	31	46	4
55	Course 55	39	9	37	6
56	Course 56	87	15	29	4
57	Course 57	22	17	12	4
58	Course 58	64	22	64	3
59	Course 59	14	25	66	4
60	Course 60	2	46	64	6
61	Course 61	59	13	48	6
62	Course 62	50	48	47	4
63	Course 63	16	28	31	4
64	Course 64	38	17	28	6
65	Course 65	20	4	38	4
66	Course 66	103	28	67	6
67	Course 67	7	49	47	3
68	Course 68	72	14	72	6
69	Course 69	31	6	69	4
70	Course 70	78	6	40	3
71	Course 71	67	41	29	3
72	Course 72	26	1	29	6
73	Course 73	24	45	49	3
74	Course 74	18	38	2	4
75	Course 75	41	2	21	6
76	Course 76	39	50	56	4
77	Course 77	67	15	17	4
78	Course 78	25	42	8	4
79	Course 79	5	18	35	4
80	Course 80	67	22	25	3
81	Course 81	10	39	70	6
82	Course 82	59	19	56	3
83	Course 83	75	13	15	4
84	Course 84	53	32	46	4
85	Course 85	48	47	8	4
86	Course 86	8	47	21	3
87	Course 87	67	44	35	4
88	Course 88	64	3	72	4
89	Course 89	88	48	47	6
90	Course 90	56	39	35	3
91	Course 91	33	16	12	4
92	Course 92	90	9	32	6
93	Course 93	66	15	23	4
94	Course 94	36	46	48	3
95	Course 95	73	12	55	6
96	Course 96	86	31	75	6
97	Course 97	52	38	53	6
98	Course 98	60	20	35	6
99	Course 99	79	36	32	4
100	Course 100	101	20	23	4
101	Course 101	31	42	49	4
102	Course 102	22	42	65	4
103	Course 103	3	38	42	3
104	Course 104	90	25	31	3
105	Course 105	47	49	67	4
106	Course 106	93	23	60	3
107	Course 107	11	47	5	3
108	Course 108	40	16	18	4
109	Course 109	100	9	50	3
110	Course 110	74	49	29	4
111	Course 111	89	33	11	4
112	Course 112	54	47	49	4
113	Course 113	2	24	35	6
114	Course 114	57	32	26	4
115	Course 115	19	29	22	4
116	Course 116	101	26	47	6
117	Course 117	26	16	4	6
118	Course 118	98	25	16	3
119	Course 119	47	37	52	4
120	Course 120	13	20	44	3
121	Course 121	41	5	44	3
122	Course 122	84	27	62	3
123	Course 123	68	21	48	6
124	Course 124	78	43	74	3
125	Course 125	32	9	21	3
grade_id	letter_grade	numeric_grade
1	B	72
2	D	97
3	D	97
4	F	11
5	C	77
6	E	24
7	E	56
8	D	5
9	B	2
10	C	69
11	A	44
12	C	33
13	D	30
14	C	66
15	B	68
16	E	90
17	B	9
18	D	46
19	A	45
20	D	46
21	A	77
22	C	69
23	F	97
24	A	4
25	C	63
26	C	48
27	E	16
28	B	97
29	C	3
30	B	81
lecturer_id	name	department
1	Diixgqwn Yztgkz	Mathematics
2	Pbdfdrztv Rqtxnwmdr	Mathematics
3	Zcmpvhqm Azwje	Biology
4	Outrmdndf Xzqsifydg	Biology
5	Mitod Ankvluhw	Physics
6	Pqymvhz Auclf	Computer Science
7	Wgkfinbx Hnbwqaidc	Physics
8	Uvgwa Bkdawzqls	Chemistry
9	Dsukrg Wtxhzzob	Computer Science
10	Unoyncys Hmxspn	Chemistry
11	Qvnyq Vynxsx	Computer Science
12	Cgjoxz Ufottb	Computer Science
13	Kgriwiz Kucbjojfq	Mathematics
14	Ylewpijx Ikoirzfuq	Chemistry
15	Iambcyjl Utvbml	Computer Science
16	Omfbszc Xfbxsfll	Physics
17	Sphcncttm Jdaohhjz	Biology
18	Godhe Pbazvrjh	Physics
19	Fnmouss Toqovjtui	Chemistry
20	Tnoaggsrg Bxcpgzyz	Physics
21	Zzfugs Hfgayrw	Physics
22	Xahgi Vtpalzn	Chemistry
23	Popep Nskvez	Chemistry
24	Lfnnel Ayxqbrdj	Computer Science
25	Ujwpfd Blaullis	Biology
26	Mtsxrslhp Yvjou	Biology
27	Mxbwakrxp Dmzjvlwe	Physics
28	Jpzbveak Xmvzp	Computer Science
29	Dvqxy Plwjcgf	Biology
30	Exczfws Hswhrcd	Chemistry
31	Mehckh Hcxnbu	Mathematics
32	Qgkyuqp Qakzntqer	Mathematics
33	Atmwpjb Ekgjpn	Physics
34	Lmgkctjls Jkftvre	Chemistry
35	Mokvwr Dqzglgoo	Biology
36	Uperxm Rdlkidl	Mathematics
37	Pqvumo Rrkffnr	Physics
38	Vszytpvf Kmhciult	Computer Science
39	Avxfzu Hlcmibhbe	Biology
40	Lmthmfex Mpxvoue	Mathematics
41	Iaucuh Qvhkbect	Physics
42	Cukchloco Dkipgb	Chemistry
43	Gqmde Oultjs	Computer Science
44	Ewapzhp Ovmwktxr	Physics
45	Oirfvjmc Uttny	Mathematics
46	Ullsxp Fzvse	Mathematics
47	Tkrdfd Riqlibs	Chemistry
48	Ccajyny Eakqppxt	Chemistry
49	Mxhlpu Kfnnz	Mathematics
50	Yawvs Lmmjwzzp	Computer Science
51	Eigms Whpub	Computer Science
52	Zmbyaq Njbrwx	Computer Science
53	Ffdrvp Nslcvrd	Biology
54	Rylvgrm Tkccmkq	Chemistry
55	Iohehdyft Gddlkm	Mathematics
56	Hptsho Pqqfxjqjm	Biology
57	Sycjzbfqj Fwols	Biology
58	Gcrjxklik Jsayph	Computer Science
59	Vcpga Vwgkk	Computer Science
60	Ltepqd Ehcvuh	Biology
61	Koasgila Vhahveeln	Physics
62	Mikyndbf Ppiyitlc	Mathematics
63	Kdbgu Vobioomhs	Biology
64	Xaohnap Xcglwz	Mathematics
65	Csiturxf Exnvxxjno	Mathematics
66	Jlujfrvah Hfvzph	Physics
67	Hvgcrubw Ixxbrzus	Computer Science
68	Ahffisaw Wrjjpr	Mathematics
69	Yyfosoa Vzinc	Biology
70	Wcylkfwdv Dzlwfv	Physics
71	Tbzuwipx Uoeycbo	Mathematics
72	Munoicu Inrgu	Mathematics
73	Okpobl Elditxjts	Physics
74	Amtxztj Tfivxjoij	Computer Science
75	Ghnteivlu Cxwwgi	Mathematics
76	Dapnhm Ybyaui	Chemistry
77	Igshycx Hwdvu	Biology
78	Hzxrpn Qsgeke	Computer Science
79	Ycaym Ubuaw	Chemistry
80	Jbhowgjla Syykmt	Biology
81	Hmrzqgs Cumjgich	Physics
82	Kbobljehq Ibpen	Biology
83	Uphcwxnh Wktdnoxjl	Chemistry
84	Pacvyzayd Frjpj	Computer Science
85	Abeti Jgwvrd	Physics
86	Ancxjw Ipzhjkxbw	Physics
87	Haslqt Thwujt	Chemistry
88	Qgvqtja Ohosrii	Chemistry
89	Pxjyu Szkvw	Biology
90	Znhtwy Ntplkbifz	Biology
91	Zxzqcp Tobvdbvc	Computer Science
92	Mtpwm Nhuee	Chemistry
93	Ipmxnunv Matydk	Physics
94	Wjbecpe Jfzllh	Mathematics
95	Ghimqiats Yipchj	Biology
96	Leray Ygcfxfpdu	Biology
97	Ihjibyaf Ytklz	Physics
98	Wvwdd Cxauxwzpa	Physics
99	Itssqjkt Ylchai	Chemistry
100	Pdyqw Tsakfk	Computer Science
101	Kwynfwzn Qlucsb	Physics
102	Tgglywldk Gsgaml	Chemistry
103	Nemzf Wsgbklbto	Biology
module_id	module_name	description
1	Module 1	Description of Module 1
2	Module 2	Description of Module 2
3	Module 3	Description of Module 3
4	Module 4	Description of Module 4
5	Module 5	Description of Module 5
6	Module 6	Description of Module 6
7	Module 7	Description of Module 7
8	Module 8	Description of Module 8
9	Module 9	Description of Module 9
10	Module 10	Description of Module 10
11	Module 11	Description of Module 11
12	Module 12	Description of Module 12
13	Module 13	Description of Module 13
14	Module 14	Description of Module 14
15	Module 15	Description of Module 15
16	Module 16	Description of Module 16
17	Module 17	Description of Module 17
18	Module 18	Description of Module 18
19	Module 19	Description of Module 19
20	Module 20	Description of Module 20
21	Module 21	Description of Module 21
22	Module 22	Description of Module 22
23	Module 23	Description of Module 23
24	Module 24	Description of Module 24
25	Module 25	Description of Module 25
26	Module 26	Description of Module 26
27	Module 27	Description of Module 27
28	Module 28	Description of Module 28
29	Module 29	Description of Module 29
30	Module 30	Description of Module 30
31	Module 31	Description of Module 31
32	Module 32	Description of Module 32
33	Module 33	Description of Module 33
34	Module 34	Description of Module 34
35	Module 35	Description of Module 35
36	Module 36	Description of Module 36
37	Module 37	Description of Module 37
38	Module 38	Description of Module 38
39	Module 39	Description of Module 39
40	Module 40	Description of Module 40
41	Module 41	Description of Module 41
42	Module 42	Description of Module 42
43	Module 43	Description of Module 43
44	Module 44	Description of Module 44
45	Module 45	Description of Module 45
46	Module 46	Description of Module 46
47	Module 47	Description of Module 47
48	Module 48	Description of Module 48
49	Module 49	Description of Module 49
50	Module 50	Description of Module 50
51	Module 51	Description of Module 51
52	Module 52	Description of Module 52
53	Module 53	Description of Module 53
54	Module 54	Description of Module 54
55	Module 55	Description of Module 55
56	Module 56	Description of Module 56
57	Module 57	Description of Module 57
58	Module 58	Description of Module 58
59	Module 59	Description of Module 59
60	Module 60	Description of Module 60
61	Module 61	Description of Module 61
62	Module 62	Description of Module 62
63	Module 63	Description of Module 63
64	Module 64	Description of Module 64
65	Module 65	Description of Module 65
66	Module 66	Description of Module 66
67	Module 67	Description of Module 67
68	Module 68	Description of Module 68
69	Module 69	Description of Module 69
70	Module 70	Description of Module 70
71	Module 71	Description of Module 71
72	Module 72	Description of Module 72
73	Module 73	Description of Module 73
74	Module 74	Description of Module 74
75	Module 75	Description of Module 75
room_id	building	room_number
1	Building A	R1
2	Building A	R2
3	Building A	R3
4	Building C	R4
5	Building B	R5
6	Building A	R6
7	Building C	R7
8	Building B	R8
9	Building B	R9
10	Building C	R10
11	Building C	R11
12	Building C	R12
13	Building A	R13
14	Building A	R14
15	Building C	R15
16	Building A	R16
17	Building A	R17
18	Building B	R18
19	Building C	R19
20	Building C	R20
21	Building C	R21
22	Building B	R22
23	Building A	R23
24	Building A	R24
25	Building A	R25
26	Building B	R26
27	Building B	R27
28	Building B	R28
29	Building A	R29
30	Building C	R30
31	Building C	R31
32	Building B	R32
33	Building A	R33
34	Building C	R34
35	Building B	R35
36	Building A	R36
37	Building A	R37
38	Building B	R38
39	Building A	R39
40	Building B	R40
41	Building B	R41
42	Building A	R42
43	Building B	R43
44	Building B	R44
45	Building C	R45
46	Building C	R46
47	Building C	R47
48	Building C	R48
49	Building B	R49
50	Building C	R50