? Beach Cities Rentals rents almost anything. They rent tools, equipment, trucks for everything from home remodeling

?

Transcribed Image Text:

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 cabinets, chairs, tables, and office décor items. Finally, they rent furniture for short term home staging or long-term use. They have become well known in the area for having what their 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 categories Beach Cities keeps all items available for rent in one inventory class, although it categorizes its inventory by the type of inventory. Each inventory item is 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 chairs (category number 420), but internally it tracks each desk chair in inventory. Since its inventory is so extensive, it stores much of the inventory in its various storage lots. Beach Cities tracks its various storage lots by storage lot #. Replacing rental inventory Beach Cities 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 receiving employee records the date that item was received into inventory. It pays suppliers in full by check within 30 days after receipt of the items. Since each purchase order results in one receipt 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 Cities tracks the buying employee as well as the receiving employee for each purchase order/purchase. Other information 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 Diagram 1 4 0..* Rental Category 8 1..1 Inventory Category 1..* Cash 5 O..* 0..1 1.. 7 Purchase Orders/Purchases O..* 0..* 6 O..* O.." 1..1 10 Receiving Buying 2 1..1 Suppliers 1..1 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 # inventory items at this storage lot 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 Put the number of the attribute in the appropriate blank in the table list below. Resources Rental Inventory = Cash= Storage Lot = Events Cash Disbursements = Purchase Orders/Purchases = Agents Employees = Suppliers = Type Images Inventory Categories= Rental inventory # (PK), rental inventory acquired on date, rental inventory description, , rental inventory category # (FK), Storage lot# (PK), storage lot address, storage lot size, Receiving employee # (FK), supplier # (FK), (PK), cash account balance Employee # (PK), employee name, Supplier # (PK), (FK), storage lot # (FK) (PK), check date, check amount, cash account # (FK), employee (FK), (FK) (PK), purchase order date, purchase received date, buying employee # (FK), (FK) Inventory category # (PK), inventory category description, 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 cabinets, chairs, tables, and office décor items. Finally, they rent furniture for short term home staging or long-term use. They have become well known in the area for having what their 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 categories Beach Cities keeps all items available for rent in one inventory class, although it categorizes its inventory by the type of inventory. Each inventory item is 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 chairs (category number 420), but internally it tracks each desk chair in inventory. Since its inventory is so extensive, it stores much of the inventory in its various storage lots. Beach Cities tracks its various storage lots by storage lot #. Replacing rental inventory Beach Cities 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 receiving employee records the date that item was received into inventory. It pays suppliers in full by check within 30 days after receipt of the items. Since each purchase order results in one receipt 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 Cities tracks the buying employee as well as the receiving employee for each purchase order/purchase. Other information 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 Diagram 1 4 0..* Rental Category 8 1..1 Inventory Category 1..* Cash 5 O..* 0..1 1.. 7 Purchase Orders/Purchases O..* 0..* 6 O..* O.." 1..1 10 Receiving Buying 2 1..1 Suppliers 1..1 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 # inventory items at this storage lot 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 Put the number of the attribute in the appropriate blank in the table list below. Resources Rental Inventory = Cash= Storage Lot = Events Cash Disbursements = Purchase Orders/Purchases = Agents Employees = Suppliers = Type Images Inventory Categories= Rental inventory # (PK), rental inventory acquired on date, rental inventory description, , rental inventory category # (FK), Storage lot# (PK), storage lot address, storage lot size, Receiving employee # (FK), supplier # (FK), (PK), cash account balance Employee # (PK), employee name, Supplier # (PK), (FK), storage lot # (FK) (PK), check date, check amount, cash account # (FK), employee (FK), (FK) (PK), purchase order date, purchase received date, buying employee # (FK), (FK) Inventory category # (PK), inventory category description,