Computer Science, asked by priti1775, 5 months ago

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
Г
Tld
INTEGER
FOREIGN KEY
Existing tournament id present in
tournament table
Player1
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
Match Score
VARCHAR2(30) NOT NULL​

Answers

Answered by umeshnirmal04
0

Answer:

Covid 19 के वजह से इन सभी 5 में क्या बदलाव हुआ लिखिए

Similar questions