Table of Contents

1. Database
2. Author(s)
3. Database description

Database

uic_covid_database

Author(s)

Annsh Agrawaal (aagraw26)

Sahil Gedam (sgedam2)

Database description

We will have a database containing the details of the students that have tested positive for COVID-19 on campus. We will manage the database by having the UIC of the student, CRN's of the classes attended by the student, if the student has campus housing has the student used the rec center, if the student is symptomatic and the quarantine period. If a student is tested positive we can contact the fellow classmates by accessing the CRN of the classes the student has attended. We can also notify campus housing and the rec center and advise them to sanitize the facilities. The system will have a web page to insert UIN and other details of the student, allowing us to gain information of the student. It will also help us report the incident to UI health. This system will be open source and we could not find such an application.

CRUD Entity Screenshots

CRUD for Login User

CRUD for Create Login User

CRUD for Read Login User

CRUD for Update Login User

CRUD for Delete Login User

CRUD for Payment

CRUD for Create Payment

CRUD for Read Payment

CRUD for Update Payment

CRUD for Delete Payment

CRUD for Reservation

CRUD for Create Reservation

CRUD for Read Reservation

CRUD for Update Reservation

CRUD for Delete Reservation

CRUD for UIC_Covid_database

CRUD for Create UIC_Covid_database

CRUD for Read UIC_Covid_database

CRUD for Update UIC_Covid_database

CRUD for Delete UIC_Covid_database

CRUD for Student Contact Info

CRUD for UIC Classes

CRUD for Student Info

#CRUD for Vaccination Card