Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

image text in transcribed

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)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions