Under normal circumstances, the cardinality ratio of the binary relationship…

2017

Under normal circumstances, the cardinality ratio of the binary relationship “Write” relating “Author” and “Book” entities is:

  1. A.

    1 : N

  2. B.

    N : 1

  3. C.

    1 : 1

  4. D.

    M : N

Attempted by 631 students.

Show answer & explanation

Correct answer: D

Under normal circumstances, one author can write multiple books, and a single book can be co-authored by multiple individuals. This creates a bidirectional multi-valued mapping between the two entities. Therefore, the cardinality ratio is Many-to-Many (M : N). Option D is correct.

Explore the full course: Niacl Ao It Specialist