Create and validate a logical data model from the local conceptual data model for the University Accommodation Office case study created
What will be an ideal response?
Student (matricNo, fName, lName, street, city, postcode, DOB, sex, category,
nationality, smoker, special needs, comments, status, courseNo)
Primary Key matricNo
Foreign Key courseNo references Course(courseNo)
NOK (matricNo, name, street, city, postcode, contactTelNo)
Primary Key matricNo
Foreign Key matricNo references Student(matricNo)
Course (courseNo, courseTitle, courseLeader, courseLeaderTelNo,
courseLeaderRoomNo, deptName)
Primary Key courseNo
Alternate Key courseTitle
Hall (halINo, hName, hAddress, hTeINo, mgrStaffNo)
Primary Key nalINo
Alternate Key hName
Alternate Key hTelNo
Foreign Key mgrStaffNo references Staff(staffNo)
Flat (flatNo, fAddress, noOfRooms)
Primary Key flatNo
Room (placeNo, roomNo, monthlyRent, flatNo, hallNo)
Primary Key placeNo
Foreign Key halINo references Hall(hallNo)
Foreign Key flatNo references Flat(flatNo)
Flatlnspection (flatNo, iDate, condition, comments, inspStaffNo)
Primary Key flatNo, iDate
Foreign Key flatNo references Flat(flatNo)
Foreign Key inspStaffNo references Staff(staffNo)
Lease (leaseNo, duration, matricNo, placeNo, dateEnter, dateLeave)
Primary Key leaseNo
Alternate Key placeNo, dateEnter
Alternate Key matricNo, dateEnter
Foreign Key matricNo references Student(matricNo)
Foreign Key placeNo references Room(placeNo)
AccommStaff (staffNo, fName, lName, street, city, postcode, DOB, sex, position,
location)
Primary Key staffNo
Foreign Key location references Hall(halINo)
Invoice (invoiceNo, semester, paymentDue, datePaid, paymentMethod,
dateReminder1, dateReminder2, leaseNo)
Primary Key invoiceNo
Foreign Key leaseNo references Lease(leaseNo)
You might also like to view...
Which of the following is not a kind of inheritance in C++?
a. public. b. private. c. static. d. protected.
If you use a(n) ________ indent tab all lines but the first in a paragraph are indented
Fill in the blank(s) with correct word
Using the Cell Properties dialog box, you can ____.
A. specify a cell as a header cell B. create cells that span columns and rows C. set borders and background images on individual or multiple cells D. All of the above.
What type of power issue occurs when a facility experiences a momentary loss of power?
A. Fault B. Blackout C. Sag D. Brownout