PR $7-4($LO $7-5,7-6)$ Beach Cities Rentals rents almost anything. $[$Connect Only$]$

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

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.

PR $7-4$ Part $2$: Identify the appropriate attribute for each blank in the table listing below. $[$Connect Only$]$

Required:

Use the following information from the UML class diagram to identify the appropriate attribute for each bank in the table listing

below.