Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 135 - 2629_Devagiri_C-8
P. 135

    PROJECT PRACTICE

                                                                                                21 st   #Critical Thinking
                                                                                               Century   #Technology Literacy
                     1.   Create a Class feedback form using Google Forms. The form            Skills
                        should include multiple-choice questions as shown:

                                                                                              21 st   #Critical Thinking
                                                                                             Century   #Technology Literacy
                     2.   Consider the following EMPLOYEE table:                             Skills

                                                             Table: EMPLOYEE
                              Emp_ID             Name           Department            Salary              Age

                                E101        Rajesh             HR                     35000                40
                                E102        Simran             Sales                  45000                38
                                E103        Aarav              IT                     60000                28

                                E104        Neha               HR                     37000                33
                                E105        Manoj              Finance                52000                45

                         Now, write SQL commands for the following:
                             Create the given table under the Organisation database.

                             Add a new employee “Pooja” in the IT department, salary 48000, age 29, Emp_ID E106.
                             List the names and departments of all employees earning more than 40,000.

                             Show the names of employees who work in the HR department.
                             Delete all employees from the IT department.

                                                                                                                      133
                                                                                                       Project Practice

| 130 131 132 133 134 135 136 137 138 139 140 |