Ask Question

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.

+3
Answers (1)
  1. 30 June, 15:35
    0
    a) We know that atleast one or more author writes a book.

    Symbol to indicate one or more is (B)

    So the correct option is B

    b) We know that zero to multiple books are written by any author.

    Symbol to indicate zero or more is (A)

    So the correct option is A

    c) The fourth option is correct if we replace by many to many relationship and generate a new entity.

    So the relationship betweem author and contract is one to many. So we know that there is atleast one author that represent in symbol d and books has atleast 0 that represent in symbol c.

    So Fourth Option is correct d at blue side and c at red side.

    d) There are two forirgn keys in table Contract one is from AuthorId and other is ISBN.

    So correcct option is C
Know the Answer?
Not Sure About the Answer?
Find an answer to your question 👍 “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 ...” in 📗 Computers & Technology if the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers