subject

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. Offices( Office_Num, Buildings, Phone Number, Faculty_Num)Faculty(Faculty_Num, Names, Office_Num)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. Offices( Office_Num, Buildings, Phone_Number)Faculty(Faculty_Num, Names, Office Num)c. Some faculty members do not have an office, but all offices are occupied. Offices( Office_Num, Buildings, Phone_Number)Faculty (Faculty_Num , Names ,officeNumber) d. Some faculty members do not have an office, but some offices are not occupied.

ansver
Answers: 1

Another question on Computers and Technology

question
Computers and Technology, 23.06.2019 08:30
Helen's credit card has an apr of 15.32% and a grace period of 17 days and helen pays her balance in the full every month. if her last billing cycle ended on september 26, 2009, and she made her payment on october 11, 2009, did she owe any interest on her last statement's balance?
Answers: 3
question
Computers and Technology, 24.06.2019 12:40
Match the feature to the network architecture. expensive to set up useful for a small organization easy to track files has a central server inexpensive to set up difficult to track files useful for a large organization does not have a central server client- server network peer-to-peer network
Answers: 3
question
Computers and Technology, 24.06.2019 17:30
What is the next step if your volume does not work on computer
Answers: 2
question
Computers and Technology, 24.06.2019 20:30
How is energy expended in active transport
Answers: 1
You know the right answer?
Describe the different ways of implementing one-to-one relationships. Assume you are maintaining inf...
Questions
question
History, 14.10.2019 13:50
question
English, 14.10.2019 13:50
question
Mathematics, 14.10.2019 13:50