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

  Display the total and average number of calories burned

How would you solve the following in C++? Please write code below: Write a condition-controlled while loop that allows the user to enter the calories they burned.

  Floating point format has an n-bit frac field

Suppose a floating point format has an n-bit frac field and a k bit exp field. What is the smallest integer that can be represented exactly? Assume that k is large enough not to provide any limitations on the problem. What is the integer for IEEE-754..

  Explaining topic important for network administrators

Why is the topic important for network administrators today?

  Random string of 100,000 characters is written

A random string of 100,000 characters is written down, where each character is independently, equally likely to be any of the upper-case letters A through Z in English.

  Using the expand, guess, and verify method find closed

Using the expand, guess, and verify method find closed form solutions for the following recurrence relations.

  Write a program with three radio buttons

Write a program with three radio buttons and circle. ( You can choose whether you draw the circle or if the circle is a label image.) When the user clicks on the first radio button

  Ieee 754 32-bit floating points numbers to decimal values

Convert the following IEEE 754 32-bit floating points numbers to decimal values

  What needs to be done to avoid such problem

Based on our class discussion regarding E-R Diagrams, if an attribute is appearing in a number of entity sets does this situation lead to the issue of data redundancy? If yes, what needs to be done to avoid such problem?

  Probability of exactly k collisions and then success

Large population of ALOHA users manage to create 50 requests/sec., including both originals and retransmissions. Time is slotted in units of 40 msec. Compute the probability of exactly K collisions and then a success?

  Explaining gui differences and security differences

With that being said, its great that each of you pointed out the GUI differences. What about the Security differences?

  Find parity of binary number stored in accumulator

Use an algorithm similar to one in Question 1 to find the parity (odd/even) of a binary number stored in the accumulator.

  What is the standard iana-registered higher-level

How could you determine whether or not a TCP service is running at port 13 of a given Internet host? Test this for the host(s) assigned by your instructor. What is the standard IANA-registered higher-level protocol associated with this port?

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