# Question: Consider the relational database of Figure where the primary key

Consider the relational database of Figure where the primary keys are underlined. Give expressions in QBE for each of the following queries:

a. Find all employees who earn more than the average salary of all employees of their company.

b. Find the company that has the most employees.

c. Find the company that has the smallest payroll.

d. Find those companies whose employees earn a higher salary, on average, than the average salary at First BankCorporation.

a. Find all employees who earn more than the average salary of all employees of their company.

b. Find the company that has the most employees.

c. Find the company that has the smallest payroll.

d. Find those companies whose employees earn a higher salary, on average, than the average salary at First BankCorporation.

**View Solution:**## Answer to relevant Questions

Consider the relational database of Figure. Give expressions in QBE for each of the following queries:a. Modify the database so that Jones now lives in Newtown.b. Give all employees of First Bank Corporation a 10 percent ...Write an extended relational-algebra view equivalent to the Datalog rule p (A,C,D) :– q1 (A,B), q2 (B,C), q3 (4,B), D = B + 1 .Write an assertion for the bank database to ensure that the assets value for the Perryridge branch is equal to the sum of all the amounts lent by the Perryridge branch.Database systems that store each relation in a separate operating-system file may use the operating system’s security and authorization scheme, instead of defining a special scheme themselves. Discuss an advantage and a ...Consider the following proposed rule for functional dependencies: If α → β and γ → β, then α → γ. Prove that this rule is not sound by showing a relation r that satisfies ...Post your question