Required intormation 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 renting its inventory to customers. Rental inventory and inventory categories Beach Cities categorizes its inventory by the type of inventory. Each inventory item is identified internally by the inventory number (retail inventory #) and categories are tracked by inventory category number (inventory category #). 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 individual desk chair in inventory. Contracts Because Beach Cities is so popular with a variety of organizations, such as construction companies, major contractors, real estate agents, office managers, and others in the area, it regularly negotiates contracts for equipment rental. The contracts give customers special considerations, such as delivery of equipment to the customer's location, waiver of the requirement for advance deposit, and priority reservations. Contracts can specify that the customer will pay a premium over the regular rental prices to receive special services or they can specify whether the customer will receive volume discounts over the regular rental prices. Contracts don't apply to specific inventory items or categories of inventory items. Instead, they obligate the customer to a minimum dollar commitment for rentals over the period of the contract as well as the percentage premium or discount on the standard rental costs. Some customers negotiate multiple contracts depending on their needs, but each contract is established separately. Reservations, rental tickets, and delivery Beach Cities' customers must make rental reservations in advance. Each reservation applies to one or more categories of items to be rented on some future date or dates. Customers under contract must specify which contract number applies when they make the reservation. At the time of each specific rental, a Beach Cities employee prepares one rental ticket for each item that the customer rents. The rental ticket notes the time that the rental started and the amount of deposit on the item (if the rental is not under contract). Generally, Beach Cities requires a 25% deposit at the time of the rental, but that amount is negotiable and is usually waived for customers with contracts (depending on the specific terms of the contract). For an extra charge, Beach Cities delivers the items to the customer's location, using its own delivery trucks. It tracks which truck is used for each rental ticket. It tracks its inventory of delivery trucks separately from its rental inventory. When the customer returns the rental items (or Beach Cities picks them up), a Beach Cities employee updates the rental ..tickets.with.the.rental.end.time.and calculates the charges.applicable.to.each rental ticket. The customer.must pay for the.. that amount is negotiable and is usually waived for customers with contracts (depending on the specific terms of the contract). For an extra charge, Beach Cities delivers the items to the customer's location, using its own delivery trucks. It tracks which truck is used for each rental ticket. It tracks its inventory of delivery trucks separately from its rental inventory. When the customer returns the rental items (or Beach Cities picks them up), a Beach Cities employee updates the rental tickets with the rental end time and calculates the charges applicable to each rental ticket. The customer must pay for the remainder of the charges at that time, including delivery charges and contract premium charges. If the customer rented multiple items, the customer can pay for all rental tickets with one check. Other information Beach Cities classifies its customers by customer type for planning purposes. 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 below 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. Contracts 0..* Rental Reservation Customers Rental Inventory 0. Cash Receipts 10 Employees Cash 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. Cash receipt # 4. Cash receipt amount 5. Cash receipt date 6. Contract # 7. Contract date 8. Contract end date 9. Contract minimum dollar commitment 10. Contract standard premium 11. Customer # 12. Customer name 13. Customer type 14. Customer's credit card number for this rental reservation 15. Delivery truck # 16. Delivery truck acquired date 17. Delivery truck charge 18. Delivery truck description 19. Employee # 20. Employee name 21. Inventory category # 22. Inventory category description 23. Number of customers in this customer type 224. Number of rental inventory items available in this category 24. Number of rental inventory items available in this category 25. Rental delivery Y/N? 26. Rental end time 27. Rental inventory # 28. Rental inventory acquired on date 29. Rental inventory description 30. Rental inventory hourly charge 31. Rental reservation # 32. Rental reservation date 33. Rental start time 34. Rental ticket # 35. Rental ticket date 36. YTD rentals by this customer Rental Inventory = Rental inventory # (PK), , rental inventory description, rental inventory hourly charge, (FK) Delivery Trucks = Cash = Delivery truck # (PK), delivery truck description, delivery truck charge, delivery truck acquired date (PK), cash account balance Events Contracts = Contract# (PK), contract date, contract end date, contract minimum dollar amount, contract standard premium, (FK), employee # (FK) Rental reservation # (PK), , customer's credit card for this rental reservation, Contract # (FK), customer # (FK), (FK) Rental Reservations = Rental Tickets = (PK), rental ticket date, rental start time, rental end time, delivery Y/N, rental reservation # (FK), (FK), delivery truck # (EK) Cash Receipts = Customer # (FK), employee # (FK), Cash receipt # (PK), cash receipt date, cash receipt amount, (FK), customer # (FK), employee # (FK) Agents Customers = Employees = (FK), YTD rentals by this customer Customer # (PK), customer name, Employee # (PK), employee name, Type Images Inventory Categories = Customer Types = Inventory category # (PK), inventory category description, Customer type (PK), number of customers of this type Linking Tables Rental Reservation-Inventory Category = + inventory category # (PK) Rental Tickets-Cash Receipts = rental ticket # + cash receipt # (PK) Required intormation 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 renting its inventory to customers. Rental inventory and inventory categories Beach Cities categorizes its inventory by the type of inventory. Each inventory item is identified internally by the inventory number (retail inventory #) and categories are tracked by inventory category number (inventory category #). 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 individual desk chair in inventory. Contracts Because Beach Cities is so popular with a variety of organizations, such as construction companies, major contractors, real estate agents, office managers, and others in the area, it regularly negotiates contracts for equipment rental. The contracts give customers special considerations, such as delivery of equipment to the customer's location, waiver of the requirement for advance deposit, and priority reservations. Contracts can specify that the customer will pay a premium over the regular rental prices to receive special services or they can specify whether the customer will receive volume discounts over the regular rental prices. Contracts don't apply to specific inventory items or categories of inventory items. Instead, they obligate the customer to a minimum dollar commitment for rentals over the period of the contract as well as the percentage premium or discount on the standard rental costs. Some customers negotiate multiple contracts depending on their needs, but each contract is established separately. Reservations, rental tickets, and delivery Beach Cities' customers must make rental reservations in advance. Each reservation applies to one or more categories of items to be rented on some future date or dates. Customers under contract must specify which contract number applies when they make the reservation. At the time of each specific rental, a Beach Cities employee prepares one rental ticket for each item that the customer rents. The rental ticket notes the time that the rental started and the amount of deposit on the item (if the rental is not under contract). Generally, Beach Cities requires a 25% deposit at the time of the rental, but that amount is negotiable and is usually waived for customers with contracts (depending on the specific terms of the contract). For an extra charge, Beach Cities delivers the items to the customer's location, using its own delivery trucks. It tracks which truck is used for each rental ticket. It tracks its inventory of delivery trucks separately from its rental inventory. When the customer returns the rental items (or Beach Cities picks them up), a Beach Cities employee updates the rental ..tickets.with.the.rental.end.time.and calculates the charges.applicable.to.each rental ticket. The customer.must pay for the.. that amount is negotiable and is usually waived for customers with contracts (depending on the specific terms of the contract). For an extra charge, Beach Cities delivers the items to the customer's location, using its own delivery trucks. It tracks which truck is used for each rental ticket. It tracks its inventory of delivery trucks separately from its rental inventory. When the customer returns the rental items (or Beach Cities picks them up), a Beach Cities employee updates the rental tickets with the rental end time and calculates the charges applicable to each rental ticket. The customer must pay for the remainder of the charges at that time, including delivery charges and contract premium charges. If the customer rented multiple items, the customer can pay for all rental tickets with one check. Other information Beach Cities classifies its customers by customer type for planning purposes. 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 below 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. Contracts 0..* Rental Reservation Customers Rental Inventory 0. Cash Receipts 10 Employees Cash 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. Cash receipt # 4. Cash receipt amount 5. Cash receipt date 6. Contract # 7. Contract date 8. Contract end date 9. Contract minimum dollar commitment 10. Contract standard premium 11. Customer # 12. Customer name 13. Customer type 14. Customer's credit card number for this rental reservation 15. Delivery truck # 16. Delivery truck acquired date 17. Delivery truck charge 18. Delivery truck description 19. Employee # 20. Employee name 21. Inventory category # 22. Inventory category description 23. Number of customers in this customer type 224. Number of rental inventory items available in this category 24. Number of rental inventory items available in this category 25. Rental delivery Y/N? 26. Rental end time 27. Rental inventory # 28. Rental inventory acquired on date 29. Rental inventory description 30. Rental inventory hourly charge 31. Rental reservation # 32. Rental reservation date 33. Rental start time 34. Rental ticket # 35. Rental ticket date 36. YTD rentals by this customer Rental Inventory = Rental inventory # (PK), , rental inventory description, rental inventory hourly charge, (FK) Delivery Trucks = Cash = Delivery truck # (PK), delivery truck description, delivery truck charge, delivery truck acquired date (PK), cash account balance Events Contracts = Contract# (PK), contract date, contract end date, contract minimum dollar amount, contract standard premium, (FK), employee # (FK) Rental reservation # (PK), , customer's credit card for this rental reservation, Contract # (FK), customer # (FK), (FK) Rental Reservations = Rental Tickets = (PK), rental ticket date, rental start time, rental end time, delivery Y/N, rental reservation # (FK), (FK), delivery truck # (EK) Cash Receipts = Customer # (FK), employee # (FK), Cash receipt # (PK), cash receipt date, cash receipt amount, (FK), customer # (FK), employee # (FK) Agents Customers = Employees = (FK), YTD rentals by this customer Customer # (PK), customer name, Employee # (PK), employee name, Type Images Inventory Categories = Customer Types = Inventory category # (PK), inventory category description, Customer type (PK), number of customers of this type Linking Tables Rental Reservation-Inventory Category = + inventory category # (PK) Rental Tickets-Cash Receipts = rental ticket # + cash receipt # (PK)