Consider translating this UML diagram to relations. Which of the following relat
ID: 3740744 • Letter: C
Question
Consider translating this UML diagram to relations. Which of the following relations would not be generated by any of the recommended translation schemes discussed in the video?
Publication(name, publisher, ISBN, pub-title, year)
Book(ISBN, edition)
Publication(ISBN, pub-title, year, volume, edition)
Publication(ISBN, pub-title, year, name, start-date, end-date)
2.
Based on this UML diagram, which of the following statements about Authors is correct?
An author can write a book or contribute an article, but not both.
Every book has up to one author.
An author who has written a book has also contributed an article.
Every article has at least one author.
3.
Based on this UML diagram, which of the following relations best represents articles?
Article(title, pages, keywords)
Article(title, pages, keywords, ISBN)
Article(title, pages, keywords, ISBN, pub-title, year)
Article(title, pages, keywords, ISBN, volume)
4.
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)
Editor name PK publisher 1..1 Assignment start-date end-date Edits Publication ISBN PK pub-title year complete, disjoint Collection Book volume edition Writes 10..30 Article title PK 0..* pages keywords Author pen-name PK affiliation ContributesExplanation / Answer
Solution:
1)
Publication(ISBN, pub-title, year, volume, edition)
2)
Every article has at least one author.
Explanation:
The above statement is correct because an article can be written by 1 to 4 authors.
3)
Article(title, pages, keywords)?
4)
Edits(name, ISBN, start-date, end-date)
I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)