Display employee data in a tabular layout with edit& delete functionality as well as display summary for number of employee and grand salary
Two table
Department
Deptid int primary key
Deptname varchary
2 table emp
Empid
Empname
Empjob
Empsalary
Deptid
Use two table primary foreign concept
?