开发者

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜