1. Provide a conceptual relational database schema. There are 14 tables.

2. Using SQL, write create table statement and one insert statement for each table you create with the correct order to get them into the database.

Here is an example of a conceptual relational database schema that was created using Mircosoft Excel:

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 hockeyGameid team1score team2score userid