Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Employees (ENO, Ename, Hire_Date); Books (ISBN, Bname, Quantity, Price); Customers (CNO, Cname, Street, Zip, Phone); Orders (ONO, CNO, ENO, Received, Shipped); Orderline (ONO, ISBN, Qty);

Employees (ENO, Ename, Hire_Date);

Books (ISBN, Bname, Quantity, Price);

Customers (CNO, Cname, Street, Zip, Phone);

Orders (ONO, CNO, ENO, Received, Shipped);

Orderline (ONO, ISBN, Qty);

Zipcodes (Zip, City, State);

1) Customers (name) who ordered all the books as customer #11111 ordered (although, they may have ordered additional books).

2) Customers (name) who ordered at least one book that customer #1111 ordered.

can you solve using relational algebra please?

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

Database Concepts

Authors: David Kroenke, David Auer, Scott Vandenberg, Robert Yoder

8th Edition

013460153X, 978-0134601533

More Books

Students also viewed these Databases questions

Question

6 Compare and contrast mentoring and coaching.

Answered: 1 week ago