Below is the ERD Diagram for the following questions

 

bus BusID (PK) ModelNum Year Capacity ServiceDate StaffID RouteNum taking customer CustomerID (PK) FirstName LastName PhoneNumber Email Address booking D booking BookingID (PK) +JourneyBooking JourneyNumber CustomerNumbe PaymentMethod StaffName StaffID cardholderID CardHolderName CardNumber ServiceCode ExpDate Cash Route D(FK) CustomerID(FK) service DriverD(FK) ServiceID(PK) ServiceNum Date RegNum BusD(FK) ServiceDate takes-H journey service by driving---- StaffAsgmt Driver DriverD(PK) DriverFirstName DriverLastName DriverAddress DriverEmail DriverPhoneNum LicenseNum JourneyID(PK) RemainingCap StaffID also have. H AsgnmentID(PK) BusID(FK) DriversID(FK) H+- --assigned StaffName StaffAsisstID StaffAssistName Duration RouteD(FK) EstArrival EstDeparture BusID(FK) JourneyDate Departure Time ArrivalTime AssignmentD(F AssignmentDate HoursWorked JourneyID(FK) -have- route RouteID(PK) Origin Destination Departure RouteNum Arrival Distance JourneyID(FK)