$4$a$.$ Based on TABLES above, write the following SQL statements:

i$)$ Write the necessary SQL statement to create table Project and describes suitable type of attributes as well.

$(5$ marks$)$

ii$)$ Show the output result following SQL$.$

a$.$ SELECT $*$ FROM Employee WHERE

Employee.Department No$.=$ Department.Department No$.$

GROUP BY Department. Department Name

$(5$ marks$)$

b$.$ SELECT Project. ProjectTitle, Project. ProjectManager, Project.ProjectBudget, ProjectTeam.EmployeeNo

FROM

Project, ProjectTeam

WHERE

Project.ProjectCode$=$ProjectTeam.ProjectCode

GROUP BY

Project.ProjectTitle.

$(5$ marks$)$

$4$b$.$ Based on Figure $2,$ Write SQL statement to produce following report $($Figure $3).$