Reference no: EM13308055
The local city youth league needs a database system to help track children that sign up to play soccer. Data needs to be kept on each team and the children that will be playing on each team and their parents. Also, data needs to be kept on the coaches for each team. Draw an ERD to model this situation.
Entities required: Team, Player, Coach, and Parent.
Attributes required:
Team: Team ID number, Team name, and Team colors.
Player: Player ID number, Player first name, Player last name, and Player age.
Coach: Coach ID number, Coach first name, Coach last name, and Coach home phone number.
Parent: Parent ID number, Parent last name, Parent first name, Home phone number, and Home Address (Street, City, State, and ZIP Code).
The following relationships must be defined:
- Team is related to Player.
- Team is related to Coach.
- Player is related to Parent.
Cardinalities and participations are defined as follows:
- A Team may or may not have a Player.
- A Player must have a Team.
- A Team may have many Players.
- A Player has only one Team.
- A Team may or may not have a Coach.
- A Coach must have a Team.
- A Team may have many Coaches.
- A Coach has only one Team.
- A Player must have a Parent.
- A Parent must have a Player.
- A Player may have many Parents.
- A Parent may have many Players.
Write the business rules for this.
Implement your database using Oracle.
|
International regimes of uniform terms is the most effective
: Evaluate which of the following international regimes of uniform terms is the most effective under English law in the imposition of a minimum liability regime for loss of or damage to goods carried across international border:
|
|
Write a memo to the file of peachtree addressing the issues
: You will be meeting with Chris, Paula and Toby about these issues. Write a memo to the file of Peachtree addressing the issues raised in Part I and II including your analysis.
|
|
What are the problems associated with bridge widening method
: In bridge widening projects, the method of stitching is normally employed for connecting existing deck to the new deck. What are the problems associated with this method in terms of shrinkage of concrete
|
|
What must be the height of the hill
: A skier starts from rest at the top of a hill. The skier coasts down the hill and up a second hill. The crest of the second hill is circular, What must be the height of the hill
|
|
Draw an erd to model this situation
: The local city youth league needs a database system to help track children that sign up to play soccer. Data needs to be kept on each team and the children that will be playing on each team and their parents.
|
|
Business of importing and supplying jewellery as wholesaler
: Andrew, Brian, Colin, Diana and Elizabeth were the directors of Gemsales Pty Ltd, a company engaged in the business of importing and supplying jewellery as wholesalers to the local market.
|
|
How far behind is the first car
: Two cars are initially at rest at the starting line of a 100-m long track. the first car accelerates at a rate of 2.50 m/s^2. how far behind is the first car
|
|
State a c program that opens the file
: Write a C program that opens the file and firstly stores all the values in an appropriately declared two-dimensional array of integers. It then should analyse this array to find (from the 40 input values) the total number of coursework marks in the..
|
|
Determine the maximum stress and strain in the ball
: A rubber ball is inflated to a pressure of 65 kPa .At that pressure the diameter of the ball is 240mm and the wall thickness is 1.25 mm.The rubber has a modulus of elasticity E of 3.6 Mpa and a poisoon'd ratio of 0.48.
|