Reference no: EM13187954
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.
|
Estimate the population and the rate of population growth
: If t denotes the time in years after 1980, find a formula for N(t), the population in millions at time t. Assuming that this rapid growth rate continues, estimate the population and the rate of population growth in the year 2000.
|
|
Neoclassicism-impressionism and abstract expressionism
: compares and contrasts Neoclassicism, Impressionism, and Abstract Expressionism. How each style reflects its era and the culture. Discussion of painting techniques. Formal elements
|
|
Estimate of the total distance the student car traveled
: What is your best estimate of the total distance the student's car traveled before coming to rest (note that the best estimate is probably not the over or under estimate that you can most easily find)?
|
|
State equation of the dissolution reaction
: Write an equation of the dissolution reaction for each of the precipitates that was soluble in CH3COOH. Al2(SO4)3+NaOH
|
|
Find the names of employees with the highest salary
: Find all department(s) with at least two employees of different names and find the department(s) with the most people and find the names of employee(s) with the highest salary.
|
|
How much money should spend to purchase health insurance
: The poverty rate would be substantially lower if the market value of in-kind transfers were added to family income. The largest in-kind transfer is Medicaid, the government health program for the poor. Let's say the program costs $7,000 per recipi..
|
|
How far has each car traveled
: Two cars leave an intersection at the same time, one traveling north and the other traveling east. Some time later, they are 20 miles apart, and the car going east has traveled 4 miles further than the other car.
|
|
Will the temperature of the gas increase or decrease
: Two separate measurements are to be performed on a gas enclosed in a pistion and cylinder device. In the first measurement the device is well insulated so there is no flow of heat to or from the gas, and the piston is slowly moved inward compressing ..
|
|
State when dmpt is treated with base
: When DMPT is treated with base, and then added to a solution of [PtCl2(K^2- dppe)], compound A forms and has the formula [PtCl(DMPT)(K^2- dppe)].
|