Reference no: EM13841622
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
|
Medium access control methods
: Task 1: Both the CSMA/CD with Token bus medium access control methods can be used in real time systems. Which one is better suited for real time applications? Explain.
|
|
The consolidated ?nancial statements present fairly
: In our opinion, the consolidated ?nancial statements present fairly, in all material respects, the ?nancial position of R&R and its subsidiaries as of December 31, 2009, and the results of their operations and their cash ?ows for the ?scal year ended..
|
|
Specification of tables-attributes
: Handle costumes & accessories by using subtypes/supertypes, and show the ERD from all information we have gathered for the KCT. Your design should include a specification of tables, attributes, primary keys, foreign keys, data types, and null/not ..
|
|
Calculate the own-wage elasticity of labor demand
: Calculate the own-wage elasticity of labor demand as the wage changes from $5 to $6. How would your answer be different if the wage rose from $20 to $21 - How does the slope change as one moves up this labor demand curve? How does the elasticity c..
|
|
Design model below to complete
: Use the KCT design model below to complete this case.CUSTOMER(CustomerID, FirstName, LastName, Street, City, State, Zip, Phone)RENTAL(RentalID, RentalDate, NumberOfDays,
|
|
Describe what is exchanged between the organisms
: Describe what is exchanged between the organisms
|
|
Customer service issues
: In terms of customer service issues, which of the following is the least likely reason for using a robust CRM?
|
|
What are the advantages and disadvantages of duel sourcing
: If you were tasked to prepare an audit protocol to ensure senior management about the integrity of the supply chain, who would you audit and what elements would you audit them for. What are the advantages and disadvantages of duel sourcing (two sup..
|
|
Compute the marginal rate of substitution
: Determine which of the labeled points are Pareto Efficient. Be sure to explain why you claim each point is or is not Pareto Efficient - Draw an indifference map representing
|