3.txt

来自「CMU.SSD7的EXAM2答案 考试答案.绝对正确!100分」· 文本 代码 · 共 63 行

S1:
T1: Coach(Name,Age)
    PK:(Name)
T2: Team(Name)
    PK:(Name)
T3: Player(Name,Age)
    PK:(Name)
T4: Game(Number,Score,Time,Date)
    PK:(Number)
T5: Stadium(Name,Size,Location)
    PK:(Name)

S4:
T2: Team(Name,CoachName)
    PK:(Name)
    FK:CoachName references Coach(Name)

S5:
T3: Player(Name,Age,TeamName)
    PK:(Name)
    FK:TeamName references Teach(Name)

S6:
T6: Practice(TeamName,StadiumName,Date)
    PK:(TeamName,StadiumName)
    FK:TeamName references Teach(Name)
    FK:StadiumName references Stadium(StadiumName)
T7: PlaysWith(HostName,VisitorName,GameNumber)
    PK:(GameNumber)
    FK:HostName references Team(name)
    FK:VisitorName references Team(name)

S7:
t8: TeamColor(TeamName,color)
    PK:(TeamName,color)
    FK:TeamName references Team(name)

The last seven tables:
T1: Coach(Name,Age)
    PK:(Name)
T2: Team(Name,CoachName)
    PK:(Name)
    FK:CoachName references Coach(Name)
T3: Player(Name,Age,TeamName)
    PK:(Name)
    FK:TeamName references Teach(Name)
T4: Game(Number,Score,Time,Date)
    PK:(Number)
T5: Stadium(Name,Size,Location)
    PK:(Name)
T6: Practice(TeamName,StadiumName,Date)
    PK:(TeamName,StadiumName)
    FK:TeamName references Teach(Name)
    FK:StadiumName references Stadium(StadiumName)
T7: PlaysWith(HostName,VisitorName,GameNumber)
    PK:(GameNumber)
    FK:HostName references Team(name)
    FK:VisitorName references Team(name)
t8: TeamColor(TeamName,color)
    PK:(TeamName,color)
    FK:TeamName references Team(name)

(T4 and T7 have the same primary key, so, they can be joined to a new table.)