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 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
Get step-by-step solutions from verified subject matter experts
