Question

Suppose your school management has decided to conduct cricket matches between

students of class XI and Class XII. Students of each class are asked to join any one

of the four teams — Team Titan, Team Rockers, Team Magnet and Team Hurricane.

During summer vacations, various matches will be conducted between these teams.

Help your sports teacher to do the following: [4]

a. Create a database “Sports”.

b. Using table level constraint, make Team ID as primary key.

c. Show the structure of the table TEAM using SQL command.

d. Show the contents of the table TEAM.​

Answer 1

Answer:

a. Create a database “Sports”.