Computer Science Produce an Extended Entity Relationship Model (EERM) with cardinality and attributes for the selected part of the Case Study requirements. A Cars4U vehicle hire company wishes to develop 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 computerised, with consequent data duplication and delays in terms of drawing up hire agreements, redistributing vehicles to customers after inspection etc.. 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

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Computer Science Produce an Extended Entity Relationship Model (EERM) with cardinality and attributes for the selected part of the Case Study requirements. A Cars4U vehicle hire company wishes to develop 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 computerised, with consequent data duplication and delays in terms of drawing up hire agreements, redistributing vehicles to customers after inspection etc.. 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.

Expert Solution

Step by step

Solved in 2 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions