REQUIRED: Using the narrative and the attributes below, prepare:

1. a UML class diagram (with classes, associations, and multiplicities), and
2. a list of corresponding relational tables - (list the tables with all their attributes, identify the primary keys [with PK or underline], indicate the foreign keys [with an asterisk or FK]), and add appropriate attributes.

The table definitions should only use the attributes listed at the end of this case (remember that there should be no entities without attributes). You may abbreviate attribute names if the abbreviation is clear. List the tables in the following order: Resources, Events, Agents, Types, and Linking tables. Apply the standard REA patterns wherever the narrative does not clearly specify otherwise but avoid adding extra relationships that are not discussed. If the narrative is not clear, write down any assumptions that you make on your diagram/tables.

Background

TERN AWAY was recently formed to take advantage of the burgeoning interest in electric bikes, scooters, skateboards, and similar electrically-powered vehicles. TERN AWAY provides short term rentals at pop-up locations of electrically-powered vehicles. The pop-up stores are located primarily in downtown areas of major cities around the country. This exercise describes TERN AWAYs rental and maintenance processes.

Vehicle and Accessory Rental

TERN AWAY implements a pop-up concept for its rentals. It uses parking lots or similar areas near downtown areas as its pop-up rental locations. Customers pay by credit card. The initial charge covers two hours of vehicle(s) and accessory rental as well as the vehicle orientation and safety training. A customer may also rent vehicles for his/her guests. TERN AWAY records information on the responsible customer as well as all guests for liability purposes. Rentals are tracked by rental ticket number, and credit card transactions are tracked by receipt number.

Each customer must receive safety training before they can leave TERN AWAY rental locations with a vehicle. Several employees help each customer or group of customers select the appropriate vehicles and safety accessories. Then, the employees conduct the training to ensure all customers are prepared to enjoy their rides and operate the vehicles safely. TERN AWAY records which employees worked with each customer for the specific rental. Customers must register with TERN AWAY before they rent vehicles.

When customers return, TERN AWAY employees check the vehicles and accessories back in, recording the amount of time used. If the customers used more time than the initial two hours, an employee charges the responsible customers credit card again for the additional amount and any damage to the equipment, so each rental can result in multiple cash receipts (credit card charges). TERN AWAY does not accept cash or check payment. Credit card charges are automatically deposited into a TERN AWAY bank account.

Vehicles and Accessories Inventory

TERN AWAY offers a variety of electrically-powered vehicles for short term rental. They offer electric bikes, scooters, skateboards, hover boards, etc. They recognize the safety issues involved with use of these vehicles in metropolitan areas, so they furnish safety equipment, such as helmets, elbow pads, wrist braces, etc., to each customer. Additionally, TERN AWAY vehicles are equipped with the latest smart devices to ensure safe operation and customer satisfaction. They have advanced self-stopping features, GPS tracking capability, as well as the ability to synch the vehicle with the customers smart phones. Thus, TERN AWAY can charge a premium for their vehicles. TERN AWAY tracks vehicles and accessories by item number. Each vehicle and accessory is assigned a unique item number. They also track their vehicle and accessory inventory by vehicle type (bike, scooter, skateboard, helmet, etc.) as well as the rental location. Each vehicle or accessory is one type and at one location. The vehicle and accessory acquisition process is outside the scope of this exercise.

Vehicle and Accessory Maintenance

TERN AWAY does routine maintenance on its vehicles and accessories before any location opens for rentals. First, an employee issues a maintenance ticket to an approved vendor with an acceptable safety score. TERN AWAY classifies its vendors by safety score category (low, medium, and high) based on prior safety problems with maintained vehicles. Then, the vendor makes any necessary repairs to vehicles at the location. The employee confirms the repairs to ensure that all vehicles are safe and ready for rental. TERN AWAY pays each maintenance vendor in full within 30 days. Often, one check will pay for several maintenance tickets performed by that vendor.

General

TERN AWAY assigns each employee an employee number and tracks them by rental location. TERN AWAY records information about all agents, resources, and type images before those classes are linked to other entities or engage in processes.

Attributes

• account balance
• account#
• check amount
• check date
• check#
• customer drivers license number
• customer name
• customer#
• customers credit card#
• date this rental location opened
• employee date hired
• employee name
• employee#
• item cost
• item description
• item rental price
• item quantity on hand
• item#
• maintenance ticket#
• maintenance ticket date
• maintenance ticket total $ amount
• maximum number of safety problems for this safety score category
• number of hours this vehicle/accessory used on this rental
• number (count) of employees at this rental location
• number (count) of vehicles available at this rental location
• number (count) of vehicles/accessories repaired on this maintenance ticket
• receipt amount
• receipt date
• receipt#
• rental date
• rental location
• rental location address
• rental location phone number
• rental ticket#
• rental total $ amount
• safety equipment training delivered for this rental ticket and customer (Y/N)
• safety score category
• special safety precautions for this vehicle type
• time spent by this employee for this rental ticket
• total number of vehicles rented on this ticket
• vehicle type
• vehicle type description
• vendor accounts payable amount
• vendor name
• vendor#