Database

Employee (empID. Name Name, address, DOB, sex, position, dede) Department (deptNo depodang mgrEmpID Project proiNe preName, dentNo) Wackson (empID. proiNe hoursWorked) where Employee Department Project contains employee details and empID is the key. contains department details and deptro is the key. mgr.Emri identifies the employee who is the manager of the department. There is only one manager for each department. contains details of the projects in each department and the key is pro No (no two departments can run the same project). contains details of the hours worked by employees on each project, and empl/proiNo form the key. and Workson (a) Produce a report of the total hours worked by each employee, arranged in order of department number and within department, alphabetically by employee surname. (Show the query) (b) For each project on which more than two employees worked, list the project number, project name and the number of employees who work on that project. (Show the query)