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, 22.06.2019 00:00
Which requirement is an appropriate reason for a business to use it tools
Answers: 3
question
Computers and Technology, 22.06.2019 16:00
If a client wants to make minor edits, what should he/she use?
Answers: 3
question
Computers and Technology, 23.06.2019 02:00
Arecipients list has been loaded into a document. which commands should be clicked in order to filter the list so that letters will not be printed for recipients who live in a certain state? mailings tab, start mail merge, select recipients, type new list, then insert only contacts from the desired states mailings tab, rules, select recipients, use existing list, then choose a recipients list that includes only contacts in certain states mailings tab, select recipients, use existing list, rules, fill in, then type in certain states mailings tab, rules, skip record select “state” under field name, then type in the state name under “equal to”
Answers: 2
question
Computers and Technology, 23.06.2019 04:40
The narrative structure of the popular movies can be broken down into
Answers: 3
You know the right answer?
Describe the different ways of implementing one-to-one relationships. Assume you are maintaining inf...
Questions
question
Mathematics, 09.04.2020 21:29
question
Mathematics, 09.04.2020 21:29
Questions on the website: 13722362