Draw an erd to model this situation

Assignment Help Basic Computer Science
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.

 

Reference no: EM13308055

Questions Cloud

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.

Reviews

Write a Review

 

Basic Computer Science Questions & Answers

  Significant factors contributing to mmcc-s success

Write down most significant factors contributing to MMCC's success with its new, secure, self-managed network? Describe the reasons for your choices.

  How verbal and nonverbal communication affect communication

Write 1,750- to 2,100-word paper explaining how verbal and nonverbal communication can affect communication in given areas: Police situations (public announcement to the press).

  Heptadeca class that encapsulates a heptadeca number

Write a Heptadeca class that encapsulates a Heptadeca number value. A Heptadeca number is one with 17 digits: 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, A, B, C, D, E, F, G. The methods the class has are: public void read(), public void set(String), public voi..

  Explain what is done in each of the risc states

Explain what is done in each of the RISC states for the 5 types of MIPS instructions represented with R, I, and J instruction formats.

  What exactly active directory folders purposes

Active Directory folders (not shared folders) are unique objects in Active Directory.

  Write the definition of a class player containing

Write the definition of a class Player containing: An instance variable name of type String , initialized to the empty String. An instance variable score of type int , initialized to zero.

  How does the use of the internet, intranets, and extranets

How does the use of the Internet, intranets, and extranets by companies today support their business processes and activities

  Describe a situation where dynamic memory allocation

Describe a situation where dynamic memory allocation might be required in order to make efficient use of your computer's resources. Also describe the precautions that your program should take for the correct and efficient implementation of dynamic..

  Marie program that will input a variable

To develop a MARIE program that will input a variable number of user entered Decimal whole number grades, validating each one (0-100) in a subroutine

  Runnig test cases on same piece of code

Why four people must waste their time looking for faults when one person can run test cases on same piece of code. How do you respond?

  Store the quotient in a word-size variable called result

Show how to perform 77 / 3 in the HCS12. Store the quotient in a WORD-size variable called result, and the remainder in a WORD-size variable called remainder.

  Expalining protocols essential in data communications

What is meant by protocol? Why are protocols essential in data communications?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd