Different ways of implementing one-to-one relationships

Assignment Help Database Management System

Reference no: EM13657911

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)

Reference no: EM13657911

Questions Cloud

How many centimeters tall is the box : A box has a volume of 0.57 cubic meters. It is 5.2 feet in length and 15 inches in width. How many centimeters tall is the box?

The concentration field as a function of space and time : How do you obtain the concentration field as a function of space and time?

Is character an essential ingredient in ethical leadership : Is character an essential ingredient in ethical leadership? Is it especially important in managers? In leadership, especially among CEOs, is character important? Why?

What is the average daily water supply : Clearly stating your assumptions, what is the average daily water supply required by the community?

Different ways of implementing one-to-one relationships : Describe the different ways of implementing one-to-one relationships. Assume you are maintaining information on offices and faculty.

How to find eccentricity of load in column : How to find eccentricity of load in column analogy method.?

The sum of the coefficients of x and y : The sum of the coefficients of x and y

What is the average intensity of the wave : An electromagnetic wave has an electrical field by a peak value of 250 N/C. What is the average intensity of the wave?

What is the momentum of electron in the accelerators frame : The linear accelerator at Stanford University (SLAC) is 2.00 miles long and is utilized to accelerate electrons. If an electron is accelerated to 0.999995c, then. what is the momentum of the electron in the accelerator’s frame?

User Account

All Pages