RELATIONAL ALGEBRA Consider the following relational schema: Supplier(supplier D, sname, address) Partipartid, pname, co

[answerhappygod]

Relational Algebra Consider The Following Relational Schema Supplier Supplier D Sname Address Partipartid Pname Co 1 (19.15 KiB) Viewed 25 times

RELATIONAL ALGEBRA Consider the following relational schema: Supplier(supplier D, sname, address) Partipartid, pname, colour) Catalog(supplier D, partid, cost) The relation Supplier stores suppliers and the key of that relation is supplier|D. The relation Part stores parts, and partiD is the key of that relation. Finally, Catalog stores which supplier supplies which part at which cost. The key is the combination of the two attributes supplierID and partiD. Required For each of the following relational algebra queries, say in English what they mean [2 + 2 + 2 marks] i) dsnametocolour='red' (Part) Nocost< 100 (Catalog) Supplier) ii) nsname(ocolour='red' (Part) x cost<100 (Catalog) » Supplier) jsname(ocolour='green' (Part) o ocost<100 (Catalog) » Supplier) iii) asid(ocolour='red' (Part) | acost<100 (Catalog) * Supplier) Onsidéocolour='green' (Part) | acost<100 (Catalog) Supplier)