Read and analyze the data requirements below. follow database normalization rules to create 3NF tables.

you need to list all tables with fields and primary key and foreign keys and submit word document.

example:

Office (officeNo, oAddress, oCity,oState, oPostcode, oTelNo, oFaxNo, mgrStaffNo)

Primary Key officeNo Foreign Key mgrStaffNo references Staff(staffNo)

Staff (staffNo, fName, lname, sAddress,sPostcode, sCity, sState, jobTitle, salary, gender, dob, officeNo)

Primary Key staffNo Foreign Key officeNo references Office(officeNo)

**********************************************************************************************************************************

data requirements:

• This driving school has several offices in different parts of the city
• 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. 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 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 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 Testing Center.
• If a client fails to pass, the Instructor must record the reasons for the failure.

Answer rating: 100% (QA)

Based on the provided data requirements we can design a normalized database schema in 3NF Third Norm... View the full answer