Answered step by step
Verified Expert Solution
Link Copied!

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

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 ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

A First Course In Probability

Authors: Sheldon Ross

9th Edition

978-9332519077, 9332519072

More Books

Students also viewed these Programming questions