Create and validate a local logical data model from the conceptual data model for the EasyDrive School of Motoring case study created

What will be an ideal response?

Office (officeNo, oAddress, oPostcode, oTelNo, oFaxNo, mgrStaffNo)
Primary Key officeNo
Alternate Key oPostcode
Alternate Key oTelNo
Alternate Key oFaxNo
Foreign Key mgrStaffNo references Staff(staffNo)
Staff (staffNo, fName, lname, sAddress, jobTitle, salary, NIN, sex, dob, officeNo)
Primary Key staffNo
Alternate Key NIN
Foreign Key officeNo references Office(officeNo)
Inspection(staffNo, inspDate, inspTime, faultsFound, comments)
Primary Key staffNo, inspDate, inspTime
Foreign Key staffNo references Staff(staffNo)
Vehicle(vehRegNo, model, make, color, capacity, officeNo)
Primary Key vehRegNo
Foreign Key officeNo references Office(officeNo)
Client(clientNo, cPostcode, cTelNo, dLicenseNo, sex, dob, officeNo)
Primary Key clientNo
Alternate Key dLicenseNo
Foreign Key officeNo references Office(officeNo)
Interview(staffNo, iDate, iTime, iRoom, iComments, clientNo)
Primary Key staffNo, iDate, iTime
Foreign Key clientNo references Client(clientNo)
Lesson(lessonNo, lessonDate, lessonTime, stage, progress, comments,
mileageStart, mileageFinish, staffNo, clientNo, vehRegNo)
Primary Key officeNo
Foreign Key staffNo references Staff(staffNo)
Foreign Key clientNo references Client(clientNo)
Foreign Key vehRegNo references Vehicle(vehRegNo)
DrivingTest(testNo, testDate, testTime, testCentre, testerName, attempt, result,
pTestComment, tTestMark, tTestComments, clientNo, vehRegNo)
Primary Key testNo
Alternate Key clientNo, testDate
Alternate Key vehRegNo, testDate, testTime
Alternate Key testerName, testDate, testTime
Foreign Key clientNo references Client(clientNo)
Foreign Key vehRegNo references Vehicle(vehRegNo)