Question

Question No 2: Perform following tasks for the given relational algebraic queries Using statistics in first question. [Marks: 16+8+8+8 = 40]
1- Calculate Cost
2- Write SQL Query
3- Convert cartesian product into join and join into cartesian product. (Only Relational)
4- Write Alternate of these relational queries by using “Selection and Joins are Commutative” rule for both of the given relational queries.
i. PNAME (((sCITY!= ‘Rawat’(Customer)) ⋉cid(Order)) ⋈0id(soquantity!=3 (Invoice)))
ii. PPrice(sP.PID=I.PID^O.OID=I.OID(((sPrice>30(Product))XInvoice))X(soid!=3 (Order)))​

Answer 1

Answer:

if. ivih oh oh oh oh ig ufxufxufxuxigcigcoh oh oh oh o oh oh oh oh oh oh oh oh ho oh oh oh oh p