Given these facts: Department (dname). meaning dname is the name of a department. Employee...

Transcribed Image Text:

Given these facts: • Department (dname). meaning "dname" is the name of a department. • Employee (name). meaning "name" is the name of an employee. • Manager (name). meaning "name" is the name of an employee who is a manager. • Gain (namel, salary). meaning "name1" has the salary "salary". • managedBy (namel, name2). meaning "namel" manages "name2". • Dept Manager (namel, dname). meaning "name1" manges department "dname". • workin (namel, dname). meaning "name" work in deparment "dname". • Gender (namel, male). • Gender (name2, female). • married (namel, name 2). meaning "name1" as husband married "name2" as wife. Provide the datalog expression of these queries below: Find employees who are manage by umar and are male.(5 marks) Find employee who earn more their manager.(5 marks) Find employee who are married to each other but work in different department (5 marks) Find department who are manage by Fatima or Umar.(5 marks) Find departments that is manage by female employee.(5 marks) DATABASE MANAGEMENT SYSTEM Given these facts: • Department (dname). meaning "dname" is the name of a department. • Employee (name). meaning "name" is the name of an employee. • Manager (name). meaning "name" is the name of an employee who is a manager. • Gain (namel, salary). meaning "name1" has the salary "salary". • managedBy (namel, name2). meaning "namel" manages "name2". • Dept Manager (namel, dname). meaning "name1" manges department "dname". • workin (namel, dname). meaning "name" work in deparment "dname". • Gender (namel, male). • Gender (name2, female). • married (namel, name 2). meaning "name1" as husband married "name2" as wife. Provide the datalog expression of these queries below: Find employees who are manage by umar and are male.(5 marks) Find employee who earn more their manager.(5 marks) Find employee who are married to each other but work in different department (5 marks) Find department who are manage by Fatima or Umar.(5 marks) Find departments that is manage by female employee.(5 marks) DATABASE MANAGEMENT SYSTEM

Answer rating: 100% (QA)

To express the given queries in Datalog we can use the following representations Find employees who ... View the full answer