Required information Problem 6-4 [LO 6-5) Beach Cities Rentalsrents 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 decor 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 chies 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 Isting for Beach Cities sales process. Then, fill in the missing information on the model and tables provided. UML Class Diagram C 2 6 Check my work mode : This shows what is correct or incorrect for the work you have comple 2 Beach Cities sales process. Then, fill in the missing information on the model and tables provided UML Class Diagram 2012 C 5 1 10 Super Problem 6-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. Check 4. Check amount 5. Check date 6. Employee 2 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 of inventory items at this storage lot 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 (YT) rentals by this customer Put the number of the attribute in the appropriate blank in the table ist below Put the number of the attribute in the appropriate blank in the table ist below Answer is complete but not entirely correct. Resources Rental Inventory Storage lot size FK) storage lot (FK) Rental inventory #P), rental inventory coured on date rental inventory description rental inventory category Number of rental inventory toms valable in this EK) category Cash account PK). cash account balance Storage (PK), storage lot address, storage lot size Storage for Cash Storage Lot Events Cash Disbursements Check date Employee Purchase order date receiving employee IFK) supplier (FX). (PK), check date, check amount, cash account (FK), employee (FK) FX) PK).purchase orderdale, purchase received dute, buying employee # (FK). Suppler name UK) Purchase Orders/Purchases Agents Employees Suppliers Employee (PK), employee me Supplere () Supplier name Type Images Inventory Categories Inventory Category: (P Inventory legory description Number of rental inventory Homs available in this category