Answered step by step
Verified Expert Solution
Link Copied!

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,

image text in transcribed

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 2011

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

Beginning ASP.NET 4.5 Databases

Authors: Sandeep Chanda, Damien Foggon

3rd Edition

1430243805, 978-1430243809

More Books

Students also viewed these Databases questions