Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Beyond Big Data Using Social MDM To Drive Deep Customer Insight

Authors: Martin Oberhofer, Eberhard Hechler

1st Edition

0133509796, 9780133509793

More Books

Students also viewed these Databases questions

Question

Explain the concept of product life cycles? LO.1

Answered: 1 week ago

Question

How would you rate Hsiehs leadership using the Leadership Grid?

Answered: 1 week ago