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: Create a database “Sports”.
CREATE DATABASE Sports;
Explanation
This is a basic DDL (Data Definition Language) command. The CREATE DATABASE statement is used to create a new database in SQL. The syntax requires the keywords CREATE DATABASE followed by the desired database name, which in this case is 'Sports' as specified in the question.
Solution Steps
Step 1: Use the CREATE DATABASE command
Step 2: Specify the database name as 'Sports'