hi guys could any one help me normalise this :TEAM(Team_id,TeamName)

PLAYER(Player_id,FirstName,LastName,DOB)

CONTRACT(Player_id,Team_id,StartDate,EndDate,Sqaud Number)

FIXTURE(Fixture_id,Ref_id,HomeTeam,AwayTeam,Date)

REFEREE(Ref_id,FirstName,LastName)

DISCIPLINARY CASE(DCase_id,Player_id,Fixture_id,Event)



im struggling to get my head round the hometeam and awayteam, Do i make new tables for them, or somthing else

It must be homework season again.
Do not make separate tables for home teams and away teams.

you mean in the fixtures table? they are both foreign keys

Foreign keys from which table ?

take a screaming wild guess -- which of your tables has team information in it?

So my team_id can be in hometeam colum and away team colum ?

um..... yes

These tables look, at least, in BCNF normal form.
The only thing I don't like in this design is the DCase_id in DISCIPLINARY CASE.
You can eliminate it but add DCase_time to show the time that the event happened if you want to be more realistic.

Am I right?