Employee Eid Name Office Row Gives Unique Id Employee Eid Along Name Address Manager Eid M Q24986354
Employee (eid, name, office) — each row givesthe unique ID of the employee (eid) along with their name andaddress.
Manager (eid, mid) — each row says that theemployee with ID mid is a manager of the employee with ID eid.
Express the query in datalog and relational algebra.
Find all the managers with the property that every employee theymanage is located in same office. Output the manager’s ID and nameand the office where all their employees are located.