Use Database Design Language (DBDL) to create the normalized tables and fields necessary to complete the Soccer
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
One of your friends has volunteered to run a soccer League this fall. He/she asked you if you had any suggestions on how they could keep track of the Players, Referees, Scores, and Sponsors of each Match. You told them that it just so happens that you are taking a Database Design class this semester and you would LOVE to help out and design a database for the league. The League wants to keep track of the following information: Location of the Match Date Played Referee Name Referee Phone Referee Address Team Name Sponsor Name - one sponsor per team Total Score of the Match for each team Players Name Players Points Scored in each Match Player Penalties each Match Design the tables needed for this database. Every table should be in 3NF. Using DBDL, create the normalized tables (3NF) and relationships between the tables that are needed for this project. Note: A player can play for more than one team (substitute) but only one team during a given match. One of your friends has volunteered to run a soccer League this fall. He/she asked you if you had any suggestions on how they could keep track of the Players, Referees, Scores, and Sponsors of each Match. You told them that it just so happens that you are taking a Database Design class this semester and you would LOVE to help out and design a database for the league. The League wants to keep track of the following information: Location of the Match Date Played Referee Name Referee Phone Referee Address Team Name Sponsor Name - one sponsor per team Total Score of the Match for each team Players Name Players Points Scored in each Match Player Penalties each Match Design the tables needed for this database. Every table should be in 3NF. Using DBDL, create the normalized tables (3NF) and relationships between the tables that are needed for this project. Note: A player can play for more than one team (substitute) but only one team during a given match.
Expert Answer:
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date:
Students also viewed these databases questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
The Crazy Eddie fraud may appear smaller and gentler than the massive billion-dollar frauds exposed in recent times, such as Bernie Madoffs Ponzi scheme, frauds in the subprime mortgage market, the...
-
1. Consider the following problem: Suppose that the interest rate in this year is 5% and all investors expect that interest rates for the next 3 years will be as follows: Year 1 2 3 Forward Interest...
-
Policies are decision making shortcuts that always empower the employees who have to carry them out true or false
-
Klamath Company produces a single product. The projected income statement for the coming year is as follows: Sales (54,600 units @ $34) ........$1,856,400 Total variable cost...
-
In 2009, the administration of President Obama instituted a so-called Cash for Clunkers program. You are to evaluate the effectiveness of the program, which was intended to stimulate the economy and...
-
Star Gas wants to move its sales order system to the Internet. Under the proposed sys-tem, gas stations and other merchants will use a secure site to check the availability and current price of...
-
Waneka Corp., a U.S. company, is concerned that fluctuations in a foreign currency could severely affect the profitability of a major sale to a foreign customer. Which type of exchange rate would be...
-
The senior bookkeeper would like to be able to send out feedback forms to clients so the organisation can get an understanding of where they can perform better. Draft the content of feedback form or...
-
A craft coffee shop located in the lobby of a downtown skyscraper sells a cup of coffee for $ 6 . 0 0 . Employees who work in a building three blocks away have an easy access to a food truck that...
-
Let's revisit our first problem, where we want to set up a series of chess matches so we can rank six players in our class. As we did before, we will assume that everyone keeps their chess rating a...
-
I. CONVERTING ASSETS TO EXPENSES 1. On 10/1/20 ABC Corp. purchases, on account, $12,000 of shop supplies to be used during the period 10/1/20 - 9/30/21. ABC Corp. adjusts its books annually. a....
-
How to tackle data security, give suitable approaches to strengthen the data security?
-
is the import statement required for the programmer defined function Babbage.?
-
TWO CUSTOMERS En. Soleh felt that something was wrong in the whole approach to costing and pricing in this industry. Using the comments he had read in Drucker's book, he began reviewing the manner in...
-
The Zwatch Company manufactures trendy, high-quality moderately priced watches. As Zwatch's senior financial analyst, you are asked to recommend a method of inventory costing. The CFO will use your...
-
Answer each of the following questions using the Colonial Adventure Tours data shown in Figures 1-15 through 1-19. No computer work is required. 1. List the last name of each guide that does not live...
-
What does it mean when a data warehouse is nonvolatile?
-
List the changes you would need to make in your answer to Question 7 if they could have more than one advisor.
-
Define torsional section modulus.
-
An inverted \(T\)-beam of \(4 \mathrm{~m}\) span is simply supported at the ends. Its cross-section is 300 \(\mathrm{mm} \times 250 \mathrm{~mm} \times 10 \mathrm{~mm}\). If permissible stresses in...
-
A rolled steel joist \(400 \mathrm{~mm} \times 200 \mathrm{~mm} \times 20 \mathrm{~mm}\) is freely supported on a span of \(4 \mathrm{~m}\). The flanges are strengthened by two \(250 \mathrm{~mm}...
Study smarter with the SolutionInn App