Finding a substitute class schedule
Outter Join
DOI:
https://doi.org/10.21460/jutei.2023.71.261Keywords:
class schedule, substitute schedule, lecturer schedule, student schedule, room usageAbstract
The class schedule is determined during student registration, but in practice, there is a possibility of schedule failure due to various reasons, such as a lecturer having other important commitments on that schedule, national holidays, or other reasons. According to academic regulations, the number of face-to-face class meetings has been predetermined, which is 14 meetings. Therefore, if a class meeting fails to take place, it must be replaced with a substitute schedule.
Finding a substitute class schedule does not only consider the availability of the respective lecturer's schedule but also takes into account the availability of classrooms and the schedules of each student to ensure that all students can attend (not attending other courses). This way, the substitute schedule can be implemented without disrupting students' activities.
Unlike previous research, which focused on generating class schedules using search and filtering techniques, this study will display all alternative substitute schedules that can be implemented without disturbing the schedules of lecturers, students, or room usage by utilizing multiple table queries with outer join relationships.
Finding a substitute class schedule does not only consider the availability of the respective lecturer's schedule but also takes into account the availability of classrooms and the schedules of each student to ensure that all students can attend (not attending other courses). This way, the substitute schedule can be implemented without disrupting students' activities.
Unlike previous research, which focused on generating class schedules using search and filtering techniques, this study will display all alternative substitute schedules that can be implemented without disturbing the schedules of lecturers, students, or room usage by utilizing multiple table queries with outer join relationships.
Keywords-class schedule, substitute schedule, lecturer schedule, student schedule, room usage.
References
Coronel, Morris and Rob, “Database systems design, implementation ana management,” Cengage Learning. Boston, pp. 11-13, 2013.
Mark Spenik and Orryn Sledge, “Microsoft SQL Server 2000 DBA Survival Guide,” Sams Publishing. Indianapolis, pp. 559-574, 2001.
Hector Garcia-Molina, Jeffrey D. Ullman, dan Jennifer Widom, "Database Systems: The Complete Book", Pearson, pp. 219-220, 2020
Halmos Paul R.,"Naive Set Theory", Springer Science+Business Media New York, pp.1, 1974
https://www.sqlshack.com/dynamic-pivot-tables-in-sql-server/ (Oktober 2021)
https://docs.microsoft.com/en-us/sql/t-sql/queries/from-using-pivot-and-unpivot?view=sql-server-
ver15 (Oktober 2021)
Kenneth E. Kendall and Julie E. Kendall, “System analysis and design,” Prentice Hall. Upper Suddle River, New Jersey, pp. 555-556, 2006.
Raharjo Budi, “Mudah belajar C#,” Penerbit Informatika. Bandung, pp. 2, 2015.
H.M. Dietel, P.J. Dietel, J.A. Listfield, T.R. Nieto, C.H. Yaeger and M. Zlatkina, “C#: A Programmer's introduction,” Prentice Hall. Upper Suddle River, New Jersey, pp. 361, 2003.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2023 Katon Wijana, Yetli Oslan, Harianto Kristanto
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
Authors who publish articles in JUTEI agree on the following rules:
1. The author grants non exclusive royalty free rights, and is willing to publish articles online and complete (full access). With such rights JUTEI reserves the right to save, transfers, manages in various forms, maintains and publishes articles while keeping the author's name as the copyright owner.
2. Each author contained in the article has contributed fully to the substance and intellectual, and is accountable to the public. If in the future there is a copyright infringement notification then this will be responsibility of the author, not JUTEI.
