Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Given these facts: Department (dname). meaning dname is the name of a department. Employee (name). meaning name is the name of an employee. Manager
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
Step by Step Solution
★★★★★
3.46 Rating (149 Votes )
There are 3 Steps involved in it
Step: 1
To express the given queries in Datalog we can use the following representations Find employees who ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started