Question: Derive functional dependencies given relational notation of each: a) Employee (licenseNo, reservationID, storeNo, discountPercent, category, name, phoneNo, address (city, street, zipCode)) b) Location (storeNo, address
Derive functional dependencies given relational notation of each:
a) Employee (licenseNo, reservationID, storeNo, discountPercent, category, name, phoneNo, address (city, street, zipCode))
b) Location (storeNo, address (city, street, zipCode))
c) Discount (discountPercent, licenseNo, billNo)
d) Bill (billNo, licenseNo, rentalAmount, discountPercent, promoPercent, totalCost)
e) Policy (rentalAmount (class, 1day, 1week, 2week, 1 month) reservationID)
f) Customer (licenseNo, reservationID, promoPercent, name, phoneNo, address(city, street, zipCode))
g) Promo (promoPercent, licenseNo, billNo)
h) Car (licensePlateNo, VIN, storeNo, reservationID, yearMade, color, make, model, class)
Partial functional: licensePlateNo, VIN
i) Reservation (reservationID, licensePlateNo, rentalAmount, licenseNo, VIN, startDate, endDate, meterEnd, meterStart, dropLocation, pickupLocation)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
