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
