Well Tech Institute offers two post …

Well Tech Institute offers two post graduate courses, one in computers and one in management. The students can avail certain optional facilities. The basic interface for accepting the details of facilities availed by a student is as follows: Q 1. Write the code and the event procedures for incorporating the following functionality: (a) The library facility should be selected by default. And the default course choice should be computers course. [2] (b) When user clicks clear button all the text fields should be cleared. [2] (c) Whenever user selects the HOSTEL facility, the MESS facility should get selected automatically, which the user can deselect later if desired. [2] (d) Given that the charges for library , mess and hostel are RS 500, RS 1500 and Rs 2000 respectively per month , write java codes for calculate button that calculates and displays the charges per semester, for the facilities. [4] Q 2. Consider the table STUDENT given below and answer the questions RollNo Name Class DOB Gender City Marks 1 Nanda X 6/6/95 M Agra 551 2 Saurabh XII 7/5/93 M Mumbai 462 3 Sanal XI 6/5/94 F Delhi 400 4 Trisla XII 8/8/95 F Mumbai 450 5 Store XII 8/10/95 M Delhi 369 6 Marisla XI 12/12/94 F Dubai 250 7 Neha X 8/12/95 F Moscow 377 8 Nishant X 12/6/95 M Moscow 489 (i) Create above table with suitable data types using SQL commands. [2] (ii) Insert above rows using SQL commands. [1] (iii) List the name of male student of class X. [1] (iv) List names all class of all students in descending order of DOB. [1]

Consider the SchoolBus table given below: Rtno. Area_covered. Capacity. No of students. Distance. Transporter. Charges 1. Vasantkunj 100 120 10 Shivamtravels 100000 2. HauzKhas 80 80 10 Anand travels 85000 3. Pitampura 60 55 30 Anand travels 60000 4. Rohini 100 90 35 Anand travels 100000 5. Yamuna Vihar 50 60 20 Bhalla Co. 58000 6. Krishna Nagar 70 80 30 Yadav Co. 80000 7. Vasundhara 100 110 20 Yadav Co. 100000 8. PaschimVihar 40 40 20 Speed travels 55000 (i) State the command that will give the output as : Area_covered Yamuna Vihar Krishna Nagar Vasundhara (ii) State the command to display the records of SchoolBus where distance is 20 according to their charges. (iii) State the command to display the total capacity Transporter wise. (iv) State the command to increase the charges by 20% where distance is more than 20. (v) State the command to display those records whose capacity is greater than 60 and charges between 80000 to 100000. (vi) State the command to delete the records of Rtno 6,7 and 8. (vii)State the command to display those records where charges greater than the average charges.

List down the average of phone number what is the coding I couldn't remember

Founder of python

what are aggregate function inSQL? Name any two

Display the details of all the employees whose value is null

All data types of MySQL with example

Consider a given series,M1 write a program in python pandas to create the series

Write a program that generates the table of a input number using for loop

Select round(6.5675,2);

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.