0

This is a assignment from school. Here is the question.

BranchCustomer(branch, customer, employee)

The attributes of the relational table BranchCustomer satisfy the following sets of functional dependencies:

• branch, customer >> employee • employee >> branch

I would think that the highest NF would be 2NF as there is a transitive dependency (empployee >> branch). but i was told otherwise as branch is 1 of the composite key and thus it is a 3NF. Is this correct ?

LouisL
  • 121
  • 1
  • 1
  • 11

1 Answers1

1

If branch is in a candidate key, it does not violate 3NF, the requirement of an attribute being non-transitively dependant is only for non-prime attributes. So yes, this is correct.

Tobberoth
  • 9,327
  • 2
  • 19
  • 17