Database-System-for-Advance-Contact-Tracing-for-Covid-19

A contact-tracing database to keep track of people who have tested positive for Covid-19, their most recent locations and their close contacts.

Functionality

1. Keep track of positive test cases and the most recent locations and close contacts of those cases
2. Keep track of swab tests being carried out and the clinics where there are being conducted at
3. Keep track of check-in and check-out times of people visiting different locations, along with temperature records
4. Keep track of the longitude and latitude of a person's location at regular intervals
5. A messaging forum that allows for administrative staff to post announcements on and for visitors to post reviews/comments about different locations.

Documentation

All documents can be found under the Documentation folder

1. ER Diagram: Lab 1 ER Diagram.png
2. Explanation of the ER Diagram: Lab 1 Report.pdf
3. Query Results on the database: Lab 5 Final Report.pdf
4. Presentation and summary of the project: Final Presentation.pptx

Developed By

1. Bachhas Nikita
2. Delon Lim Long Ting
3. Pang Kee Yang
4. Tan Hui Zhan