(a) Draw an Entity-Relationship (ER) diagram which models the scenario described below. Your diagram should include entity types, relationship types, attributes and constraints. The Red Car Company (RCC) is a car hire company, with the distinctive feature that all its cars are the same bright red colour. Your diagram should model the following: • Drivers, including their name, driving licence number, date of birth and address. • Cars, including their registration number, make and model. • Accidents, including the date and time, and the RCC car and driver involved. • Each occasion on which a driver hired a car, including the driver, the car, the start date and the length of the hire in days. • The RCC only permits people to hire cars as long as they have had fewer than four accidents. • Cars which have had ten accidents are always disposed of and are not used for hiring.
(a) Draw an Entity-Relationship (ER) diagram which models the scenario described below. Your diagram should include entity types, relationship types, attributes and constraints. The Red Car Company (RCC) is a car hire company, with the distinctive feature that all its cars are the same bright red colour. Your diagram should model the following:
• Drivers, including their name, driving licence number, date of birth and address.
• Cars, including their registration number, make and model.
• Accidents, including the date and time, and the RCC car and driver involved.
• Each occasion on which a driver hired a car, including the driver, the car, the start date and the length of the hire in days.
• The RCC only permits people to hire cars as long as they have had fewer than four accidents.
• Cars which have had ten accidents are always disposed of and are not used for hiring.
(b) It is proposed that when a new student who suffers from epilepsy starts a degree programme in the School of French at the University of Southern England, all the students and staff in the School are informed of that student and given advice on what they should do to help if they witness that student having an epileptic fit. (Epilepsy is a health issue characterised by fits or seizures, such as vigorous shaking.) Comment on this proposal within the considerations of the Data Protection Act. How would you change the proposal in the light of the Act?
Step by step
Solved in 2 steps with 1 images
