Question

O 39

Suppose your school management has decided to conduct cricket matches between studentsof 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 (Using SQL)

a) Create a database "Sports".

b) Create a table TEAM" with following considerations:

It should have a column TeamlD 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 astring

of length not less than 10 characters c) Show the structure of the table TEAM using SQL command.

d) As per preferences of the students four teams were formed as given below Insert the these four rows in TEAM table:

Row 1: (1, Team Titan)

Row 2: (2, Team Rockers) Row 3: (3, Team Magnet)

Row 4: (4, Team Hurricane) e) Show the contents of the table TEAM

POINT(S):

Answer 1

Answer:

The manufacturing sector is known as the Secondary Sector. The service sector is known as the Tertiary Sector. Raw materials for goods and services are provided for the Primary Sector. The primary sector uses traditional techniques and is mostly unorganised.