Question $2$: ER Modelling, SQL$,$ and Normatisation $[25$ marks$]$

a$)$ Convert the below diagram to a relational DB Schema using the rules discussed in class. $[8$ marks$]$

b$)$ Query the database, using a SELECT SQL statement that results in listing the first and the last name of all the employees that have a vehicle. $[8$ marks$]$

c$)$ Answer the following questions.

a$.$ Define the first normal form $[2$ marks$]$

b$.$ Define the second normal form $[3$ marks$]$

c$.$ Define the third normal form $[3$ marks$]$

d$.$ State whether the tables in $($a$)$ is in $3$NF and why $[1$ mark$]$