Use the KCT design model below to complete this case.CUSTOMER(CustomerID, FirstName, LastName, Street, City, State, Zip, Phone)RENTAL(RentalID, RentalDate, NumberOfDays, RentalAmount, Deposit, Tax,TotalAmount, CustomerID, ReturnDate, AmountReturned)LINEITEM(RentalID, ITEMID, Rate, Deposit)ITEM(ITEMID, TypeOfItem)COSTUMETYPE(TypeID, Description, Photo, DailyRentalRate, DepositRate,ReplacementCost)ACCESSORY(AccessoryID, Description, Photo, DailyRentalRate, DepositRate,ReplacementCost, QtyOnHand) where AccessoryID is a FK that matches the ITEMID in theITEM relation. Note, KCT does not track individual accessories, just the group ofaccessories. For example, they may have 20 pirate hats, but only one accessory record forpirate hat.COSTUME(CostumeID, Size, Availability, DatePurchased, CostumeType) whereCostumeID is a FK that matches the ITEMID in the ITEM relation.
a. Assume that we want to record the first and last name of the employee that issues a rentalagreement. Figure out how to best record this information in the model.
b. Assume we also want to record the first and last name of the employee that handled thereturn of the costume for a rental agreement. Figure out how to best record this informationin the model.
c. Assume a customer wants to rent only accessories. How should we handle this?
d. Transform the design into 3NF. Indicate the primary keys, candidate keys, foreign keys,and referential integrity constraints. Make and state assumptions as necessary. Use theinformation from the previous cases to support your assumptions.
e. List any questions that you would like to ask the KCT staff regarding the data model
Attachment:- kct_ch03.accdb 3