(Solved): Requlred Informatlon Beach Cities Rentals rents almost anything. They rent tools, equipment, trucks ...

Requlred Informatlon Beach Cities Rentals rents almost anything. They rent tools, equipment, trucks for everything from home remodeling projects to major construction projects. They also rent office equipment, such as desks, file cablnets, chairs, tables, and office décor ltems. Finally, they rent furniture for short term home staging or long-term use. They have become well known in the area for having what thelr customers want. Construction companies, contractors, real estate agents, office managers, and Individual homeowners and renters all rely on Beach Cities to have what they need In stock. The following case describes Beach Cities processes for purchasing new Inventory from its suppliers Rental Inventory and Inventory categorles Beach Cities keeps all Items avallable for rent In one Inventory class, although It categorizes Its Inventory by the type of Inventory. Each inventory item s identified internally by the inventory number (Inventory #). The inventory category # serves as Beach Cities catalog number for its catalog and website. For example, Beach Cities catalog could list executive desk chalrs (category number 420). but Internally It tracks each desk chalr In Inventory. Since its Inventory is so extenslve. t stores much of the inventory in its various storage lots. Beach Cities tracks lts various storage lots by storage lot # Replacing rental Inventory Beach Citles replaces its Inventory Items as soon as they show signs of wear and tear. The Beach City buyer Issues purchase orders to its suppliers and then a Beach City recelving employee records the date that Item was receved Into Inventory. It pays suppliers In full by check within 30 days after recelpt of the Items. Since each purchase order results In one recelpt of Items, Beach Cities keeps the purchase order and purchases Information In one class. Each purchase can Involve many Inventory Items, but each Item Is only purchased once. Beach Clties tracks the buylng employee as well as the recelving employee for each purchase order/purchase Other Informetlon Beach Cities records Information about all agents, resources, and type Images before they are linked to other entities. It tracks all employee Information In one employee class. Required: Use the Information above and a list of attributes to develop UML class models and a corresponding table listing for Beach Cities sales process. Then, fill In the missing Information on the model and tables provided. UML Class Diagranm Cash 2 5 6 4 3 7 Purchase Orders/Purchases Rental Category 10 Suppliers 8 Receiving Buying Inventory Category 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 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 I. 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 avallable In this category 11. Purchase order # 12 Purchase order date 13. Purchase recelved date 14. Quantity of Inventory items at this storage lot 15. Rental Inventory # 16. Rental Inventory acqulred 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. Suppler name 24. Year-to-date (YTD) rentals by this customer Put the number of the attribute In the approprlate blank In the table list below. Resources Rental Inventory- Rental inventory # (PK), rental inventory acquired on date, rental inventory description. rental inventory category # (FK) (FK), storage lot # (FK) Cash (PK), cash account balance Storage Lot- Storage lot# (PK), storage lot address, storage lot size 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 Suppliers Type Images Inventory Categories Employee # (PK), employee name Supplier # (PK). Inventory category # (PK), inventory category description Show transcribed image text Requlred Informatlon Beach Cities Rentals rents almost anything. They rent tools, equipment, trucks for everything from home remodeling projects to major construction projects. They also rent office equipment, such as desks, file cablnets, chairs, tables, and office décor ltems. Finally, they rent furniture for short term home staging or long-term use. They have become well known in the area for having what thelr customers want. Construction companies, contractors, real estate agents, office managers, and Individual homeowners and renters all rely on Beach Cities to have what they need In stock. The following case describes Beach Cities processes for purchasing new Inventory from its suppliers Rental Inventory and Inventory categorles Beach Cities keeps all Items avallable for rent In one Inventory class, although It categorizes Its Inventory by the type of Inventory. Each inventory item s identified internally by the inventory number (Inventory #). The inventory category # serves as Beach Cities catalog number for its catalog and website. For example, Beach Cities catalog could list executive desk chalrs (category number 420). but Internally It tracks each desk chalr In Inventory. Since its Inventory is so extenslve. t stores much of the inventory in its various storage lots. Beach Cities tracks lts various storage lots by storage lot # Replacing rental Inventory Beach Citles replaces its Inventory Items as soon as they show signs of wear and tear. The Beach City buyer Issues purchase orders to its suppliers and then a Beach City recelving employee records the date that Item was receved Into Inventory. It pays suppliers In full by check within 30 days after recelpt of the Items. Since each purchase order results In one recelpt of Items, Beach Cities keeps the purchase order and purchases Information In one class. Each purchase can Involve many Inventory Items, but each Item Is only purchased once. Beach Clties tracks the buylng employee as well as the recelving employee for each purchase order/purchase Other Informetlon Beach Cities records Information about all agents, resources, and type Images before they are linked to other entities. It tracks all employee Information In one employee class. Required: Use the Information above and a list of attributes to develop UML class models and a corresponding table listing for Beach Cities sales process. Then, fill In the missing Information on the model and tables provided. UML Class Diagranm Cash 2 5 6 4 3 7 Purchase Orders/Purchases Rental Category 10 Suppliers 8 Receiving Buying Inventory Category 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
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 I. 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 avallable In this category 11. Purchase order # 12 Purchase order date 13. Purchase recelved date 14. Quantity of Inventory items at this storage lot 15. Rental Inventory # 16. Rental Inventory acqulred 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. Suppler name 24. Year-to-date (YTD) rentals by this customer Put the number of the attribute In the approprlate blank In the table list below. Resources Rental Inventory- Rental inventory # (PK), rental inventory acquired on date, rental inventory description. rental inventory category # (FK) (FK), storage lot # (FK) Cash (PK), cash account balance Storage Lot- Storage lot# (PK), storage lot address, storage lot size 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 Suppliers Type Images Inventory Categories Employee # (PK), employee name Supplier # (PK). Inventory category # (PK), inventory category description