Get the part names that Adams provides Get supplier names fo

Get the part names that Adams provides.

Get supplier names for suppliers who supply part P2.

Get supplier names and the quantity of parts supplied.

Get supplier names for suppliers who supply parts with quantity less than 300 (instead of 500)

Get supplier names for suppliers who supply either blue or green parts.

Get supplier name/part name pairs such that the indicated supplier does not supply the indicated part.

Get supplier names for suppliers who does not supply any parts.

Get supplier names for suppliers who supply all parts.

Get supplier names for suppliers who supply all parts except P1.

Get supplier names and the number of parts and total quantity supplied.

Use both

Solution

No Tuples Available

{<SNAME>|<SNAME>Suppliers ^S1,P1(<S1,P1>SP^S#=S1^P1=’2’)}

SNAME

SMITH

JONES

BLAKE

CLARK

{<SNAME,QTY>|<SNAME>Suppliers^<QTY>SP ^S1,P1(<S1,P1>SP^S#=S1^sum(QTY))}

SNAME

QTY

SMITH

1300

JONES

700

BLAKE

200

CLARK

900

{<SNAME>|<SNAME>Suppliers ^S1,P1(<S1,P1>SP^S#=S1^QTY<300)}

SNAME

SMITH

BLAKE

CLARK

{<SNAME>|<SNAME>Suppliers^S1(<P1>SP^S#=S1^P1,COLOR(<P1,COLOR>Parts^P#=P1^COLOR=GREENVBLUE))}

SNAME

SMITH

JONES

CLARK

{<SNAME>|<SNAME>Suppliers ^S1,P1(<S1,P1>SP^S#!=S1)}

SNAME

ADAMS

{<SNAME>|<SNAME>Suppliers ^S1,P1(<S1,P1>SP^S#=S1^P1=’ ’1’AND’2’AND’3’AND’4’AND’5’)}

SNAME

SMITH

{<SNAME>|<SNAME>Suppliers ^S1,P1(<S1,P1>SP^S#=S1^P1=’ ‘2’AND’3’AND’4’AND’5’)}

No Tuples Available

{<SNAME,QTY>|<SNAME>Suppliers^<QTY>SP ^S1,P1(<S1,P1>SP^S#=S1^count(S#)sum(QTY))}

SNAME

TOTAL PARTS

QUANTITY

SMITH

6

1300

JONES

2

700

BLAKE

1

200

CLARK

3

900

ADAMS

0

0

SNAME

SMITH

JONES

BLAKE

CLARK