No products in the cart.

Suppose your school management has decided …

CBSE, JEE, NEET, CUET

CBSE, JEE, NEET, CUET

Question Bank, Mock Tests, Exam Papers

NCERT Solutions, Sample Papers, Notes, Videos

Suppose your school management has decided to conductcricket matches between students of class XI and ClassXII. Students of each class are asked to join any oneof the four teams —Team Titan, Team Rockers, TeamMagnet and Team Hurricane. During summer vacations, variousmatches will be conducted between these teams.Help your sports teacherto do the following:a) Create a database “Sports”.b) Create a table “TEAM” with following considerations:i) It should have a column TeamID for storing aninteger value between 1 to 9, which refers tounique identification of a team.ii) Each TeamID should have its associated name(TeamName), which should be a string of lengthnot less than 10 characters.iii) Give the statement to make TeamID as 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 two rows in TEAM table:ROW 1: (1, Team Rockstars)ROW 2: (2, Team Magn et)e) Drop the table.
  • 0 answers
http://mycbseguide.com/examin8/

Related Questions

myCBSEguide App

myCBSEguide

Trusted by 1 Crore+ Students

Test Generator

Test Generator

Create papers online. It's FREE.

CUET Mock Tests

CUET Mock Tests

75,000+ questions to practice only on myCBSEguide app

Download myCBSEguide App