Mysql Create View

Create View for Department

Create view dept as select dname as ‘department’, count(fname) as ‘number of employees’, avg(salary) as ‘salary’ from department join employee on dno=dnumber group by dname;

 

Create View for Employee

Create view name as select concat (fname,’’,minit,’’,lname) as ‘fullname’, salary as ‘salary’, dname as ‘department’ from employee join department on dnumber=dno;

Create View for Project 

Create view proj as select pname as ‘project’, count(fname) as ‘number of employees’ from project join employee on dnum=dno group by pname;