Question: Consider the following query on the enterprise database. relation1(CID) :- company(cID, Facebook, a) relation2(elD) :- worksFor(eID, CID), relation1(CID) relation3(pID) :- project(pID, name, budget), budget >

 Consider the following query on the enterprise database. relation1(CID) :- company(cID,

Consider the following query on the enterprise database. relation1(CID) :- company(cID, Facebook, a) relation2(elD) :- worksFor(eID, CID), relation1(CID) relation3(pID) :- project(pID, name, budget), budget > 10000000 relation4(eID) :- worksOn(eID, PID), relation3(pID), not relation2(eld) relation5(elD1) :- manages(elD1, elD2), relation4(elD2) result(eName) :- employee(eld, eName, a), relation5(elD) Zresult What is the correct translation of this query? Find the names of all managers who manage employees who work on a project with a budget over 10000000 for Facebook. Find the names of all managers who manage employees who work on a project with a budget over 10000000, but who do not work for Facebook. Find the names of all managers who work on a project with a budget over 10000000 for Facebook. Find the names of all managers who work on a project with a budget over 10000000, but who do not work for Facebook

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!