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 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
Get step-by-step solutions from verified subject matter experts
