An article may have any number of authors .An author who has written a book has

Question

An article may have any number of authors

.An author who has written a book has also contributed an article.

Every article has at least one author.

Every author has contributed up to four articles.

[2] Based on this UML diagram, which of the following relations best represents articles?

Article(title, pages, keywords, ISBN)

Article(title, pages, keywords, volume, ISBN, pub-title, year)

Article(title, pages, keywords, ISBN, volume)

Article(title, pages, keywords)

[3] Consider translating this UML diagram to relations. In the relation Edits generated from the Edits association, which of the following set of underlined attributes is a minimal key?

Edits(name, ISBN, start-date, end-date)

Edits(name, ISBN, start-date, end-date)

Edits(name, ISBN, start-date, end-date)

Edits(name, ISBN, start-date, end-date)

Collection volume 10..30 Article title PK 0. pages keywords Editor name PK publisher 1..1 Assignment Edits start-date end-date Publication ISBN PK pub-title year complete, disjoint Book edition Writes 0..* Author 1..4 pen-name PK Contributes affiliation

Explanation / Answer

!) every article has atleast one author

because articles are written by authors and without the authors how can there be an article, therefore for every article there is atleast one author

2) Article(title, pages, keywords)

3) The minimal key is name as it is marked as PK in the above mentioned UML diagram

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.