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)

Computer Science & Information Technology

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.

Computer Science & Information Technology

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

Computer Science & Information Technology

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.

Computer Science & Information Technology

What type of power issue occurs when a facility experiences a momentary loss of power?

A. Fault B. Blackout C. Sag D. Brownout

Computer Science & Information Technology