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
Constraint
Description
Mid
INTEGER
Unique Match Id for a tournament
PRIMARY KEY
Tid
INTEGER
FOREIGN KEY
Existing tournament Id present in tournament table
Player 1
INTEGER
FOREIGN KEY
Existing player Id present in player table
Player 1 should not be equal to Player2
Player2
INTEGER
FOREIGN KEY
Existing player Id present in player table
MatchDt
DATE
NOT NULL
Match Date
Winner
INTEGER
FOREIGN KEY
Existing player Id present in Player table
Score
VARCHAR2(30) NOT NULL
Match Score
N​

Answer 1

Answer:

पेजेजजेजेजेजेज्जेहहहयूयूएउ

Answer 2

Explanation:

CREATE TABLE Match(

MId INTEGER,

TId INTEGER REFERENCES Tournament (TId),

PRIMARY KEY(MId,TId),

Player1 INTEGER REFERENCES Player(PId),

Player2 INTEGER REFERENCES Player(PId),

MatchDt DATE NOT NULL,

Winner INTEGER REFERENCES Player(PId),

Score VARCHAR2(30) NOT NULL,

CHECK (Player1<>Player2)

);