Ms. Manisha, a veterinarian, created a table 'VETERINARY' with the following columns:

ANIMAL_ID, VACCINATION_DATE, ANIMAL, OWNER_NAME

She wants to see the details of all the animals other than Dog and Cat which she has vaccinated.
She has written the following query:

SELECT * FROM VETERINARY WHERE ANIMAL NOT IN ('DOG', 'CAT');

Write a suitable alternate query for producing the same result.

Your school management has decided to organize cricket matches between students of Classes XI and XII. All the students are divided into four teams—Team Rockstars, Team BigGamers, Team Magnet and Team Current. During the summer vacations, various matches are to be held between these teams. Help your sports teacher do the following:

(a) Create a database "Sports" and open it for creating table.

(b) Create a table "Team" with the following considerations:

1. It should have a column TeamID for storing an integer value between 1 and 9, which refers to unique identification of a team.
2. Each TeamID should have its associated name (TeamName), which should be a string of length not less than 10 characters.
3. Give the statement to make TeamID the primary key.

(c) Show the structure of the table Team using SQL command.

(d) As per the preferences of the students, four teams were formed as given below.

Insert these four rows in Team table:

Row 1: (1, Team Rockstars)
Row 2: (2, Team BigGamers)
Row 3: (3, Team Magnet)
Row 4: (4, Team Current)

(e) Display the table Team.

What do you mean by information?

What is the difference between data and information?