Menu

[solved]-Write Following Query Unextended Relational Algebra Find Every Person Works Least Two Diff Q39022774

company(co_name, govt id, ceo_ssn, hq_loc) division(co id, div_name, subdiv_of, dir_ssn, div_hq) site(co id, div_name, loc) p

Write the following query in unextended relational algebra:

Find every person who works for at least two different divisionsof the same company.

company(co_name, govt id, ceo_ssn, hq_loc) division(co id, div_name, subdiv_of, dir_ssn, div_hq) site(co id, div_name, loc) product(prod id, manuf co, manuf_div, loc, prod_descr) person(ssn, name, address) works_for(ssn, co id, div_name, salary, emp_id, sup_ssn) skill(ssn, prod id, manuf co Show transcribed image text company(co_name, govt id, ceo_ssn, hq_loc) division(co id, div_name, subdiv_of, dir_ssn, div_hq) site(co id, div_name, loc) product(prod id, manuf co, manuf_div, loc, prod_descr) person(ssn, name, address) works_for(ssn, co id, div_name, salary, emp_id, sup_ssn) skill(ssn, prod id, manuf co

Expert Answer


Answer to Write the following query in unextended relational algebra: Find every person who works for at least two different divis… . . .

OR


Leave a Reply

Your email address will not be published. Required fields are marked *