Question: Q 5 Consider the following Relation Schema SUPPLIER ( sid , sname, street ) PARTS ( pid , pname, colour ) CATALOG ( sid ,
QConsider the following Relation Schema SUPPLIER sid sname, street
PARTS pid pname, colour
CATALOG sid pid, cost
For Query and Query write the
a Relational Algebra
b Tuple Relational Calculus and
c Domain Relational Calculus Expression.
i: Query Find the pids of parts supplied by at least two different suppliers. NOTE: do not use aggregate functions
ii: Query Find the sids of suppliers who supply some red part, or are at 'Gandhi Street'.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
