Answered step by step
Verified Expert Solution
Question
1 Approved Answer
name address name address phone URL author publisher URL address email written by published-by) phone customer year Author(name, address, URL) Book(ISBN, title, year, price, publisher
name address name address phone URL author publisher URL address email written by published-by) phone customer year Author(name, address, URL) Book(ISBN, title, year, price, publisher Name) book basketID (number basket-of Written By(name, address, ISBN) Publisher(name, address, phone, URL) price ISBN contains shopping-basket Warehouse(code, phone, address) Stocks(ISBN, WH code, number) Shopping-Basket(basketID. email) stocks warehouse code basketContains(ISBN, basket|D, number) number address phone Customer(email, name, address, phone) Referring to the relational model above (about author, publisher, shopping-basket, ...), provide the algebraic expressing for the following queries. Q1: Report the book title, and year for the books that have been written by exactly 2 authors, one of them is "Mark Smith. Q2: For each customer, we need to report the email and the number of books this customer have bought across all shopping baskets. Q3: Report the unique (distinct) author names who have written books in both 2010 and 2011. name address name, address Phone URL URL author publisher URL address email written-By published-by name phone customer year Author(name, address, URL) Book(ISBN, title, year, price, publisher Name) book title basketID (number basket-of Written By(name, address, ISBN) Publisher(name, address, phone, URL) price ISBN contains shopping-basket Warehouse(code, phone, address) Stocks(ISBN, WH code, number) Shopping-Basket(basketID, email) stocks warehouse code basketContains(ISBN, basket|D, number) number address phone Customer(email, name, address, phone) Q1: Report the book title, and year for the books that have been written by exactly 2 authors, one of them is "Mark Smith". Q2: For each customer, we need to report the email and the number of books this customer have bought across all shopping baskets. Q3: Report the unique (distinct) author names who have written books in both 2010 and 2011
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