Database design (normalisation..1NF ,2NF, 3NF)

Part Two (Normalisation The LIVER DATABASE Company in Liverpool wishes to allocate staff to a new development project that has been proposed by external companies. As a result, a new relation was created for this proposal as follows: SaffPro (StaffNo, ProjNo, ProjName ProjLocation, StaffHours StaffAddress, StaffEmail, StaffMobileNo) Assuming that, StaffSurName, StaffNo stands for staff number of the employee ProjNo identifies one of the projects that the staff works on; StaffHours is the number of hours per week that the staff works on the project ProjName and Project location are the name and location of the project StaffSurName is the staff surname StaffAddress is the postcode of the address of the staff StaffEmail is the staff university email address. StaffMobileNo is the staff Mobile telephone number (a) Using appropriate diagrams to aid in your answer, briefly describe the following concepts Normalisation including First, Second and Third Normal forms. Primary, Forign and Candidate keys. Functional dependences (b) Based on the given primary key (StaffNo, Projld). would normalise the StaffProject relation to first, second and third normal forms, indicating the functional dependencies you use in each stage of normalisation with justifications. State any assumptions you make about the data and time (if Show, comprehensively, how you