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.
Related Book For
Probability and Statistics
ISBN: 978-0321500465
4th edition
Authors: Morris H. DeGroot, Mark J. Schervish
Posted Date: