Problem 5-4 Part 2

Required:

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

Put the number of the attribute in the appropriate blank in the table list below.

ResourcesRental Inventory =Rental inventory # (PK),, rental inventory description, rental inventory hourly charge,(FK)Delivery Trucks =Delivery truck # (PK), delivery truck description, delivery truck charge, delivery truck acquired dateCash =(PK), cash account balanceEventsContracts =Contract# (PK), contract date, contract end date, contract minimum dollar amount, contract standard premium,(FK), employee # (FK)Rental Reservations =Rental reservation # (PK),, customers credit card for this rental reservation,Contract # (FK), customer # (FK),(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)AgentsCustomers =Customer # (PK), customer name,(FK), YTD rentals by this customerEmployees =Employee # (PK), employee name,Type ImagesInventory Categories =Inventory category # (PK), inventory category description,Customer Types =Customer type (PK), number of customers of this typeLinking TablesRental Reservation-Inventory Category =+ inventory category # (PK)Rental Tickets-Cash Receipts = rental ticket # + cash receipt # (PK)