The globetrotters club is organized into chapters

Reference no: EM13211668

NOTE: Answers should be brief, I'm not expecting long answers to make your job easier.

"DATA BASE MANAGEMENT SOLUTIONS BOOK - I really need to answer this question ASAP:
Exercise 20.4 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?

Reference no: EM13211668

Questions Cloud

Explain how organizational design-product-service-hybrid : Make A Wish Foundation-Explain how organizational design (e.g., product, service, hybrid, matrix, marketing channels, and departmentalization)

Pack-em-in has another development in the works : Pack-Em-In has another development in the works. If it builds 60 houses in this development, it will be able to sell them at $240,000 each, but if it builds 70 houses, it will get only $230,000 each. Obtain a linear demand equation.

How much energy is produced when the sun completely converts : How much energy is produced when the sun completely converts 1.0g (=0.001kg) of matter into energy? Recall: J = kg m2/s2. If you need to write in scientific notation, enter a number like 3.14 X 105 as 3.14e5. Don't forget to include the unit!

High-pressure sales techniques : Do you think that companies in general are ready to face unconscionable acts such as high-pressure sales techniques?

The globetrotters club is organized into chapters : 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

How heredity and the environment interact : Where can I find information on how heredity and the environment interact to produce individual differences in development?

Compare and contrast foreign policies of kennedy and johnson : "Compare and contrast the foreign policies of Kennedy and Johnson

Create a listening guide on any of the songs : Create a listening guide on any of the songs- Allemande, Adagio sostenuto, Purple Haze

How the concepts of abnormal psychology : How the concepts of abnormal psychology can be applied outside the therapeutic environment such as business, education, family life, and social settings?

User Account

All Pages