Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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?

image text in transcribed

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?

image text in transcribed

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 ISBN

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Relational Database Technology

Authors: Suad Alagic

1st Edition

354096276X, 978-3540962762

More Books

Students also viewed these Databases questions

Question

Apply your own composing style to personalize your messages.

Answered: 1 week ago

Question

Format memos and e-mail properly.

Answered: 1 week ago