The diagram illustrates the relationship between two tables in a database.
What type of relationship exists between Tables I and II?
- one to one
- three to four
- four to three
-
one to many
The correct answer is: D
Explanation
A one-to-many relationship is the most common kind of relationship. In this kind of relationship, a row in table A can have many matching rows in table B. But a row in table B can have only one matching row in table A. A one-to-many relationship is created if only one of the related columns is a primary key or has a unique constraint.