/* Exercise NO 21 Generate the employee details and compute the salary based on the department.*/ -- creating database employee and opening it for use. create database employee ; use employee ; -- create employee table in employee database create table emp_table ( emp_id int ( 4 ), Dpt_id int ( 4 ), emp_name varchar ( 20 ), salary decimal ( 7 , 2 ) ); -- create department table create table dpt_table ( dpt_id int ( 5 ), dpt_name varchar ( 20 ), supervisor varchar ( 20 ) ); -- Insert record into the employee table. INSERT INTO EMP_table ( emp_id , Dpt_id , emp_name , salary ) VALUES ( 101 , 01 , 'ARUN' , 15000 ); INSERT INTO EMP_table ( emp_id , Dpt_id , emp_name , salary ) VALUES ( 102 , 02 , 'ARUNachalam' , 25000 ); INSERT INTO EMP_table ( emp_id , Dpt_id , emp_name , salary ) VALUES ( 103 , 03 , 'Blesson' , 15000 ); INSERT INTO EMP_table ( emp_id , Dpt_id , emp_name , salary ) VALUES ( 104 , 04 , ...