Q: Draw a set of $3NF$ relations to support the generation of the sample report shown below.

The report reflects the activities of a construction company that manages several building

projects. Each project has its own $($unique$)$ project number, name, employees assigned to

the project, and so on$.$ Each employee has an $($unique$)$ employee number, name, and job

classification such as engineer, computer technician, and so on$.$ The company charges its

clients by billing the hours spent on each contract. The hourly billing rate $($Charge$/$hr$)$ is

dependent on the employee's position $($e$.$g$.,$ an hour's worth of computer technician time is

billed at a different rate than an hour's worth of engineer time$).$

Requirements:

a$.$ Indicate the primary key and the foreign key$($s$)$ of each relation clearly in your answer.

b$.$ Non$-$indication or incorrect indication of PKs and FKs will result in a loss of $1$ point for each

$PK$ and each FK in each table.

c$.$ Do NOT make up any fields of your own to suit your answer.

Sample Report: