University End Year Project on Querying and Managing Databases
This project creates a Bus Fleet System. A database is created around the tables designed in the files included. The goal is maximize efficiency to perform CRUD queries.
NB: Process of creating this application including the tools used are found in the report word document
- Entities
- Tables
- Attributes
- Fields
- Constraints (FK, PK)
- Triggers
- Scripts
Each bus in the districts of Lesotho are identified and are made distinct to accomodate individuals interested in taking these buses to their destinations. The buses themselves, their seats, and passengers are related and therefore are designed through an ERD before adapting it into a database as part of the bus fleet management system where records can now be kept.