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
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 ContributesStep 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