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)
You might also like to view...
Which of the following tabs should you click to verify that the margins and page size are correct?
A. VIEW B. DESIGN C. PAGE LAYOUT D. REVIEW
?Case 21-1 Roger has been recently appointed as a team lead in an IT firm. He often needs to make PowerPoint presentations to discuss the team's progress, project related details, etc. Microsoft PowerPoint is used to present data in a crisp manner. Hence, the software allows a user to add images and other graphics to enhance the visual appeal. Roger creates a PowerPoint presentation to show the productivity of his team in last week. He uses the SmartArt tool to make the presentation. While reviewing his presentation, Roger decides to change the color of the SmartArt shapes by choosing from a predefined combination of colors set for the SmartArt. In this scenario, Roger should click the _____ tab to change the color of the SmartArt shapes.?
A. ?SmartArt Tools Design B. ?SmartArt Layout C. ?SmartArt Illustrations View D. ?SmartArt Preset
Changing the title of the page when you save it is a good habit to get into, because ____.
A. you cannot save the page without the change B. you don't have to remember to make the change later C. you are required to change the title to proceed D. None of the above.
A block of text that is used to retrieve data from the tables in a database.
What will be an ideal response?