Saved Bookmarks
| 1. |
СCreate Match table as per details below. A player cannot play against himself, so player1 should not be equal toplayer2.ColumnNameData TypeConstraintDescriptionMidINTEGERUnique Match Id for a tournamentPRIMARYKEYTidINTEGERFOREIGN KEYExisting tournament ld present intournament tablePlayer 1INTEGERFOREIGNKEYExisting player Id present in player tablePlayer1 should not be equalto Player2Player2INTEGERFOREIGNKEYExisting player Id present in player tableMatchDtDATENOT NULLMatch DateWinnerINTEGERFOREIGN KEYExisting player Id present in Player tableScoreVARCHAR2(30) NOT NULLMatch ScoreAl |
|
Answer» cute |
|