Semantic Technologies

6. (14%) Suppose a relational database contains the following tables: Book Titles 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 5 Distopia AuthorNames author_id gender name 4152 0 George Orwell Here 2 is a code for publisher, 5 for literary genre, O for male, 1 for female; Give mappings populating the following: classes: Author, MaleAuthor, FemaleAuthor, Book object properties: hasAuthor (domain: Book, range: Author) data properties: publishedIn 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). 6. (14%) Suppose a relational database contains the following tables: Book Titles 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 5 Distopia AuthorNames author_id gender name 4152 0 George Orwell Here 2 is a code for publisher, 5 for literary genre, O for male, 1 for female; Give mappings populating the following: classes: Author, MaleAuthor, FemaleAuthor, Book object properties: hasAuthor (domain: Book, range: Author) data properties: publishedIn 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)