Question: Implement the table design in SQL SERVER by creating the database as Recruitment. Perform the following SQL Query and provide the clear screen shot that

Implement the table design in SQL SERVER by creating the database as Recruitment. Perform the following SQL Query and provide the clear screen shot that show the SQL Query and the output for that query in your document with the question number. 3 Inspire Tomorrow, Today a) Create a database Recruitment and create the table Employee with the following attributes: (Employee No (Primary Key); Employee Name, Contact No, City, Contact Address, Salary, Joining Date, Department, position, gender).[8 marks] b) Write a SQL Query to insert 10 records in the above table. [5 marks] c) Write a SQL Query to retrieve all the data in the table. [2 marks] d) Adjust the salary by an increment of 4%. Write a SQL query to produce of new salaries for all the employees showing their Employee ID, Employee Names and their respective adjusted salaries. [4 marks] e) Write a SQL Query to display the highest salary, lowest salary and the average salary for employees in the table. [5 marks] f) Write a SQL query to display the Employee ID, Employee Name, City and Salary for the employee who are either living in Gaborone or earning 10000Pula. [3 marks] g) Write a SQL query to retrieve information of the employees earning (8000,6000,10000).[3 marks] h) Write a SQL query to display information of the employees who are not living in Gaborone, Mochudi. [3 marks] i) Write a SQL query to display the employee whose name start with an M.[3 marks] j) Write a SQL query to display the details of the employees with the salary greater than the average salary of all employees.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!