Required information

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 dcor 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

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 #
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 (YTD) rentals by this customer

Put the number of the attribute in the appropriate blank in the table list below.