Database Management SystemTU Board 2021
Write the DDL statement to create the following table: Table Name: Football Team Field NameData TypeConstraintsTeam IDAlphanumericPrimary KeyTeam NameCharacterNot more than 20 characterRankIntegerNo…
4Write the DDL statement to create the following table: Table Name: Football Team Field NameData - TypeConstraintsTeam IDAlphanumericPrimary KeyTeam NameCharacterNot more than 20 characterRankIntegerNo negative and NULLGoal ScoreIntegerNo negative and NULLGoalConsidedIntegerNO NEGATIVE NULLNo_of_playersIntegerNot less than 11 and more than 25
A worked answer is on its wayMeanwhile, read the Database Management System notes for this topic.
Discussion
Loading…
More Database Management System questions
Define Data abstraction.TU Board 20231Define Candidate key.TU Board 20231Write the advantages of object relational data model.TU Board 20231Write a syntax to rename a table name in SQL.TU Board 20231Write a syntax for ORDER BY clause.TU Board 20231Write down the use of GROUP BY clause.TU Board 20231