Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

6. (14%) Suppose a relational database contains the following tables: BookTitles BookAuthors book_id year title price book_id author_id 232 1944 Animal Farm 4.20 232 4152

image text in transcribed

6. (14%) Suppose a relational database contains the following tables: BookTitles BookAuthors book_id year title price book_id author_id 232 1944 Animal Farm 4.20 232 4152 BookAttributes book_id attribute_code attribute_value 232 2 Secker & Warburg 232 Distopia AuthorNames author_id gender 4152 0 George Orwell name Here 2 is a code for publisher, 5 for literary genre, O for male, 1 for female; Give mappings populating the following: classes: Author, Male Author, Female Author, Book -object properties: hasAuthor (domain: Book, range: Author) data properties: published In Year (domain: Book, range: xsd:integer), isPublishedBy (range: xsd:string), hasPrice (range: xsd" :double) Give SPARQL queries that find: - the titles of all books published by Oxford University Press and having both male and female authors; the titles and the authors of all books published in 2015 (with information about the publisher if available)

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

More Books

Students also viewed these Databases questions

Question

=+12. Did your concept illustrate the brand's personality?

Answered: 1 week ago

Question

Contrast the Project Plan, the Project Charter, and the WBS.

Answered: 1 week ago

Question

=+what information would you need about the compact disc industry?

Answered: 1 week ago