Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Problem 6-4 Part 2 2. Use the following list of attributes and information from the UML Class Diagram to identify the number of the appropriate
Problem 6-4 Part 2 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. Check# 4. Check amount 5, Check date 6. Employee# 7. Employee name 8. Inventory category# 9. Inventory category description 10. Number of rental inventory items available in this category 11. Purchase order # 12. Purchase order date 13. Purchase received date 14. Quantity 15. Rental inventory # 16. Rental inventory acquired on date 17. Rental inventory description 18. Rental inventory hourly charge 19. Storage lot 20. Storage lot address 21. Storage lot size 22. Supplier 23. Supplier name 24. Year-to-date (YTD) rentals by this customer inventory items at this storage lot Put the number of the attribute in the appropriate blank in the table list below. Resources Rental Inventory Rental inventory # (PK), rental inventory acquired on date, rental inventory description (FK), storage lot # (FK) rental inventory category # ( FK) Cash (PK), cash account balance Storage lot# (PK), storage lot address, storage lot size Storage Lot Events Cash Disbursements (PK), check date, check amount, cash account # (FK ), employee (FK) (FK) (PK), purchase order date, purchase received date, buying employee# (FK) Purchase Orders/Purchases = Receiving employee # (FK), supplier # (FK) (FK) Agents Employees Employee # (PK), employee name, Supplier #(PK) Suppliers Type Images Inventory Categories Inventory category # (PK), inventory category description Problem 6-4 Part 2 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. Check# 4. Check amount 5, Check date 6. Employee# 7. Employee name 8. Inventory category# 9. Inventory category description 10. Number of rental inventory items available in this category 11. Purchase order # 12. Purchase order date 13. Purchase received date 14. Quantity 15. Rental inventory # 16. Rental inventory acquired on date 17. Rental inventory description 18. Rental inventory hourly charge 19. Storage lot 20. Storage lot address 21. Storage lot size 22. Supplier 23. Supplier name 24. Year-to-date (YTD) rentals by this customer inventory items at this storage lot Put the number of the attribute in the appropriate blank in the table list below. Resources Rental Inventory Rental inventory # (PK), rental inventory acquired on date, rental inventory description (FK), storage lot # (FK) rental inventory category # ( FK) Cash (PK), cash account balance Storage lot# (PK), storage lot address, storage lot size Storage Lot Events Cash Disbursements (PK), check date, check amount, cash account # (FK ), employee (FK) (FK) (PK), purchase order date, purchase received date, buying employee# (FK) Purchase Orders/Purchases = Receiving employee # (FK), supplier # (FK) (FK) Agents Employees Employee # (PK), employee name, Supplier #(PK) Suppliers Type Images Inventory Categories Inventory category # (PK), inventory category description
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started