Computers and Technology, 06.05.2020 02:18, eduardo60

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.

Answers: 1

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 21.06.2019 15:00, vdkgknsdg9996

Much has been made of the new web 2.0 phenomenon, including social networking sites and user-created mash-ups. how does web 2.0 change security for the internet? how do secure software development concepts support protecting applications?

Answers: 1

continue

Computers and Technology, 22.06.2019 00:30, Angellbatton6763

At an open or uncontrolled intersection, yield if a. your road is paved and the crossroad is not b. the cross road is paved and yours is not c. you have two or more passengers in your vehicle d. you did not yield in the last intersection

Answers: 1

continue

Computers and Technology, 22.06.2019 19:30, tfaulk2884

Singing in the rain: this first part of the film shows the early history of motion picture. how accurate do you think the portrayal of the early motion picture industry is? why? is historical accuracy important in films and theater productions? explain.

Answers: 1

continue

Computers and Technology, 23.06.2019 07:50, kmart4062

Apython programming question: assume s is a string of lower case characters. write a program that prints the number of times the string 'bob' occurs in s. for example, if s = 'azcbobobegghakl', then your program should print number of times bob occurs is: 2

Answers: 3

continue

Do you know the correct answer?

Describe the different ways of implementing one-to-one relationships. Assume you are maintaining inf...