Question: For your reference: Symbols to use for relational algebra operators. Selection Projection Join Cross product Rename Set operations un Division Problem 3. (12 points) Assume




For your reference: Symbols to use for relational algebra operators. Selection Projection Join Cross product Rename Set operations un Division Problem 3. (12 points) Assume the relation schemas given in Problem 1. Use relational algebra and SQL to express this query: Find the names (iName) that are shared by at least two different items supplied by the same supplier. For example, supplier SI may supply the items Cl and C2 (i.e., siCode-Cl and CI), but these two items share the same name "widget" (iName= "widget"). Relational Algebra: SQL:Problem &. (12 points ; Assume the relation schemas given in Problem 1. Use relational algebra and SQL to express this query :` Find the departmentis ] [ally ; for which employees ELLELL_EI'M and EZ TELL - " EZ"; both work. Relational Algebra . SOIL. Problem S. (12 points ; Assume the relation schemes given in Problem 1 . Use relational algebra and SOL to express this query :" Find the departments Call'; that sell only expensive items [expensive items are those with MISRE _ Lodi. Assume each department sells something . Relational Algebra . SOIL.Problem 6. 1'14 points ) Assume the relation Schemes given in Problem 1 . Use relational algebra and SOL to express this query .` A supplier is said to supply to a department if the department sells an item supplied by the supplier . Find the suppliers IsName; who supply to all the departments with a budget = 1010 . Relational Algebra GUILDepts(dID, dName, budget) Gives the departments, their ID, name and d stands for department. budget. Employees(elD, dID, eName, eSalary) Gives the employees, their IDs, where they e stands for employee work, their names and salaries. Suppliers(sID, $Name, sCity, sState, el.D) Gives the suppliers, their IDs, their names, s stands for supplier. and where they are located (city and state). Also tells which employees are contact persons for the suppliers. Items(sID, siCode, dID, iName, MSRP) Gives the items and the departments that sell i stands for item, siCode stands for supplier- the items. MSRP=manufacturer suggested assigned item code. retail price
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
