Question 16

Suppose a book author can be identified by an AuthorID and each book can be identified by an ISBN. Besides the identifier, an author and a book each has many other attributes like name, address, email, phone, and price, title, publisher, publish year, edition, etc. In general publishing business, an author may write no book or many books but every book must have at least one author.

If a data model is defined for the above business in an entity-relationship diagram (ERD) as shown below. Then, which multiplicity symbol should be used at the place pointed by the red arrow?

(a)

(b)

(c)

(d)

Question 17

If we continue on Question 16 to complete the ERD of the data model, which multiplicity symbol should be used at the place pointed by the blue arrow?

(a)

(b)

(c)

(d)

Question 18

If the data model of Question 16 and 17 is revised to replace the many-to-many relationship, a new entity, say, Contract, must be included in between Author and Book and the many-to-many relationship will be replaced by two new relationships as shown below. Then, the multiplicity at the place pointed by the red and blue arrows should be

(b) at the red arrow and (d) at the blue arrow

(c) at the red arrow and (a) at the blue arrow

(a) at the red arrow and (d) at the blue arrow

(d) at the red arrow and (c) at the blue arrow

Question 19

If the Contract entity of the ERD shown in Question 18 is implemented as a table in database, how many foreign keys it will have?

zero

one

two

three

Author Book AuthorIID ISBN