Find the average salary of employees

Assignment Help Basic Computer Science

Reference no: EM131210870

Consider the following BCNF relations, which describe departments in a company and employees:

You are told that the following queries are extremely important:

? List the names and ids of managers for each department in a user-specified location, in alphabetical order by department name.

? Find the average salary of employees who manage departments in a user-specified location. You can assume that no one manages more than one department.

1. Describe the file structures and indexes that you would choose.

2. You subsequently realize that updates to these relations are frequent. Because indexes incur a high overhead, can you think of a way to improve performance on these queries without using indexes?

Reference no: EM131210870

Questions Cloud

Scrap iron and steel to turkey and other countries : The United States exports a substantial amount of scrap iron and steel to Turkey, China, Canada, and other countries. - Why do some U.S. users of scrap iron and steel support a prohibition on these exports?

Testing whether a relation scheme is in bcnf : Give an algorithm for testing whether a relation scheme is in BCNF. The algorithm should be polynomial in the size of the set of given FDs. (The size is the sum over all FDs of the number of attributes that appear in the FD.) Is there a polynomial..

Explain what is wrong with the given statement : Explain what is wrong with the following statement: "Trade is self-eliminating. Opening up trade opportunities drives prices and costs into equality between countries.

How much oil does the united states produce domestically : With free trade and an international price of $100 per barrel, how much oil does the United States produce domestically? How much does it consume?

Find the average salary of employees : You subsequently realize that updates to these relations are frequent. Because indexes incur a high overhead, can you think of a way to improve performance on these queries without using indexes?

Discuss standard methods for developing leaders in industry : Discuss standard Methods for developing leaders in this industry. Why are they important to your chosen organization? Describe strategies for how industry leaders balance competing values and priorities and avoid failure.

What scientific information have you learned about cells : Is biology becoming more interesting to you as you learn about the workings of the cell and how cells interact in an organism? What scientific information have you learned about cells surprises or horrifies you? Why?

State the corporate goals and strategies : Describe purchasing strategy and how it relates to the organizations strategy - Describe the various structures and processes concerned with purchasing found in contemporary organisations

Find the hilbert-transform pair : The Fourier series expansion of a real periodic signal is in the form of f(t) = a0 + n=1∑∞an cos(nω0t) + n=1∑∞ bnsin(nωot). Find the Hilbert-transform pair

User Account

All Pages