Hi,

I am in the process of creating a sporting schedule schema.
Here is what I have so far -

schedule (schedId(pk), hometeamid(fk), awayteamid(fk), date, start, end, location, ....)
teams (teamid(pk), teamname, leagueid(fk), ....)
league (leagueid(pk), sportid(fk), ....)
sports (sportsid(pk), name, ....)

Any thoughts on this design?

Thanks in advance.

what does the assignment call for?

can you explain your design choices (to yourself), and justify why you came to this design?

ultimately its your design, and if it matches the design brief you have then its plenty good enough. without knowing the purpose / business requirement then its very hard t knwo if this design is good enough or not.

ferisntance
most sports have a season, or annual copmpetition
some have additional events during that season. eg football in Europe has national leagues and national cup competitons (England has 4 professional leagues, god knows how many amateur / semi professional leagues. all teams can elect to play in a league structure, all teams can enter the FA cup, all professional league teams can also enter the league cup. teams in the top tier of the professional league also play in pan european competitions.
hence thats why, without knowing what this model is meant to represent I doubt anybody could give you a yea or nay