Microsoft Exam Questions

What is the relationship between Author and Title?

Consider the conceptual database design, depicting the relationship between two entities. The
relationship among Author, Title, and Order is represented by the ER-diagram given below:

What is the relationship between Author and Title?

A.
Many-to-one

B.
One-to-many

C.
One-to-one

D.
Many-to-many

Explanation:
The relationship between Author and Title is many-to-many.
The crowfoot from Author to Title indicates an optional cardinality of any number, or several, i.e. an
author has written either no title or many
titles. Similarly, the crowfoot from Title to Author indicates an optional cardinality of any number, or
several, i.e. a title is either written by at
least one author or many authors.