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 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
  • 4 answers

Navya Ayyadevara 3 years, 9 months ago

d.to show the contents we have to insert values right so to insert values we should do this insert into team values(team titan); insert into team values(team rockers); Insert into team values( team magnet); Insert into team values (team hurraine); so now if we use select* from team it shows the contents that we inserted

Navya Ayyadevara 3 years, 9 months ago

c.desc team;

Navya Ayyadevara 3 years, 9 months ago

b.create table team(Team ID, primary key);

Navya Ayyadevara 3 years, 9 months ago

a. Create database sports;
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