Question: 1. Provide conceptual relational database schema. 2. SQL: Also write create table statement and one insert statement for each table you create with correct order
1. Provide conceptual relational database schema.
2. SQL: Also write create table statement and one insert statement for each table you create with correct order to get them into the database.

Here is an example of a conceptual relational database schema:

PlayoffRound HockeyGame id teamlid team2id startTime endTime roundNum id roundid start Time description teamlid team2id GameScores id team1Score team2Score HockeyTeamPlayer id hockeyTeamid firstName lastName jerseyNunm RoundStats HockeyTeam id numShutouts goalLeaderid assistLeaqderid penaltyLeaderid plusMinusLeaderid faceoffsWonLeaderid sogLeaderid id name logo User Userinfo id username passworod id firstName lastName email round1Points round2Points round3Points round4Points UserStatsPicks id roundid goalLeaderid assistLeaderid penaltyLeaderid plusMinusLeaderid faceoffsWonLeaderid sogLeaderid numShutouts userid UserScorePicks id hockeyGameid team1score team2score userid
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
