Suppose we have a relation employees ssn name department

Assignment Help Database Management System

Reference no: EM13380038

Suppose we have a relation Employees (SSN, name, department, salary).

For each of the following queries, either write the query in relational algebra and explain informally why your answer works, or explain why it cannot be written in relational algebra.

You may use sequences of assignments or expression trees if you like. You may use only the following operators of relational algebra: union, intersection, difference, selection, projection, products, joins (theta and natural), renaming.

a) Find all department(s) with at least two employees of different names.

b) Find the department(s) with the most people.

c) Find the names of employee(s) with the highest salary.

d) For each employee, find their name and their supervisor's name.

e) Find the supervisor with the lowest salary

f) Find the number of supervisor in every department.

Reference no: EM13380038

Questions Cloud

1 what is the role of the project manager why is : 1. what is the role of the project manager? why is leadership so important for project managers?2. discuss the

Fiction corporation is a large national retail chain of : fiction corporation is a large national retail chain of 10000 employees and 500 retail outlets. fiction is moving its

Your database has been a hit you have been called back to : your database has been a hit. you have been called back to the customers headquarters and they want a detailed report

Consider the following database that contains information : consider the following database that contains information about people vacation locations and when those people visited

Suppose we have a relation employees ssn name department : suppose we have a relation employees ssn name department salary.nbspfor each of the following queries either write the

1 a discuss the importance of scada securityb why are scada : 1. a. discuss the importance of scada security.b. why are scada systems particularly vulnerable to cyber treats? c.

Design reportthe design report is a single team report that : design reportthe design report is a single team report that describes the functionality of the application in its final

Question 1describe a malware attack that causes the victim : question 1describe a malware attack that causes the victim to receive physical advertisement.question 2suppose that a

Your supervisors and customers are very impressed with the : your supervisors and customers are very impressed with the database you have put together. however there is still that

User Account

All Pages