Reference no: EM131210527
The Globetrotters Club is organized into chapters. The president of a chapter can never serve as the president of any other chapter, and each chapter gives its president some salary. Chapters keep moving to new locations, and a new president is elected when (and only when) a chapter moves. The above data is stored in a relation G(C,S,L,P), where the attributes are chapters (C), salaries (S), locations (L), and presidents (P). Queries of the following form are frequently asked, and you must be able to answer them without computing a join: "Who was the president of chapter X when it was in location Y?"
1. List the FDs that are given to hold over G.
2. What are the candidate keys for relation G?
3. What normal form is the schema G in?
4. Design a good database schema for the club. (Remember that your design must satisfy the query requirement stated above!)
5. What normal form is your good schema in? Give an example of a query that is likely to run slower on this schema than on the relation G.
6. Is there a lossless-join, dependency-preserving decomposition of G into BCNF?
7. Is there ever a good reason to accept something less than 3NF when designing a schema for a relational database? Use this example, if necessary adding further constraints, to illustrate your answer.
|
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..
|
|
What happens to the price level over successive long runs
: Graphically demonstrate how changes in aggregate demand cause inflation or deflation (falling prices) in the short run.
|
|
Explain whether the individual is in the labor force
: In each of the given cases, explain whether the individual is in the labor force, not in the labor force, employed, or unemployed:
|
|
What are the candidate keys for relation g
: Is there ever a good reason to accept something less than 3NF when designing a schema for a relational database? Use this example, if necessary adding further constraints, to illustrate your answer.
|
|
Empress the use of information technology
: Most well established supermarkets globally have empress the use of information technology to manage their transaction of the business. Discuss reasons why they have taken such abroad move.
|
|
Aggregate demand and aggregate supply curves
: Use aggregate demand and aggregate supply curves to show what will happen to output and the price level if government spending is reduced at the same time the Fed takes action to increase the money supply.
|
|
Suppliers to seattle health system offers
: Suppose one of the suppliers to Seattle Health System offers terms of 3/20, net 60. When does the system have to pay its bills from this supplier? What is the approximate percentage cost of the costly trade credit offered by this supplier? (Ass..
|
|
Find the department with the fewest majors
: List all the department information for departments with professors in a user-specified age range.
|