Question

Consider the relation r1(employee_name, project_name, dependent_name). If {{employee_name -->-> project_name}, {employee_name -->-> dependent_name}}, what is the highest normal form it satisfies?

Answer 1

Answer:

employee_name -->-> project_name}, {employee_name -->-> dependent_name}}, what is the highest

Answer 2

Answer:

The highest normal form of this relation scheme is (A) 2 NF ... As C and A on RHS of both the FDs are prime attributes, they satisfy 3NF.