Question: Create Match table as per details below. A player cannot play against himself, so player1 should not be equal to player2. Column Name Data Type

 Create Match table as per details below. A player cannot play
against himself, so player1 should not be equal to player2. Column Name

Create Match table as per details below. A player cannot play against himself, so player1 should not be equal to player2. Column Name Data Type Constraint Mid INTEGER PRIMARY KEY Tid INTEGER FOREIGN KEY Player 1 INTEGER FOREIGN KEY Player1 should not be equal to Player2 Description Unique Match id for a tournament Existing tournament id present in tournament table Existing player Id present in player table Existing player id present in player table Match Date Existing player id present in Player table Match Score INTEGER FOREIGN KEY Player2 MatchDt DATE NOT NULL Winner INTEGER FOREIGN KEY Score VARCHAR2(30) NOT NULL It should be in SQL

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!