2. Use the following list of attributes and information from the UML Class Diagram to identify the number of the appropriate attribute for each blank in the table listing below. Attributes 1 Cash account # 2. Cash account balance 3. Cash receipt # 4. Cash receipt amount 5. Cash receipt date 6. Contract # 7. Contract date 8. Contract end date 9. Contract minimum dollar commitment 10. Contract standard premium 11, Customer # 12. Customer name 13. Customer type 14. Customer's credit card number for this rental reservation 15. Delivery truck # 16. Delivery truck acquired date 17. Delivery truck charge 18. Delivery truck description 19. Employee # 20. Employee name 21. Inventory category 22. Inventory category description 23. Number of customers in this customer type 24. Number of rental inventory items available in this category 25. Rental delivery Y/N? 26, Rental end time 27. Rental inventory # 28. Rental inventory acquired on date 29. Rental inventory description 30. Rental inventory hourly charge 31. Rental reservation # 32. Rental reservation date 33. Rental start time 34. Rental ticket # 35, Rental ticket date 36. YTD rentals by this customer Resources Rental Inventory , rental inventory description, rental inventory hourly charge, Rental inventory # ( PK ) , (FK) Delivery Trucks = Cash Delivery truck # (PK), delivery truck description, delivery truck charge, delivery truck acquired date (PK), cash account balance Events Contract# (PK), contract date, contract end date, contract minimum dollar amount, contract standard premium, Contracts= (FK), employee # (FK) Rental Reservations = Rental reservation # (PK) customer's credit card for this rental reservation, (FK) Contract # (FK), customer # (FK), Rental Tickets = (PK), rental ticket date, rental start time, rental end time, delivery Y/N, rental reservation # (FK ), Customer # (FK), employee # (FK) (FK), delivery truck # (FK) Cash Receipts = Cash receipt # (PK), cash receipt date, cash receipt amount (FK), customer # (FK), employee # (FK) Agents Customers Customer# (PK), customer name, (FK), YTD rentals this customer Employee # (PK), employee name, Employees Type Images Inventory Categories Customer Types = Inventory category # (PK), inventory category description, Customer type (PK), number of customers of this type Linking Tables Rental Reservation -I nventory Category inventory category # (PK) Rental Tickets-Cash Receipts = rental ticket # +cash receipt # (PK) 2. Use the following list of attributes and information from the UML Class Diagram to identify the number of the appropriate attribute for each blank in the table listing below. Attributes 1 Cash account # 2. Cash account balance 3. Cash receipt # 4. Cash receipt amount 5. Cash receipt date 6. Contract # 7. Contract date 8. Contract end date 9. Contract minimum dollar commitment 10. Contract standard premium 11, Customer # 12. Customer name 13. Customer type 14. Customer's credit card number for this rental reservation 15. Delivery truck # 16. Delivery truck acquired date 17. Delivery truck charge 18. Delivery truck description 19. Employee # 20. Employee name 21. Inventory category 22. Inventory category description 23. Number of customers in this customer type 24. Number of rental inventory items available in this category 25. Rental delivery Y/N? 26, Rental end time 27. Rental inventory # 28. Rental inventory acquired on date 29. Rental inventory description 30. Rental inventory hourly charge 31. Rental reservation # 32. Rental reservation date 33. Rental start time 34. Rental ticket # 35, Rental ticket date 36. YTD rentals by this customer Resources Rental Inventory , rental inventory description, rental inventory hourly charge, Rental inventory # ( PK ) , (FK) Delivery Trucks = Cash Delivery truck # (PK), delivery truck description, delivery truck charge, delivery truck acquired date (PK), cash account balance Events Contract# (PK), contract date, contract end date, contract minimum dollar amount, contract standard premium, Contracts= (FK), employee # (FK) Rental Reservations = Rental reservation # (PK) customer's credit card for this rental reservation, (FK) Contract # (FK), customer # (FK), Rental Tickets = (PK), rental ticket date, rental start time, rental end time, delivery Y/N, rental reservation # (FK ), Customer # (FK), employee # (FK) (FK), delivery truck # (FK) Cash Receipts = Cash receipt # (PK), cash receipt date, cash receipt amount (FK), customer # (FK), employee # (FK) Agents Customers Customer# (PK), customer name, (FK), YTD rentals this customer Employee # (PK), employee name, Employees Type Images Inventory Categories Customer Types = Inventory category # (PK), inventory category description, Customer type (PK), number of customers of this type Linking Tables Rental Reservation -I nventory Category inventory category # (PK) Rental Tickets-Cash Receipts = rental ticket # +cash receipt # (PK)
