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?

Reviews

Write a Review

 

Software Engineering Questions & Answers

  Research report on software design

Write a Research Report on software design and answer diffrent type of questions related to design. Report contain diffrent basic questions related to software design.

  A case study in c to java conversion and extensibility

A Case Study in C to Java Conversion and Extensibility

  Create a structural model

Structural modeling is a different view of the same system that you analyzed from a functional perspective. This model shows how data is organized within the system.

  Write an report on a significant software security

Write an report on a significant software security

  Development of a small software system

Analysis, design and development of a small software system.

  Systems analysis and design requirements

Systems Analysis and Design requirements

  Create a complete limited entry decision table

Create a complete limited entry decision table

  Explain flow boundaries map

Explain flow boundaries map the dfd into a software architecture using transform mapping.

  Frame diagrams

Prepare a frame diagram for the software systems.

  Identified systems and elements of the sap system

Identify computing devices, which could be used to support Your Improved Process

  Design a wireframe prototype

Design a wireframe prototype to meet the needs of the personas and requirements.

  Explain the characteristics of visual studio 2005

Explain the characteristics of Visual Studio 2005.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd