1. The following questions will be based on the Employee Table as below: EmpName (b) (c)...

 

Transcribed Image Text:

1. The following questions will be based on the Employee Table as below: EmpName (b) (c) Write SQL commands to: (a) Create table EMPLOYEE. (d) EmpNo 100 (e) Ali Hassan 101 Mohd Anwar Ali 102 Aminah Hassan 103 Rahayu Rahim 104 Jamaluddin Johari 105 Sarimah Ibrahim 106 Mohd Ali Hashim Date Birth 1/2/1971 1/2/1972 8/4/1973 9/6/1975 21/7/1977 11/2/1970 19/6/1970 Employee Table Salary DeptCode 1200 HRM 2500 HRM 2000 HRM 1000 ACC 3000 MKT 1800 ACC 3500 MKT Remove table EMPLOYEE from the database. (4) Insert TWO new records in EMPLOYEE table. List the employees sorted by department and in each department sort the list in descending order by salary. Create the view to see the detail of employee who works in HRM department. (4) (4) (4) (4) (Total : 20) 1. The following questions will be based on the Employee Table as below: EmpName (b) (c) Write SQL commands to: (a) Create table EMPLOYEE. (d) EmpNo 100 (e) Ali Hassan 101 Mohd Anwar Ali 102 Aminah Hassan 103 Rahayu Rahim 104 Jamaluddin Johari 105 Sarimah Ibrahim 106 Mohd Ali Hashim Date Birth 1/2/1971 1/2/1972 8/4/1973 9/6/1975 21/7/1977 11/2/1970 19/6/1970 Employee Table Salary DeptCode 1200 HRM 2500 HRM 2000 HRM 1000 ACC 3000 MKT 1800 ACC 3500 MKT Remove table EMPLOYEE from the database. (4) Insert TWO new records in EMPLOYEE table. List the employees sorted by department and in each department sort the list in descending order by salary. Create the view to see the detail of employee who works in HRM department. (4) (4) (4) (4) (Total : 20)

Answer rating: 100% (QA)

Based on the image youve shared you would like to know how to write SQL commands for certain tasks r... View the full answer