Football or Soccer Team Players and Fixtures scenario

The following data model is designed to hold information relating             to Teams, Players and Fixtures for a Football or Soccer Team. For             this scenario we need to define the following facts:

These facts define the requirements which the Database must meet             and should be agreed between the Database User and the Database Designer             prior to physical creation.

The draft facts have been defined as:

The Entities required should include:

  • Teams
  • Players
  • Fixtures
  • Player Positions
  • Competitions

The Entities are related as follows:

  • One Team can have Many Players
  • One Player can play in Many Fixtures
  • One Fixture has Many Players

With this design, One Team has many Players, however a Player can             only play for One Team at any one time. The relationship between Players             and Fixtures in a Many-To-Many relationship. One Player can play in             zero, one or Many Fixtures, and the Fixture involves Many Players.             The link table between this relationship also allows you to record             whether a Player scored any Goals in that particular Fixture.

When asking questions of the database we may need to know:

  1. Which Players played in a particular Fixture?
  2. What was the result of a particular Fixture?
  3. Which Players does a particular Team have signed on?

The following data model allows these questions to be answered and             allows the information contained above to be stored logically and             in a structured manner.

To view the model please go to: Relationships for             Football or Soccer Team Players and Fixtures

Please download the data model relating to Relationships             for Football or Soccer Team Players and Fixtures which is contained             in the zipped up Microsoft Word document.

About eagle081183

Passionate, Loyal
This entry was posted in Business Model, Database. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s