PrepAway - Latest Free Exam Questions & Answers

what types of relationships that can exist between any two fields (Choose all that apply.?

In your relational database, what types of relationships that can exist between any
two fields (Choose all that apply.?

PrepAway - Latest Free Exam Questions & Answers

A.
One to one

B.
One to many

C.
Many to Many

D.
On to Zero

E.
Zero to Zero

Explanation:
In any relational database system, every field is related to every other
field. There are three types of relationships that can exist between two fields
One to one A one to one relationship exists when for every value of a there is one and
only one correspondig value of b, and for every value of b there is one and only one
corresponding value of a. One to one relationships are modeled within a single table.
One to many A one to many relationship exists when for every value of a there is one or
more corresponding values of b, and for every value of b there is one and only one
corresponding value of a. One to many relationships require two tables to model.
Many to Many A many to many relationship occurs when for every one value of a there
is one or more corresponding values of b, and for every one value of b there is one or
more corresponding values of a. Many to many relationships actually require three tables
to model correctly.


Leave a Reply