Question 3: EER Diagrams

You accepted a position as a database application programmer at the DriveAway electric scooter rental company in Bora Bora island. As a first step, you are asked to create an EER diagram that captures the following business rules:

Typically, DriveAways customers are tourists that visit the island for periods ranging from one week to 6 months. Customers are identified by their client number, and we also record their addresses while on Bora Bora. In addition, the passport information and home addresses of all customers are stored.

a) A customer rents one or more scooters from the company and a scooter may be rented by many customers, obviously for rental periods which do not overlap.

b) The shortest period that a scooter may be rented is for 8 hours, and the longest contract is for 1 month.

c) There are three locations (shops) on the island where a customer may rent a scooter from. The customer is always required to return a scooter to the location where he rented it from.

d) DriveAway has a fleet of 50 electric scooters. For each scooter, we keep information about the color, the year purchased, the current kilometer reading, the brand name, the model, the power, the voltage, the charging time and the range per charge.

e) Each scooter needs to be registered and the registration has to be renewed every year, at the traffic department of French Polynesia, which is located in Papeete (the capital of French Polynesia).

f) A scooter is serviced at a regular interval, usually after every 800 kilometers of travel. Sometimes a scooter may break down and then it needs to be repaired. There is one mechanic on the island who services and repairs all the scooters. Note that she is not employed by DriveAway.

g) DriveAway also maintains 50 charging stations, throughout the island. The customers may use these stations to recharge their scooters. This service is free of charge and available 24/7.

h) An employee is responsible for completing all the necessary forms when a customer rents a scooter.

i) There are 15 employees that work for DriveAway, including two (fulltime) supervisors and two (parttime) charging station repairmen. The company further employs one (parttime) accountant who works from home. The other employees are fulltime customer consultants that also act as receptionists. These employees are deployed at any one the three shops, as need be. Fulltime employees receive a salary and benefits such as health care, while parttime employees are paid by the hour and do not receive any benefits. All employees are required to pay income tax.

Your Task:

Create an EER diagram that models the DriveAway database. Your model should include entities, relationships as well as all attributes. Remember to state all your assumptions.

I do not know how to represent b), c), e), f), could you explain those in detail?