Normalising Help (1 Viewer)

[Beege]

Can someone please assist me with normalising these fields:

* Firstname
* Surname
* Address
* Age
* Gender
* Team Last Year
* Coach
* Training Time
* Position Played This Year

help would be much appreciated

 

[Lwaxana]

normalising is getting rid of redundant data / fields

so you wouldnt have date of birth field AND an age field

Coach and training time could sit in a separate table

 

[Beege]

K i've normalised my database:

1st Table:

*Firstname
*Surname
*Address
*Age
*Gender
*Team Last Year
*Position Played This Year

2nd Table:

*Coach
*Training Time


Would this be enough? and which fields from the first table could relate with the fields from the 2nd table?

 

[Lwaxana]

am suggesting Table one has a Player_ID (primary key)
and Coach ID

Table two has Coach Id ( primary Key)

 

[Beege]

sweet thx but what about the foreign keys?

 

[Lwaxana]

By definition
Foreign key: An attribute (field) of a table in a relational database that is a primary key in another table.

Am sure you can figure that out