Draw a good database schema for a club

Assignment Help Software Engineering

Reference no: EM1369312

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. This 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 stated query requirement!)
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.

Reference no: EM1369312

Questions Cloud

Why can re be multiple steady states for a given : Why can re be multiple steady states for a given. What is maximum decit compatible with a steady state.

Determine the effects of the tax : Assume that gasoline retailing industry is perfectly competitive, constant expenses, and in long run equilibrium. If the government unexpectedly levies a 5-cent tax on every gallon sold by gasoline retailers,

Explain paying for incompetence : Explain Paying for Incompetence and businesspersons understand that the capitalist system

How much work is prepared on the gas : An ideal gas is enclosed in a cylinder that has a moveable piston on top. The piston has a mass of 6200 g and an area of 5 cm2 and is free to slide up and down.

Draw a good database schema for a club : What normal form is schema G in? Draw a good database schema for a club. (Remember that your design should satisfy stated query requirement!)

Explain database system design : how to support this proposed structure with descriptions of possible uses of this database system by other departments and customers of this company as well as outside vendors and suppliers?

How many bottles would be demanded in entire market : How many bottles would be demanded in entire market if price is $1.00. How many bottles would be demanded in entire market if price is $2.00.

What is the magnitude of net force causing the acceleration : What is the magnitude of net force causing the acceleration.

Henry fayola vs lillian gilbreth : Show the primary limitation of the classical approach to management. Would this approach be more significant to manager of today than managers would in the more distant past?

User Account

All Pages