Bicycle Rental Facility (BRF) in Hampshire's Social Welfare Service (HSWS) Section

Membership and Payment Details

Hampshire’s Social Welfare Service (HSWS) section has planned to introduce Bicycle Rental Facility (BRF) to its citizens. BRF not
only provides citizens with a safe, convenient and environmentally friendly transportation service, but also helps in improving their health as it is physical exercise.

Bicycles are housed in service terminals placed at a number of locations across some of the main cities in Hampshire, UK.

Each service terminal is given a unique identification number, terminal name, street address, telephone number and maximum storage capacity. HSWS keeps track of the bicycles currently available at each service terminal.

Bicycles are identified by the unique ID of each bicycle, along with its make, model, color, and type (kid, adult and senior citizen) of bicycle. Each bicycle is also equipped with a sensor to allow GPS tracking of the bicycle.

While HSWS provides the bicycles and maintains the terminals, private-sector companies are also invited to sponsor individual bicycles and terminals and, in return for a fee, their logo will be displayed prominently on the sponsored asset. It is important for HSWS to keep updated information on these sponsors to record sponsor name, company, contact person, telephone number, address, sponsorship period and fees.

A sponsor will commit to a certain period, after which they can renew or cancel sponsorship. The sponsors have an agreement, as part of a contract, with HSWS for maintaining and/or removing sponsorship logos at terminals or on bicycles.

Anyone interested in using the bicycle facilities must register as a member. Information stored about each member includes full name, email, contact phone numbers, residential address, membership status and member payment details. Members may be children of age between 14 and 17, adults (18+) and senior citizens (65-70).

Membership status and member fee are fixed accordingly. An adult can register their children as the adult will be responsible for the payment. HSWS is not permitted, under health and safety regulation, to rent out bicycles to members over the age of 70. 
In addition to memberships, visitors or casual users can use BRF by purchasing a £5 one-day pass (valid for 24 hrs) online or via the BRF app, using a debit/credit card. The visitors' detail, full name, email, contact phone numbers, residential address and card details are recorded while collecting a bicycle. The day pass has a number, date and time of purchase.

Each rental transaction is fully automated and records details of the type of user, user detail, bicycle, terminal, pick-up time, duration of rental use and total rent paid. The total rental cost is done based on the total rental period. The rental rate depends upon the type of bicycle. All registered members will receive a monthly bill, while visitors and casual users are on pay-as-you-go system. Each bill has a bill number, date and total amount to be paid. Each bill needs a payment. Payment detail includes the payment number, payment date and mode of payment (direct debit or debit/credit card).

Once checked back in, a bicycle is immediately available to another user for rental.

HSWS has contracts with a variety of external service companies to maintain, replace and service the bicycles. They make use of companies located in the cities hosting the bicycle terminals. They need to keep record of the detail on these service companies: address, contact person, contact numbers, contract number, contract fees...

The ideal is to expand the sensor capability to track the position of bicycles in order to retain any lost or abandoned bicycles as well as to track whether users returned the bicycles within the agreed rental period.

• Basic stats on users per city for a specific time period

• Comparison of usage by registered users vs visitors/casual users

• Service company contracts

• Bicycle records

• Sponsorship details

• List of terminals

• Monthly income generated per city

Using the information given in the case study, draw an Enhanced Entity-Relationship Diagram for the database system. Do Not include any attributes. The EERD should fit on One page and Must be produced electronically. Hand-drawn diagrams will receive no marks. There are a number of free or trial-period EERD drawing software packages that you can use.

Clearly state any assumptions you have made about the system. Assumptions are made when the case study text does not give you enough information. These assumptions should only relate to the design of the system. For example you may have decided to include or omit certain entities, or you may have decided to generalise rather than specialize some entities – tell us why you did this.