Question 1:
Describe the different ways of implementing one-to-one relationships. Assume you are maintaining information on offices (office numbers, buildings, and phone numbers) and faculty (numbers and names).
No office houses more than one faculty member; no faculty member is assigned more than one office. Illustrate the ways of implementing one-to-one relationships using offices and faculty. Which option would be best in each of the following situations?
a. A faculty member must have an office, and each office must be occupied by a faculty member.
b. A faculty member must have an office, but some offices are not currently occupied. You must maintain information about the unoccupied offices in an Office relation.
c. Some faculty members do not have an office, but all offices are occupied.
d. Some faculty members do not have an office, but some offices are not occupied.
Question 2:
For each of the following collections of relations, give the assumptions concerning the relationship between students, courses, and faculty members that are implied by the collection. In each relation, only the primary keys are shown.
a. Student (StudentNum, CourseNum, FacultyNum)
b. Student (StudentNum, CourseNum) Faculty (CourseNum, FacultyNum)
c. Student (StudentNum, CourseNum) Faculty (CourseNum, FacultyNum)
StudentFaculty (StudentNum, FacultyNum)
d. Student (StudentNum, CourseNum, FacultyNum)
e. Student (StudentNum, CourseNum) Faculty (CourseNum, FacultyNum) StudentFaculty (StudentNum, FacultyNum)