a) Given this structure, draw its dependency diagram. Label all the full/ partial/transitive dependencies if any.

b) Break up the dependency diagram you drew in problem Q4 a) to produce well-structured relations which are in 3^rd Normal Form.

Help answer both question thank you

Sunshine Properties wants to expand its business and they decided to create an advanced Employee Profile System. Given below is a database table structure prepared by a computer staff from the company, which contains many unsatisfactory components and characteristics. You have been invited as database design specialist to help them to normalize the table structure. Attribute name EMP_CODE NAME EDUCATION DEPT_CODE DEPARTMENT NAME JOB_CLASS JOB_TITLE BIRTH_DATE HIRE_DATE JOB_BASE_SALARY ...Continue Sample value 1001 Muhammad Afif BDEM. PhD RMGT Risk Management 23 CEO 12/23/65 10/14/94 (RM)10000