Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Give me the schema to make the databse on this ER DIagaram Table | Primary key | Foreign keys. | Alternate key Playoffround | id
Give me the schema to make the databse on this ER DIagaram
Table | Primary key | Foreign keys. | Alternate key
Playoffround | id |
Roundstats | id. | id(Playoffround(id)). |
Hockeygame. |. id . | . teamid1 team2id(Hockeyteam(id) , roundid(Playoffround (id)). |
Gamescore. |. id. |. id(hockeygame(id)) . |
Hockeyteamplayer. |. id. | hockeyteamid(HockeyTeam(id)). |
Hockeyteam| id . | . |
User | id . |. | .email
User info. | id. | . id(User(id)). |
UserScorepicks. | id . |. userid(User(id)). |
Userstatspicks. | id. | userid(User(id)). |
Pleae ignore dots.
PlayoffRound HockeyGame GameScores team1ld team2ld startTime endTime roundNum roundld team1Score startTime team2Score team2ld RoundStats HockeyTeam hockeyTeamld goalLeaderld lastName penaltyLeaderld plusMinusLeaderld faceoffsWonLeaderld sogLeaderld User Userinfo password astName UserStatsPicks round1Points round2Points round3Points roundld goalLeaderld UserScorePicks penaltyLeaderld plusMinusLeaderld faceoffsWonLeaderld hockeyGameld team1score team2score userld numShutoutsStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started