Football DB Help

Can anyone let me know h开发者_Python百科ow to normalise this, I'm stuck on the home/away team bit. Cheers

TEAM(Team_id,TeamName)

PLAYER(Player_id,FirstName,LastName,DOB)

CONTRACT(Player_id,Team_id,StartDate,EndDate,SqaudNumber)

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

REFEREE(Ref_id,FirstName,LastName)

DISCIPLINARY CASE(DCase_id,Player_id,Fixture_id,Event)

---

It looks fine to me as long as HomeTeam and AwayTeam refer to TEAM.Team_id

Unless I'm misunderstanding the question