Answered step by step
Verified Expert Solution
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
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
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