Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Author(name, address, URL) Book(ISBN, title, year, price, publisher_Name) WrittenBy(name, address, ISBN) Publisher(name, address, phone, URL) Warehouse(code, phone, address) Stocks(ISBN, WH_code, number) Shopping-Basket(basketID, email) basketContains(ISBN, basketID,
Author(name, address, URL)
Book(ISBN, title, year, price,
publisher_Name)
WrittenBy(name, address, ISBN)
Publisher(name, address, phone, URL)
Warehouse(code, phone, address)
Stocks(ISBN, WH_code, number)
Shopping-Basket(basketID, email)
basketContains(ISBN, basketID, number)
Customer(email, name, address, phone)
Referring to the relational model in slide 15 in"ER-mapping" (about author, publisher, shopping-basket, provide the algebraic pressing 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 2011Step 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