Create an ERD diagram Q Search Second, you will practice SQL Developer 6. login, run script 7.
Fantastic news! We've Found the answer you've been seeking!
Question:
Create an ERD diagram
Transcribed Image Text:
Q Search Second, you will practice SQL Developer 6. login, run script 7. Retrieve data using Select statement Task One: The League-Conceptual Model and Logic Design (15 points) Develop an E/ER model (conceptual model) for the following description, with appropriate entity types, relationships, cardinality, and disclaimers. A regional youth soccer league would like to use an ORACLE database to manage teams, coaches, and players data, replacing a paper-based system. For teams, we need team name, the year in which the team was established in our league, and home location. Captain is one of its players. For players, we need their lastname, firstname, date of birthday, and which school they attend. For coaches, we record their lastname, firstname, date of birthday, social security number for tax purpose, and when they started coaching. Currently, we do not include people other than players and coaches in our database, such as staff. One person cannot be both player and coach. Current paper-based system does not include any particular information to identify people. For a particular year, a coach is assigned to a team and over the years coach may switch teams. Coaches and players do not switch teams in the middle of the year. Coaches' salary and sign-up bonus (if any) may vary year to year. One of the players of a team is the captain. A player may ISM 431 Fall 2028 never be a captain. We assume each team only has and must have one coach and one captain every year. In the league, there are dozen or so teams, about 250 players, and 20 to 30 coaches. Coach salary ranges from $50,000 to 1,000,000. After conceptual model (ERD), please convert the model into a set of well-designed (3rd normal form) relations, which are the logical design of the system. Be clear about primary keys and foreign keys. L Q Search Second, you will practice SQL Developer 6. login, run script 7. Retrieve data using Select statement Task One: The League-Conceptual Model and Logic Design (15 points) Develop an E/ER model (conceptual model) for the following description, with appropriate entity types, relationships, cardinality, and disclaimers. A regional youth soccer league would like to use an ORACLE database to manage teams, coaches, and players data, replacing a paper-based system. For teams, we need team name, the year in which the team was established in our league, and home location. Captain is one of its players. For players, we need their lastname, firstname, date of birthday, and which school they attend. For coaches, we record their lastname, firstname, date of birthday, social security number for tax purpose, and when they started coaching. Currently, we do not include people other than players and coaches in our database, such as staff. One person cannot be both player and coach. Current paper-based system does not include any particular information to identify people. For a particular year, a coach is assigned to a team and over the years coach may switch teams. Coaches and players do not switch teams in the middle of the year. Coaches' salary and sign-up bonus (if any) may vary year to year. One of the players of a team is the captain. A player may ISM 431 Fall 2028 never be a captain. We assume each team only has and must have one coach and one captain every year. In the league, there are dozen or so teams, about 250 players, and 20 to 30 coaches. Coach salary ranges from $50,000 to 1,000,000. After conceptual model (ERD), please convert the model into a set of well-designed (3rd normal form) relations, which are the logical design of the system. Be clear about primary keys and foreign keys. L
Expert Answer:
Related Book For
Systems Analysis And Design
ISBN: 978-1119496489
7th Edition
Authors: Alan Dennis, Barbara Wixom, Roberta M. Roth
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...
-
Can someone please summarize the case study below: if you know about the case IKEA Looks to Further Penetrate the U.S. Market 10 CASE Synopsis: IKEA is known around the world for its stylish,...
-
Exam scores of 40 students in a statistics class are shown. (a) Estimate the mean and standard deviation from the sample. (b) Assuming that the data are from a normal distribution, de ne bins by...
-
A balanced experimental design has a sample size of n = 6 observations at each of k = 6 factor levels. The sample averages are 1 = 136.3, 2 = 152.1, 3 = 125.7, 4 = 130.2, 5 = 142.3, and 6 = 128.0,...
-
Despite its initial success, why was JetBlue unable to sustain a blue ocean strategy?
-
Determine whether each of the following is true or false. In each case, assume \(P\) is located at \(t=0\) and \(F\) is located at \(t=n\), and the \(A\) s are spread uniformly over the planning...
-
Peoria Corp. just completed another successful year, as indicated by the following income statement: Presented here are comparative balance sheets: Other information is as follows: a. Dividends of...
-
Explain how the relative prices of rugs and robots in autarky compare with the relative prices when Canada and India start to trade? In your answer explain which country will export/import which...
-
A traffic signal has a 60-second cycle length. For the travel direction of interest, the effective red and green times are 30 seconds each, the arrival rate is constant at 20 vehs/min and the...
-
The table below shows total output for an economy over 3 years. Year 2007 2008 2009 * millions of dollars ** real GDP measured in millions of 2002 dollars The growth rate of real output from 2008 to...
-
Will a VAT registered taxpayer have a VAT still due from his sales transaction with the government? Discuss and support your answer.
-
S Problem 5-23 (Algo) CVP Applications; Contribution Margin Ratio: Degree of Operating Leverage [LO5- 1, LO5-3, LO5-4, LO5-5, LO5-8] Feather Friends, Incorporated, distributes a high-quality wooden...
-
which one do you believe would best support/ or be utilized a SMD? What would be the ripple effect of an organization NOT measuring employee engagement? Explain at least 4 reasons.
-
Guiding questions: - - Identify the major challenges and implications for the HR practitioner in relation to your chosen topic. Explain the importance of constructive negotiation skills in managing...
-
Who knows how clean a water bottle is? It's pretty dark in most of them! GPS Marketers was asked to help market a new water bottle that has an ultraviolet light in the lid to kill mold, bacteria, and...
-
Research the Internet for recent litigation, censures, and fines involving national public accounting firms. Examples of litigation cases against national public accounting firms include fines by...
-
The sales department of P. Gillen Manufacturing Company has forecast sales in March to be 20,000 units. Additional information follows: Finished goods inventory, March 1 . . . . . . . . . . . . . . ....
-
Identify and briefly describe the purpose and functions of a management system, work process and organization policy.
-
Identify and describe the meaning of the term's formalization and informal.
-
Describe the link between the size of an organization and the formalization process.
Study smarter with the SolutionInn App