Saved Bookmarks
| 1. |
Create Match table as per details below. A player cannot play against himself, so player1 should not be equal toplayer2ColumnNameData TypeConstraintDescriptionMidINTEGERUnique Match Id for a tournamentPRIMARYKEYГTldINTEGERFOREIGN KEYExisting tournament id present intournament tablePlayer1INTEGERFOREIGNKEYExisting player Id present in player tablePlayer 1 should not be equalto Player2Player2INTEGERFOREIGNKEYExisting player Id present in player tableMatchDtDATENOT NULLMatch DateWinnerINTEGERFOREIGN KEYExisting player Id present in Player tableScoreMatch ScoreVARCHAR2(30) NOT NULL |
| Answer» | |