Work with Data Manipulation Language (DML) using MySQL. You will 

create the database, multiple tables, insert data and retrieve information based on the 

questions given below.

 

1. Show all the records of employees who are managers and salesmen. Use the IN operator. Employee ID 21912 Emp Name Sarimah Ibrahim Emp Branch Gender Id F 1 Emp Emp Salary Commission 5000.00 1300.00 Emp Emp Position Salesman Contact 019-6548254 21913 Phuah Weng M 2 5500.00 1500.00 Salesman 019-7778525 Chun 21914 Muthu Samy M 2 12000.00 8000.00 Manager 012-3335588 21915 Azrul Ali M 1 13000.00 8800.00 Manager 017-8889997 21917 Kamal Hassan M 4 5150.00 2000.00 Salesman 017-2878888 2. List all the employees' details where name starts with "kam". Employee ID Emp Name Emp Branch Emp Gender Id Salary 21917 Kamal Hassan M 4 5150.00 Emp Commission 2000.00 Emp Position Salesman Emp Contact 017-2878888 21918 Kamal Ahmad M 4 6000.00 2000.00 017-2585220 3. List all the employees details' where the name ends with "san". Asst. Manager Employee ID 21917 Emp Name Emp Gender Branch Id Kamal Hassan M 4 Emp Salary 5150.00 Emp Commission 2000.00 Emp Position Salesman Emp Contact 017-2878888