DATABASE PROJECT-bsc/lmr/1882/19
PROBLEM STATEMENT
Fast lane matatu Sacco intends to create a database that will store its information and
help to effectively run its day to day activities. In the transport industry where data changes from
time to time, it was necessary to move from writing records on books to a computerized database
system. The sacco management wanted a system that would capture the relevant information
concerning its key stakeholders, that is, matatu owners, the matatus, drivers, conductors as well
as the travel routes.
OBJECTIVES
The intended database system would serve the function of capturing the relevant data for
solving of issues such as payment of salaries, shift allocation to the workers, fare regulation,
insurance issues and general data fetch searches. The system would also accurately capture
workers responsible for a certain vehicle over a certain period of time for accountability.
DATA REQUIREMENTS
A total of five entities were identified for the system. They include Matatus, drivers,
conductors, travel routes and Matatu owners. All these had their attributes as illustrated in the
ERD diagram
