UBC CPSC 304: Introduction to Relational Databases

This project is a website that simulates a COVID-19 immunization system from multiple perspectives (i.e. from the POVs of the general public and staff).

The project is written in PHP with an HTML/CSS front-end and an Oracle database backend hosted on the UBC undergrad CS servers.

Usage:

• milestone_4.pdf - pdf containing cover page, project descriptions, and screenshots
• immunizesys.sql - SQL script used to create and populate all the tables in the database
• sql_queries.sql - SQL script which lists all the queries used
• public_html - folder containing all files for the front-end and back-end of the website
• Screenshots - folder containing screenshots of sample outputs of the queries on the GUI/terminal
• final_ERD.png - image of the final ERD (entity relationship diagram)