CityConnect Bus DBMS

I designed and implemented a database that handles the data of a fictitious local bus company, CityConnect Bus! Timetables and data of customers, drivers, and bus fleets can be stored and viewed from this database. This database can be used by local transportation companies for various purposes like efficiency, punctuality, etc.

Project Description

Contents

1. Project Description
2. User Views
   1. TimeTable at a Station
   2. Ride History of a Customer
   3. Card Balance History of a Customer
   4. Driver Schedule
   5. Driver Monthly Salary Report
   6. Bus Fleet Management
3. Normalization
4. ER Diagram
5. Attribute-Domain Listing
6. Attribute-User View Matrix
7. Business Rules

SQL Files

• Data Insertion
• Queries
  1. TimeTable at a Station
  2. Ride History of a Customer
  3. Card Balance History of a Customer
  4. Driver Schedule
  5. Driver Monthly Salary Report
  6. Bus Fleet Management