op a centralised database for its operations. Currently each regional office is free to manage its own affairs, often done using spreadsheets. This has resulted in a multitude of contradictory systems, some manual, some comput
Computer Science
Produce an Extended Entity Relationship Model (EERM) for the selected part of the Case Study requirements.
A Cars4U vehicle hire company wishes to develop a centralised
Cars4U wishes that the new system holds standard profiles of customers details, vehicles held, all hire arrangements and details of hire, to streamline the processes of drawing up a hire contract at the outset and settling it at the conclusion of hire.
In the case of a Corporate Customer (hereafter called the Company) there may be several regional offices associated with the Company in different locations (for example BT Leeds, BT Newcastle ...) The account that the Company holds with CARS4U may be held at the Company headquarters even though the hire arrangements may be conducted with regional offices. Alternatively, each Company regional office may act independently of the Company headquarters in handling both financial and hire arrangements with CARS4U. Some individual customers require insurance, which may be of different classifications depending on coverage of 3rd part claims, damage to the vehicle, injury to the passenger etc. In the case of company hire CARS4U takes no responsibility for the insurance of the company’s employees. This is the responsibility of the company. Some customers have requirements regarding car accessories, for example: a bike or roof rack, or a baby seat, etc. from CARS4U.
Additional charges (per day) are made for these and checks are made on their condition on return.
Loyalty Discounts are available to customers (whether individual or corporate) hiring single vehicles and are based on the total number of vehicle-days for the customer in the previous year. In the case of a company this is aggregated over all regional offices.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 2 images
