create a view empdep containing ename and number


Create a view emp_dep containing e_name and number of dependents from the tables employee and dependent of (i)

CREATE VIEW emp_dept AS SELECT ename,
COUNT(*) FROM employee, dependent
WHERE employee.e_no = dependant.e_no GROUP BY e_name;

Request for Solution File

Ask an Expert for Answer!!
Database Management System: create a view empdep containing ename and number
Reference No:- TGS0282953

Expected delivery within 24 Hours