Suppose your school management has decided …

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: a) Create a database “Sports”. b) Create a table “TEAM” with following considerations: i) It should have a column TeamID for storing an integer value between 1 to 9, which refers to unique identification of a team. ii) Each TeamID should have its associated name (TeamName), which should be a string of length not less than 10 characters.

Consider a table Student having two fields-FName varchar(20) and LName char(20). If in a record, value stored in Fname is 'Anuj' and LName is 'Batra', then FName and LName will consume and character space respectively.

1. Which of the following statement is incorrect? (a) 1 Byte 8 bits (c) 1 MB 1024 KB (b) 1 KB 1024 bytes (d) \overline{GB=} 1024 KB

8. To find the third largest/smallest number in a list.

To find average and grade for given marks python

Define each of the following 1.byte 2.kilobyte 3.megabyte 4.gigabyte 5.terabyte

. Consider the temperature (in Celsius) of 7 days of a week as 34, 34, 27, 28, 27, 34, 34. Identify the appropriate statistical technique to be used to calculate the following: a) Find the average temperature. b) Find the temperature Range of that week. c) Find the standard deviation temperature.

Find the maximum value of given list List=[1,2,3,3,3]

To create student table with the student id, class, section, gender, name, dob and marks as attributes where the student id is the primary key?

This content has been hidden. One or more users have flagged this content as inappropriate. Once content is flagged, it is hidden from users and is reviewed by myCBSEguide team against our Community Guidelines. If content is found in violation, the user posting this content will be banned for 30 days from using Homework help section. Suspended users will receive error while adding question or answer. Question comments have also been disabled. Read community guidelines at https://mycbseguide.com/community-guidelines.html

Few rules to keep homework help section safe, clean and informative.

• Don't post personal information, mobile numbers and other details.
• Don't use this platform for chatting, social networking and making friends. This platform is meant only for asking subject specific and study related questions.
• Be nice and polite and avoid rude and abusive language. Avoid inappropriate language and attention, vulgar terms and anything sexually suggestive. Avoid harassment and bullying.
• Ask specific question which are clear and concise.

Remember the goal of this website is to share knowledge and learn from each other. Ask questions and help others by answering questions.

What is the security thread involved when we throw away electronic gadgets that are non functional