Reference no: EM131252365
Consider a database system for a baseball organization such as the major leagues. The data requirements are summarized as follows:
• The personnel involved in the league include players, coaches, managers, and umpires. Each is identified by a unique personnel id. They are also described by their first and last names along with the date and place of birth.
• Players are further described by other attributes such as their batting orientation (left, right, or switch) and have a lifetime batting average (BA).
• Within the players group is a subset of players called pitchers. Pitchers have a lifetime ERA (earned run average) associated with them.
• Teams are uniquely identified by their names. Teams are also described by the city in which they are located and the division and league in which they play (such as Central division of the American league). • Teams have one manager, a number of coaches, and a number of players.
• Games are played between two teams with one designated as the home team and the other the visiting team on a particular date. The score (runs, hits, and errors) are recorded for each team. The team with more number of runs is declared the winner of the game.
• With each finished game, a winning pitcher and a losing pitcher are recorded. In case there is a save awarded, the save pitcher is also recorded.
• With each finished game, the number of hits (singles, doubles, triples, and home runs) obtained by each player is also recorded.
Design an Entity-Relationship diagram for the baseball database and enter the design using a data-modeling tool such as ERWin.
Design an entity relationship diagram
: Design an Entity-Relationship diagram for the auction database and enter the design using a data-modeling tool such as ERWin.
|
Calculate the firm marginal revenue and marginal cost
: Calculate the firm's marginal revenue and marginal cost at every level of output. Is this firm operating in perfect competition? How do you know? Find the firm's maximum profit output and maximum profit price
|
Develop a thesis pertaining to the assigned film text
: Writing an outline for a five paragraph analytical essay building on a clear and concise thesis statement, including topic sentences and secondary supports. Identifying and explaining three scenes from the film text in support of the thesis statem..
|
What are two main goals of federal aviation administration
: What are two main goals of Federal Aviation Administration? Describe them. Who is current FAA Administrator? Tell me about him. According to the text, list and describe the six safety certificates issued by the FAA.
|
Design an entity relationship diagram
: Design an Entity-Relationship diagram for the baseball database and enter the design using a data-modeling tool such as ERWin.
|
What kinds of south korean leadership behaviors would expect
: What kinds of South Korean leadership behaviors would you expect to include in your report? Describe these in terms of interaction between the U.S. and Korean managers as well as interaction between Korean leader-followers.
|
How can a corporation''s life cycle be extended
: It is important to assess the strategy culture compatibility when implementing a new strategy. Do you think that culture follows strategy, or does strategy follow culture? your response, use the company to illustrate your points. Justify your answ..
|
Analyze at least three potential management conflicts
: Analyze at least three potential management conflicts that may arise due to the identified differences and propose solutions for each to help combat these conflicts. Use at least one chart or graph in your PowerPoint presentation.
|
What is the research on how overweight people are treated
: Compare various definitions of overweight and obese: compare US government definitions vs. the social construction of obese. What clothing size is a Plus size for men and women? How are overweight people portrayed in the media; what characteristic..
|