Question $2[40$ marks$]$

$$

In the table below, there is some data required to create and company database that can manage dif$-$ ferent projects within an organisation. The table includes information about;

$$ The project numbers and project names

$$ The employee names, their jobs classes and the projects that they are working on

$$ The charge per hour, the billing hours and the total charges for employee in each job class

$$

$$ The total charges for each project and the overall charge for all combined

NB: Table see the attachment