Reference no: EM131246898
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.
|
Enter this design using a data-modeling tool such as erwin
: Consider the ER diagram for the small airport database shown in Figure 8.12 of the Elmasri/Navathe text. Enter this design using a data-modeling tool such as ERWin.
|
|
Observes that analysts are cutting their growth forecasts
: Guy? Ferrell, a student who lives in the country? Paragon, observes that analysts are cutting their growth forecasts for the economy for the coming year. Most of them based their analysis on the fact that the level of inflation in the economy would a..
|
|
How does it relate back to your weekly objectives
: What do you find interesting or surprising about the information in the video? How does it relate back to your weekly objectives? What is the most important thing you have learned in this course regarding the transfer of technology globally? Why?
|
|
Speed cash system
: The Speed Cash System is used to transfer money from one place to another within a day. This is basically used to speed up the money transfer. The necessary information for the money transfer from the source bank to the destination bank is sent in..
|
|
Design an entity-relationship diagram for baseball database
: Design an Entity-Relationship diagram for the baseball database and enter the design using a data-modeling tool such as ERWin.
|
|
Find the labor demand and labor supply for economy
: In this problem we will find the labor demand and labor supply for an economy, from there we will determine the equilibrium quantity of labor, and by plugging that into the production function we will find GDP. Now that you have the Labor Demand and ..
|
|
Sentences citing specific reasons
: Your paragraphs should have an opening statement followed by three sentences citing specific reasons. 1. Do you agree or disagree with changing laws to hold the company where the data theft occurred accountable?
|
|
Project definition and scoping
: Submit 1,500-word project report explaining how the various Project Management concepts could be applied to your project and within your organization or any other project of your choice; Project definition and scoping
|
|
Measure of standard of living
: In 2013, the real GDP per capita (a measure of standard of living) of China was $6,187 and in the US it was $53,042. Thus China’s real GDP per capita is approximately 12.8% of U.S. real GDP per capita. If Chinese per capita GDP grows at an average of..
|