masjones 0 Newbie Poster

Assignment
Read the following case study that describes the data requirements for the EasyDrive School of Motoring.
The EasyDrive School of Motoring was established in Glasgow in 1992. Since then, the School has grown steadily and now has several offices in most of the main cities of Scotland. Each office has a Manager (who tends to also be a Senior Instructor), several Senior Instructors, Instructors and administrative staff. The Manager is responsible for the day-to-day running of the office. Clients must first register at an office and this requires that they complete an application form, which records their personal details. A client may request individual lessons or book a block of lessons. An individual lesson is for one hour, which begins and ends at the office. A lesson is with a particular Instructor in a particular car at a given time. Lessons can start as early as 8am and as late as 8pm. After each lesson, the Instructor records the progress made by the client and notes the mileage used during the lesson. The School has a pool of cars, which are adapted for the purposes of teaching. Each Instructor is allocated to a particular car. Once ready, a client applies for a driving test date. To obtain a full driving license the client must pass both the practical and theoretical parts of the test. If a client fails to pass, the Instructor must record the reasons for the failure.
(a) Identify the main entities of the EasyDrive School of Motoring.
(b) Identify the main relationships between the entities describe in (a) and represent each relationship as an ER diagram.
(c) Determine the multiplicity constraints for each relationship described in (b). Represent the multiplicity for each relationship in the ER diagrams created in (b).
(d) Identify attributes and associate them with an entity or relationship. Represent each attribute in the ER diagrams created in (c).
(e) Determine candidate and primary key attributes for each (Strong) entity.
(f) Using your answers (a) to (e) attempt to represent the data requirements of the EasyDrive School of Motoring as a single ER diagram. State any assumption necessary to support your design. send the reply to [removed]