The Problem,

The Half Moon Driving School was established in Alkhobar in $2020.$ Since then, the school has grown

steadily and now has several offices in most of the cities of the eastern province of the Kingdom. The

school has become large and more administrative staff are being employed to cope with the ever$-$

increasing amount of paperwork. Furthermore, the communication and sharing of information between

offices, even in the same city, is poor.

The Director of the school feels that too many mistakes are being made and that the success of the

school will be short$-$lived if he does not do something to remedy the situation. He knows that a database

could help in part to solve the problem and has approached you and your team to help in creating a

database system to support the running of his business.

Data Requirements

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, which includes completion of 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 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 as $8$:$00$ a$.$m$.$ and as late as $8$:$00$

p$.$m$.$ 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. 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 driving and written parts of the test. It is the responsibility of the Instructor to ensure that the

client is best prepared for all aspects of the test.

The Assignment:

Based on your learning experience in Database concepts, and based on what we learned so far in ythe

advanced database course. You are required to do the following

Create a plan for implementing the requested database

Provide a conceptual and logical design for the requested database

Provide feedback for the Director of the Half Moon driving school