- create a relational schema table diagram based on the diagram below in 3NF ONL
ID: 3732021 • Letter: #
Question
- create a relational schema table diagram based on the diagram below in 3NF ONLY - underline the primary key with a solid line - underline the foreign key(s) with a broken line - if there is a foreign key show the relation it references with an arrowTRUCK 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
Explanation / Answer
Underline attributes are Primary key for that relation and bold attribute are Foreign Key in that relation.
MVR entity is a Weak Entity it is enclosed under double line . MVR entity Confirmation attribute has multiple values.
The relational Schema for the ER diagram is below:
(a) Vendor(VendorID, VendorName,VendorLocation)
(b) Vehicle(VIN,VehicleMake, VehicleModel,VehicleYear,VehicleClassification,VehicleType,MaxPassengers , FuelType, VendorID)
(b1) Truck(Cab_Size,VIN)
(b2) PassengerVan(NumRows,VIN)
(b3) Dinningtruck(Equipment ,VIN)
(c) Job_Details(VendorInvoiceNo,DateCompleted,Description,VendorID ,VIN)
(d) Rental(ConfirmationNo, LengthRes,Mileage,VehicleType,CustomerNetID, VIN)
(e) Work_order(WorkorderID, DateComp,Description ,VIN , EmployeeID)
(f) Reservation(ReservationID , ReservationType,PickupDateTime, ReturnDateTime, VehicleRequest, ParticipantsNum, BusinessPurpose,Comment,ReservationTYpe,DailyRate,MileageAllowance,MontylyRate, VIN)
(g) Customer(CustomerNetID, CustomerFirstName ,CustomerLastName, CustomerPhoneNumber, CustomerEmail, CustomerDriversLicenseNo,CustomerLicenseSt,CustomerDriversExpiration,CustomerType, ReservationID)
(g1) Faculty(SupervisorName, Department, CustomerID)
(g2) Student(StudentID, Grade, CustomerID)
(g21) MVR(ConfirmationNo, Purpose,SupervisorNetID,Status,DateCompleted , StudentID)
(h) Billing_Invoice(InvoiceID , AccountNum,AccountPercentage,BillingDate, CustomerNetId, ConfirmationNo)
(i) Employee(EmployeeID, EmplopyeeNetId , EmplopyeeFirstName ,EmplopyeeLastName ,EmplopyeeStreet , EmplopyeeCity , EmplopyeeState ,EmplopyeeZip)
(i1) Fulltime_office(Salary,PositionTitle, EmployeeID)
(i2) Fulltime_mechanic(Salary, HourlyChargeRate, EmplopyeeID)
(i3) Parttime(HourlyRate, Availability, EmplopyeeID)
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.