Reference no: EM131210534
Consider the following BCNF relation, which lists the ids, types (e.g., nuts or bolts), and costs of various parts, along with the number that are available or in stock:
You are told that the following two queries are extremely important:
? Find the total number available by part type, for all types. (That is, the sum of the num avail value of all nuts, the sum of the num avail value of all bolts, etc.)
? List the pids of parts with the highest cost.
1. Describe the physical design that you would choose for this relation. That is, what kind of a file structure would you choose for the set of Parts records, 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 Parts relation 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. How would your answers to the above two questions change, if at all, if your system did not support indexes with multiple-attribute search keys?
|
Managers manipulate reported earnings
: Discuss some of the reasons managers manipulate reported earnings. Explain why earnings smoothing, one form of earnings manipulation, could be justified and why ethical analysts might avoid stocks from corporations that are known to smooth earning..
|
|
What is the real after tax return
: The nominal interest rate is 3 percent, but people expect prices to fall by 4 percent. What is the real interest rate?
|
|
Scenarios for stock prices
: What will be the profit to an investor who buys the call for $4 in the following scenarios for stock prices in 6 months? What will be the profit in each scenario to an investor who buys the put for $6?
|
|
What is difference between microeconomics vs macroeconomics
: What is the difference between Microeconomics vs. Macroeconomics? Contrast "monetary policy" from "fiscal policy". Recreate and explain the circular flow model (you may use the whiteboard)
|
|
List the pids of parts with the highest cost
: How would your answers to the above two questions change, if at all, if your system did not support indexes with multiple-attribute search keys?
|
|
Good short-term financial strength
: A company has $100,00 in cash, $300,000 in accounts receivable, $50,000 in inventory and a $300,000 office building. Its current liabilities are $250,000. What is the company's current ratio, and does that ratio good short-term financial strength?
|
|
What is the sustainable growth rate of output over time
: Draw the long- run aggregate supply curves for successive long- run equilibriums with a potential growth rate of real GDP at 2.5 to 3.0 percent per year.
|
|
Write a client-server program
: Write a client-server program. The server has the following properties: It wait for requests at port 12345. It will create a thread to serve one incoming request
|
|
Shares of common stock outstanding
: Last year Biff industries had an operating profit of $4,800,000, paid $290,000 in interest expense. The applicable income tax rate for the year was 33%. The company had 415,000 shares of common stock outstanding at the end of last year. What wa..
|