Create a table “TEAM” with following considerations:
It should have a column TeamID for storing an integer value between 1 to 9, which refers to unique identification of a team.
Each TeamID should have its associated name (TeamName), which should be a string of length not less than 10 characters.
Explanation
The SQL query creates the table TEAM as requested. TeamID is defined as an INT because it stores an integer value. A CHECK constraint is applied to ensure the value is between 1 and 9. TeamName is defined as VARCHAR(20) to store string data; the size 20 ensures it can accommodate strings of length 10 or more. The PRIMARY KEY constraint is not included here because the context indicates that part (c) of the question specifically asks to add it later using a table-level constraint.