Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 76 - 2611_SmartGPT Pro V(5.0) C-8
P. 76

    21 st   #Critical Thinking
                       LAB ACTIVITY                                                           Century   #Technology Literacy
                                                                                                Skills

                          Consider the following PLAYERS table:
                                                                Table: PLAYERS

                                  Player_ID       Name             Sport            Country            Age

                                    S001       Virat          Cricket         India                     35
                                   S002        Ronaldo        Football        Portugal                  39

                                   S003        Sindhu         Badminton       India                     28
                                   S004        Messi          Football        Argentina                 37
                                   S005        Mary           Boxing          India                     41

                           Now, write SQL commands for the following:
                           (a)  Create a PLAYERS table under the Sports database.
                           (b)  Display details of all the Indian players.
                           (c)  Show the names of all the football players.

                           (d)  Change the country of player “Ronaldo” to “Brazil”.
                          Consider the following PATIENTS table:

                                                               Table: PATIENTS

                                  Player_ID         Name            Sport            Country             Age

                                    P001        Rahul                 20        Fever               Dr. Sinha
                                    P002        Maya                  34        Diabetes            Dr. Ahmed
                                    P003        Aman                  27        Flu                 Dr. Sinha
                                    P004        Riya                  15        Asthma              Dr. Gupta
                                    P005        John                  40        Diabetes            Dr. Ahmed

                           Now, write SQL commands for the following:
                           (a)  Create a PATIENTS table under the Hospital database.
                           (b)  Insert a new patient “Priya”, age 25, Flu, doctor Dr. Sinha, Patient_ID P006.

                           (c)  Show names of all patients suffering from Diabetes.
                           (d)  List all details of patients being treated by Dr. Sinha.
                           (e)  Update the age of patient “Rahul” to 21.

                       74   Computer Science (V5.0)-VIII

| 71 72 73 74 75 76 77 78 79 80 81 |