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
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?
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?
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
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?
a. zero
b. one
c. two
d. three
Author Book AuthorIID ISBNStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started