Ways of implementing one-to-one relationships

Assignment Help Database Management System

Reference no: EM1360007

Describe the difference ways of implementing one-to-one relationships. Assume you are maintaining information on offices (office numbers, building, 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.

Reference no: EM1360007

Questions Cloud

Social discount rate : The second discount rate is known as the social discount rate. It is based on judgments about the collective value that society attaches to a policy. Proponents argue that the social discount rate is preferred because it broadens the preferences cons..

Find the magnitude and direction of the acceleration : Find the magnitude and direction of the acceleration. A 2.60 kg steel ball strikes a wall with a speed of 10.0 m/s at an angle of 60.0° with the surface. It bounces off with the same speed and angle. If the ball is in contact with the wall for 0.19..

Qualitative and quantitative data collection : Explain the advantages and disadvantages of the various methods of data collection- Qualitative and Quantitative Data Collection

Make a break-even chart using total cost versus volume : Peter, a president of a company produces power transformers for personal computer manufacturers. Peter's choice of the various methods by which a new model of transformer can be built has been narrowed to 3 alternatives.

Ways of implementing one-to-one relationships : Describe the difference ways of implementing one-to-one relationships. Assume you are maintaining information on offices (office numbers, building, and phone numbers)

Why should john and karl live together : Why should John and Karl live together. If they do, will there be dirty dishes in the sink. Explain

What is drucker saying with this quote : What is Drucker saying with this quote and Do you agree or disagree? Does business really have other societal obligations besides making a profit?

How weight represents the amount of raw materials : How weight represents the amount of raw materials. Data containing the weight in pounds from a sample of 368 pallets of Bridgetown shingles and 330 pallets of Holetown shingles are contained in Pallet data which can be downloaded from the class web..

Complete information-level design for set of requirements : A database at a college is required to support the following requirements. Complete the information-level design for this set of requirements. Determine any constraints you need that are not stated in the problem.

User Account

All Pages