Question: You have been requested to develop a database to record the registration and competition results for a regional gymnastics meet.The competition is expected to include

You have been requested to develop a database to record the registration and competition results for a regional gymnastics meet.The competition is expected to include 250 gymnasts from eighteen gymnastics clubs.Each of the gymnasts is expected to enter an average of two events.The system will be used to record entries, produce event catalog and scoring sheets, record individual scores, and produce reports to send to the national organization.

Sample of Reports Required:Clubs and Club Contacts (alphabetical order)

Gymnasts and Club (alphabetical order)

Event with competitors (events in alpha order, competitors in numerical order)

Sample data from Excel Spreadsheet currently used to maintain data:

Gymnast#GymnastNameClubNameClubContactClubPhoneEventTimeScoreJudge

101Clark, SheilaThomasville TigersMaria Garza309-584-9987Balance Beam11:009.250Owen

101Clark, SheilaThomasville TigersMaria Garza309-584-9987Uneven Bars1:008.325Mercer

101Clark, SheilaThomasville TigersMaria Garza309-584-9987Floor Exercise3:008.650Owen

103Dyer, JennaCapital CougarsNancy Taylor217-632-0207Uneven Bars1:008.550Mercer

104Shanahan, MandyParkerville PanthersChia-Jung Li618-778-9042Balance Beam11:006.875Owen

104Shanahan, MandyParkerville PanthersChia-Jung Li618-778-9042Floor Exercise3:008.900Owen

104Shanahan, MandyParkerville PanthersChia-Jung Li618-778-9042Vault9:009.100Thomas

105Nguyen, TrinhCapital CougarsNancy Taylor217-632-0207Balance Beam11:009.125Owen

105Nguyen, TrinhCapital CougarsNancy Taylor217-632-0207Vault9:009.585Thomas

106Monroe, BettyThomasville TigersMaria Garza309-584-9987Floor Exercise3:008.750Owen

Analyze the data provided and develop a set of normalized tables to use to record this data in the database system.You should use the data presented in the spreadsheet to define the relationships between entities.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

If there is a decrease of buyers in the market, will the supply curve or demand curve shift? Would it be an increase or decrease? What effect could this shift have on the rent control situation?

What are statistics that refer to life events, such as births, marriages, deaths, and divorces called? Question 6 options: Health statistics Vital statistics Human statistics Popular statistics

Describe the capacity of the MS teams to make e-learning accessible. You have to provide information on general accessibility features, and also specific opportunities for assistive technologies to...

Which of the following statements best describes the 'dilation' in rock mechanics? a. Movement of the rock along the shear direction during the direct shear tests b. Radial expansion of the intact...

Mr. A and Mr. Z are both sole proprietors. This year, each proprietorship generated $85,000 net cash flow from business operations. Mr. A used the cash to expand his business, while Mr. Z used the...

Calculate the uniform load (in addition to the beam weight) that will cause the sections to begin to crack if they are used for 20-ft simple supported span. Take f= 4000 psi, and reinforced concrete...

Are the procedures used by the test developers to establish reliability, validity, objectivity, and fairness appropriate for the intended use of the proposed data collection techniques? Was the...

1. Which forces facing Bivens supported change and which resisted change? 2. Did she use an economic or an organizational development approach to create change? Was it effective? 3. Using the...

Joe Levi bought a home in Arlington Texas for 1 4 8 , 0 0 0 . He put down 2 0 % and obtained a mortgage for 3 0 years at 6 . 1 2 5 % . What is the difference on the cost if he wouodl have obtained a...

A midwestern highway patrol just purchased a new set of radar guns for $44,800. Its operating costs are $4,200, exclusive of depreciation. The radar guns will have a five-year useful life with a...

Using the ACHE well-managed healthcare foundations for operations management, and the reading from A Comprehensive Guide to Value-Based Care for Primary Care...

Fanning moone. What would be the company's ROI in this scenario? EXERCISE 11-7 Contrasting Return on Investment (ROI) and Residual Income [L01, L02] Rains Nickless Ltd. of Australia has two divisions...

1.) Write about the importance/ advantages of computer networks? 2.) what are the disadvantages of computer networks explain briefly? 3.) Write briefly about the REFERENCE MODELS in computer...

Draw a picture consisting parts of monocot leaf

Evaluate the theory of Democratic Peace and its relevance in contemporary international relations.

You need the excel spreadsheet provided that has raw data for Raytheon Company and the Standard & Poors 500 Index. Suppose you have been hired as a financial consultant to Raytheon Company (RTN), a...

When an electric field is applied to a shallow bath of vegetable oil, why do tiny bits of thread floating in the oil align with the field like compasses in a magnetic field?

8. What is the role of reflection?

1. What is blended learning?

3. What is the importance of using a variety of stimuli?