List the names and ids of managers for each department

Assignment Help Basic Computer Science

Reference no: EM131210546

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: EM131210546

Questions Cloud

Finacial analysis in a developing economy : Define agency theory in relation to finacial analysis in a developing economy.

How the pitot static system operates : How the Pitot Static system operates on a large passenger aircraft with particular reference to information gathering and presentation to the flight deck.

Why the fed will have to reduce the supply of money : Assume that the Fed is targeting an interest rate and aggregate demand drops. - Show graphically why the Fed will have to reduce the supply of money to maintain the interest rate target.

Treasury bills and treasury notes : Treasury bills and Treasury notes are an investment security issued by the U.S. government. A Treasury bill matures within one year and investors typically roll over the matured Treasury bill and purchase another Treasury bill the same day. Treasu..

List the names and ids of managers for each department : 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?

Find the minutes of the most recent fomc meeting : Find the minutes of the most recent FOMC meeting, either at the library in the Federal Reserve Bulletin or on the Internet at www.federal reserve.gov.

Interest rates are expected to rise : a. Assuming that he earns 5% on both his current and future savings, how much should he expect to have in savings, when he retires in 20 years? b. If Mr. Poirot plans to withdraw the money in equal annual installments over the 15 years following ..

Calculate the roa and roe before investment : The company wants to increase its profits but it requires more investment of Rs. 240,000 in assets for opening new branches. The company wishes to finance its new assets in equal proportion of debt and equity. Calculate the ROA (Return on Assets),..

What is the real after tax return : The nominal interest rate is 6 percent, expected infl ation is 3 percent, and the tax rate is 20 percent. What is the real after- tax return?

User Account

All Pages