back to CSSE
Capstone schedule
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