A copy of the project repository for CPSC 304: Introduction to Relational Databases by the University of British Columbia. Our objective was design a database with an interactive GUI application.
- (49330046) Adeeb Khan
- (13046024) Dwayne Dmello
- (67719955) Theo Obadiah Teguh
This project involves the development of a database system tailored for multi-level car parks. This application is designed to streamline the management of parking facilities, providing a solution for overseeing operations, assessing profitability, and analyzing car distribution within a network of parking lots. The primary goal is to enhance efficiency and user experience in parking lots while addressing common challenges such as finding parking spaces in crowded areas, locating parked cars, and planning ahead for reservations.
Adeeb was in charge of full-stack development, Dwayne administered the database on AWS Cloud and assisted in the creation of SQL queries. Theo took responsibility for database design, SQL Data Definition Language along with other queries, and process automation. The contents listed here were copied from the original repository administered under the official University of British Columbia GitHub enterprise account.
Our database can explained with the following Entity Relationship Diagram. Please note that the following figure has been reviewed and updated over the first two project milestones.
The following resources were useful in preparing and deploying the web application.