Question: Consider the schema described below where bold face attributes indicate primary keys: employee(person_name, street, city) works(person_name, company name, salary) company(company name, city) manages(person_name, manager_name) Which

 Consider the schema described below where bold face attributes indicate primary

Consider the schema described below where bold face attributes indicate primary keys: employee(person_name, street, city) works(person_name, company name, salary) company(company name, city) manages(person_name, manager_name) Which is the correct Datalog translation of the following Natural Language query? Find the names of all direct and indirect employees of managers, where the manager works for a company located in Eindhoven. O eindhoven_company_employees (PN) :- works(PN, C, S), company(C, "Eindhoven") all_managers(M) :- manages(PN, M), eindhoven_company_employees(M) all_employees(E) :- manages(E, M), all_managers(M) all_employees(PN) :- manages(PN, E), all_employees(E) ?all_employees(PN) O eindhoven_company_employees (PN) :- works(PN, C, S), company(C, "Eindhoven") all_managers(M) :- manages(PN, M), eindhoven_company_employees(M) all_employees(E) :- manages(E, M), all_managers(M) ?all_employees(E) O eindhoven_employees (PN) :- works(PN, C, S), employee(PN, "Eindhoven") all_managers(M) :- manages(PN, M), eindhoven_employees(M) all_employees(E) :- manages(E, M), all_managers(M) all_employees(PN):- manages(PN, E), all employees(E) ?all_employees(PN) O eindhoven_company employees (PN) :- works(PN, C, S), company(c, "Eindhoven") all_managers(M) :- manages(PN, M) all_employees(E) :- manages(E, M), all_managers(M) all_employees(E) :- manages(PN, E), all_employees(E) ?all_employees(PN)

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!