group: DBS1 Student Course Enroll
description[[Aufgaben des Praktikums]]

STUDENT = {
SSN, Name, Major, Bdate

927397, 'Anna', 'Medieninformatik', '2001-01-03'
928435, 'Bernd', 'Medientechnik', '2001-02-23'
928521, 'Christian', 'Medieninformatik', '2000-03-12'
931245, 'Daniel', 'Medieninformatik', '2001-04-09'
920148, 'Tom', 'Medientechnik', '2000-05-20'
912393, 'Katharina', 'Medieninformatik', '2001-12-06'
930941, 'Anna', 'Medientechnik', '2002-01-29'
928692, 'Katharina', 'Medientechnik', '1999-04-30'
949863, 'Daniel', 'Medientechnik', '2003-06-17'
949176, 'Nina', 'Medieninformatik', '2003-10-28'
939996, 'Emma', 'Medieninformatik', '2002-07-04'
933948, 'David', 'Medieninformatik', '2002-08-01'
937847, 'Florian', 'Medieninformatik', '2002-09-15'
941389, 'Alex', 'Medieninformatik', '2004-11-20'
}



COURSE = {
CourseId, Cname, Dept

1, 'OOP1', 'Medien'
2, 'OOP2', 'Medien'
3, 'DBS1', 'Medien'
4, 'Bildtechnik', 'Medien'
5, 'SWE', 'Informatik'
6, 'FMA', 'Informatik'
7, 'Mediengestaltung 1', 'Design'
8, 'Mediengestaltung 2', 'Design'
9, 'Web-Programmierung', 'Informatik'
}



ENROLL = {
SSN, CourseId, Quarter, Grade

927397, 1, 'WiSe 2020', 67
928521, 1, 'WiSe 2020', 45
927397, 2, 'SoSe 2021', NULL
931245, 2, 'SoSe 2021', NULL
949863, 3, 'SoSe 2021', NULL
927397, 5, 'WiSe 2020', 78
928435, 9, 'WiSe 2020', 23
931245, 9, 'WiSe 2020', 49
912393, 9, 'WiSe 2020', 87
930941, 9, 'WiSe 2020', 100
920148, 9, 'WiSe 2020', 82
928521, 9, 'WiSe 2020', 63
930941, 6, 'SoSe 2021', NULL
920148, 7, 'WiSe 2020', 96
920148, 8, 'SoSe 2021', NULL
}



BOOK_RECOMMENDATION = {
CourseId, Quarter, Book_ISBN

1, 'WiSe 2019', '978-3966450539'
3, 'SoSe 2021', '978-3446409446'
6, 'SoSe 2021', '978-3486714036'
9, 'WiSe 2020', '978-3827317186'
}



BOOK = {
Book_ISBN, Book_Title, Publisher, Author

'978-3966450539', 'Java: Kompendium', 'BMU Verlag', 'Neumann'
'978-3446409446', 'Taschenbuch Datenbanken', 'Carl Hanser Verlag', 'Kudrass'
'978-3486714036', 'Algorithmen und Datenstrukturen', 'Oldenbourg Wissenschaftsverlag', 'Blum'
'978-3827317186', 'Workshop Javascript', 'Addison-Wesley', 'Mintert'
'978-3827428349', 'Software-Architektur kompakt', 'Spektrum Akademischer Verlag', 'Starke'
'978-3658207045', 'Programmierung in Python', 'Springer Vieweg', 'Steyer'
}