Find the location where a user-specified employee works

Assignment Help Basic Computer Science

Reference no: EM131210583

Consider the following BCNF relations, which describe employees and departments that they work in:

You are told that the following queries are extremely important:

? Find the location where a user-specified employee works.

? Check whether the budget of a department is greater than the salary of each employee in that department.

1. Describe the physical design that you would choose for this relation. That is, what kind of a file structure would you choose for these relations, and what indexes would you create?

2. Suppose that your customers subsequently complain that performance is still not satisfactory (given the indexes and file organization that you chose for the relations in response to the previous question). Since you cannot afford to buy new hardware or software, you have to consider a schema redesign. Explain how you would try to obtain better performance by describing the schema for the relation(s) that you would use and your choice of file organizations and indexes on these relations.

3. Suppose that your database system has very inefficient implementations of index structures. What kind of a design would you try in this case?

Reference no: EM131210583

Questions Cloud

C++ function that receives an integer passed to it : Name the function divide By Two. Name the formal parameter whole Number. (The answers to TRY THIS Exercises are located at the end of the chapter.)

Concentrate in the hispanic classes : Janet a 20 year old Mexican has found it hard to concentrate in the Hispanic classes since she cant speak Spanish. She has come to you to seek advice. How would you advice her, ensure that you provide a rationale for your answer. Cite the referen..

What is its debt-to-capital ratio : Its stock price is $12 per share and it has 5.3 million shares outstanding. The firm's total capital is $135 million and it finances with only debt and common equity. What is its debt-to-capital ratio? Round your answer to two decimal places.

How does cellini criticize bandinellis sculpture hercules : How does Cellini criticize Bandinelli's sculpture Hercules and Cacus (1534)? What technical difficulties does Cellini encounter in making his Perseus with the head of Medusa (1545), and how do these difficulties relate to the medium in which it wa..

Find the location where a user-specified employee works : Suppose that your database system has very inefficient implementations of index structures. What kind of a design would you try in this case?

How much will each annual payment be : A company borrow $452,788 from bank at 13.55% per year compounded annually. The loan is to be repaid in equal annual installments at the end of each year over 10 years. How much will each annual payment be?

What are the firm roic : Baker Industries' net income is $25,000, its interest expense is $6,000, and its tax rate is 45%. Its notes payable equals $25,000, long-term debt equals $75,000, and common equity equals $260,000. The firm finances with only debt and common equit..

Identify the stakeholders affected by the gap or gaps : Recognize the business owner or business executive's point-of-view for taking certain unethical or ethical actions from case studies and current events. Identify ethical quandaries regarding government involvement and laws impacting organizations..

What will be the firm operating cycle : What will be the firm's operating cycle? (Use 365 days a year. Do not round intermediate calculations and round your final answer to 2 decimal places.)

User Account

All Pages