Question: - create a relational schema table diagram based on the diagram below in 3NF ONLY - underline the primary key with a solid line -
TRUCK PASSENGER DINING TRUCK Cab Size Equipment VENDOR RESERVATION VehicleType ReservationType PickupDate Time VEHICLE Time, Day, Month,Year) ReturnDateTime Time, Day, Month, Year)s assigned a JOB DETAILS ParticipantsNum VehicleYear VehicleClassification VehicleType DateCompleted Destination) ReservationType RENTAL WORK ORDER WorkOrderlD O4Mileage Vehicle Type CUSTOMER BLLING INVOICE FULLTIME MECHANIC Salary is billed CustomerPhoneNumber) CustomerEmail FULLTIME OFFICE(Specialities) HourlyRate Availability PositionTitle CustomerDriversExpiration CustomerType CustomerType EmployeeType EMPLOYEE EmployeeNetID EmployeeFirstName Purpose FACULTY STUDENT SupervisorName Status EmployeeAddr Grade [EmployeePhoneNo) EmployeeType
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
