Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please I need this urgently right now please It's only one question under it The Global Motoring and Driving School was established in a makeshift

Please I need this urgently right now please 

It's only one question under it 

The Global Motoring and Driving School was established in a makeshift kiosk at Lapaz in 2007. The School has since then grown steadily and now has several plush offices in most of the major towns in Accra. The School is now so large that the communication and sharing of information between offices is poor, hence more administrative staff are being employed to cope with the ever- increasing amount of paperwork. The Director of the School, Dr. Kofi Nkansah, feels that too many mistakes are being made and that the success of the School will be short-lived if nothing is done to remedy the situation. Understanding that a database could help in part solve the problem of increased paperwork; he has approached you to draw up the logical design of his intended database to support the running of the Global Motoring and Driving School.
To help understand the workings of the school, Dr. Kofi Nkansah has provided you with the following brief description of how the Global Motoring and Driving School operates.
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. Before the first lesson, a client is requested to attend an interview with an Instructor to assess the needs of the client and to ensure that the client holds a valid provisional driving license. A client is free to ask for a particular Instructor or to request that an Instructor to be changed at any stage throughout the process of learning to drive. After the interview, the first lesson is booked. A client may request individual lessons or book a block of lessons for a reduced fee. 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


8am and as late as 6:30pm. 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. As well as teaching, the Instructors are free to use the cars for personal use. The cars are inspected at regular intervals for faults. 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. It is the responsibility of the Instructor to ensure that the client is best prepared for all parts of the test. The Instructor is not responsible for testing the client and is not in the car during the test but should be available to drop off and pick up the client before and after the test at the DVLA Testing Centre. If a client fails to pass, the Instructor must record the reasons for the failure.


(i) Describe the entity integrity & referential integrity rules in your data model. [10 marks]

Step by Step Solution

3.54 Rating (151 Votes )

There are 3 Steps involved in it

Step: 1

A local conceptual data model for the one user view is as follows A local logical data model from th... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intermediate Financial Management

Authors: Brigham, Daves

10th Edition

978-1439051764, 1111783659, 9780324594690, 1439051763, 9781111783655, 324594690, 978-1111021573

More Books

Students also viewed these Databases questions

Question

=+What is the EVPI?

Answered: 1 week ago

Question

How does the concept of hegemony relate to culture?

Answered: 1 week ago