answer3.txt

来自「ssd7考试exam2,绝对有用~欢迎下载」· 文本 代码 · 共 29 行

S1	COACH(coachID, coachName, coachAge)
S1	PK(coachID)

S1	PLAYER(playerID, playerName, playerAge, teamID)
S1	PK(playerID)
S5	FK(teamID) -> TEAM(teamID)

S1	Team(teamID, teamName, coachID, colorID)
S1	PK(teamID)
S1	AK(teamName, colorID)
S4	FK(coachID) -> COACH(coachID)
S7	FK(colorID) -> TeamColor(colorID)

S1	TeamColor(colorID, colorA, colorB, colorC)
S1	PK(colorID)

S1	GAME(gameNumber, date, score, time, hostTeamID, visitorTeamID)
S1	PK(gameNumber)
S4	FK(hostTeamID) -> TEAM(teamID)
S4	FK(vistorTeamID) -> TEAM(teamID)

S1	STADIUM(stadiumID, stadiumName, stadiumSize, stadiumLocation)
S1	PK(stadiumID)
S1	AK(stadiumName)

S6	PRACTICE(teamID, stadiumID, date)
S6	PK(teamID, stadiumID)
S6	FK(teamID) -> TEAM(teamID)
S6	FK(stadiumID) -> STADIUM(stadiumID)