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.

1. Provide conceptual relational database schema. 2. SQL: Also write create table

Here is an example of a conceptual relational database schema:

statement and one insert statement for each table you create with correct

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!