UWB Logo

Computer Science and Software Engineering Capstone Presentations

Summer Quarter

August 21, 2020

Andrei Morozov

"Virtual Academic Advisor: Implementation of Corequisites and Electives in Database"

(UWB CSS Faculty Research)

Faculty Advisor: Dr. Erika Parsons

Abstract

During my capstone, I worked on the Virtual Academic Advisor's database to implement a way to store corequisites for courses and electives for majors. The VAA project can create schedules based on a fixed list of classes, but there can be multiple variations of classes or classes that must be taken at the same time as other classes. The schedules do not consider what corequisites occur which can be an issue when classes are intended to be taken in at the same time. Throughout the quarter, I designed a way to store electives for majors and corequisites in an effective format and to address concerns over our server's limited storage capacity. As a result of this implementation, we can create valid schedules for majors that can have multiple variations on classes. In addition to this, the storage shortage was diagnosed and addressed, allowing us to have more storage on our server for additional aspects of the database and our APIs. Because the VAA project now has populated corequisite-related and elective-related tables, future generated schedules to have correctly scheduled corequisite classes and valid variations of electives would allow us to compete with commercial solutions already in use. In the future, we can use the expand the use of the elective and corequisite tables to generate similar schedules for other academic institutions.

Updated August 20, 2020, 13:34