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.

 

Transcribed Image Text:

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 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