Basic HTML Version

|  | Table of Contents |  | View Full Version

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

    The JavaScript should display a message using the alert() function if the user submits
                           the form  without  filling  and  a  personalised confirmation  message once  the data  is
                           successfully submitted.

                                                                                                    21 st
                       3.   Consider the following EMPLOYEE table:                               Century   #Critical Thinking
                                                                                                   Skills  #Technology Literacy
                                                               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:
                            a.  Create the given table under the Organisation database.

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

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

                                                                                                         Project Work  141

| 138 139 140 141 142 143 144 145 146 |