Q12,b

MCQMarks unknown

Suppose a database consist of the following relations: SUPPLIER (SCODE,SNAME,CITY). PART (PCODE,PNAME,PDESC,CITY). PROJECTS (PRCODE,PRNAME,PRCITY). SPPR (SCODE,PCODE,PRCODE,QTY). Write algebraic solution to the following :

(A)

Get SCODE values for suppliers who supply to both projects PR1 and PR2.

(B)

Get PRCODE values for projects supplied by at least one supplier not in the same city.

Loading…