A relation employee is defined as follows: = (employee_id, name, street, city, postal_code, designation, salary, project_no, project_description,

Fantastic news! We've Found the answer you've been seeking!

Question:

A
relation ‘employee’ is defined as follows: = (employee_id, name, street, city,
postal_code, designation, salary, project_no, project_description, working_hr)

In
this relation job related information is recorded of all employees along with
designation, address & salary. Employee id is a unique number. Any
employee may work for several projects for different working hours.

Give a set of
functional dependencies (FDs) for this relation. Normalize the relation into 3NF.