CODEWITHSUNDEEP
database-designnormalization
Simon
Simon

Reputation: 1

Football DB Help

Can anyone let me know how 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)

Upvotes: 0

Views: 371

Answers (1)

Derek
Derek

Reputation: 23228

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

Unless I'm misunderstanding the question

Upvotes: 2

Related Questions