This question is based on the SPC database in Figure 4.5 on page 102 of the text.

Suppliers(sid, sname, address)

Parts(pid, pname, colour)

Catalog(sid, pid, quantity)

The keys are sid, pid, {sid,pid}, respectively.

sid sname city pid pname colour sid pid quantity

-------------- ---------------- ----------------

s1 smith london p1 nut red s1 p1 200

s2 jones paris p2 bolt green s1 p3 300

s3 blake paris p3 screw red s2 p1 100

s4 clark london p4 cam blue s2 p2 400

s5 adams athens p5 cog green s2 p3 200

s6 (you) regina s2 p4 300

s2 p5 100

s3 p2 200

s3 p5 400

s4 p4 400

s5 p1 100

s5 p2 200

Create the relational algebra, the tuple relational calculus, and SQL(I need queries of relational algebra, tuple relational calculus and SQL query and output relation seperately and please mention which is what)

queries for each of the following questions:

1. Find the names of suppliers who supply some blue part.

2. Find the names of suppliers who supply some red or green part.

3. Find the names of suppliers who supply some red part and some green part.

4. Find the sids of suppliers who supply every part.

5. Find the sids of suppliers who supply every red part.

6. Find the sids of suppliers who supply every red or green part.

7. Find the sids of suppliers who supply every red part or supply every green part.

8. Find the (sname,pname) pairs such that the indicated supplier

does not supply the indicated part.

For Relational Algebra and Tuple Calculus:

Either complete this assignment with a text editor or on the WINRDBI software package.

For reference material, visit https://winrdbi.asu.edu/

FOR SQL:

This assignment is to be completed on a DBMS of your choice.

Clearly indicate the name and version of your DBMS at the top of your assignment.

(i) a screenshot of your SPC database

(ii) a screenshot of each relational algebra query, and

(iii) a screenshot of each tuple calculus query,

(iii) a screenshot of each SQL query and output relation.

I need queries of relational algebra, tuple relational calculus and SQL query and output relation seperately and please mention which is what in answers.