Data Dictionary
•Staff - {StaffID, StaffFirstName, StaffLastName, StaffType, StaffLocation,
StaffTitle}
•Drivers - {DriverID, DriverFirstName, DriverLastName, CurrentRoute,
DriverStatus, DriverContactNumber}
•Bus {BusID, BusName,BusRegistrationNumber, BusCapacity, BusMileage,
BusModel,,BusAvailable,BusType}
BusServiceDate,DriverID1,DriverID2,BusDeviceID}
•BusType{BusTypeID,BusTypeDescription}
•Routes {RouteID, DepotID ,RouteOrder, RouteStartLocation,
BusRouteEndLocation }
•RouteSchedule{RouteSceduleID, BusRouteID,DayID}
•Distance
{DistanceID,DistanceFromCPT,DistanceFromPTA,DistanceFromJHB,Dista
nceFromPE,StopID }
•Stopping points {StopID, StopName, StopCity, StopType,RouteID, }
•StopDistances(StopDistanceID,StopDistance,RouteStartDepot,
StopID,StopName}
•Offices {OfficeID, OfficeCity,
OfficeType,OfficeContactNumber,OfficeEmail }
•Depots{DepotID,DepotName,DepotAbbreviation DepotType, Depo
{ContactNumber,DepoContactEmail}
•Locations(LocationID, LocationName, LocationGPS}
•Customer Categories{CustomerCategoryID,CustomerCategoryName }
•Customer Discounts{DiscountID,DiscountName, DiscountAmount,}
•Customers{CustomerID,CustomerFirstName, CustomerLastName,
CustomerIDNumber,CustomType, CustomerNumber,
CustomerEmail,PassengerName }
•Customer Status{CustomerStatusID,CustomerStatusName}
