-1

I have the following table:

I need to identify the functional dependencies in this table. BranchID(primary key) is unique and it is the same story with Address and Phone_number. I have an idea on what is but I need to double check to see if I am correct. In needing to identify the functional dependencies, I am struggling to understand whether the Address and Phone_Number attributes are functionally dependent on BranchID seeing as the attributes themselves can uniquely identify the entire tuple.

NaMarPi
  • 164
  • 11
Softey
  • 1,451
  • 3
  • 21
  • 42

1 Answers1

0

Both Address and Phone number are functionally dependent on Bramch ID.

Edper
  • 9,144
  • 1
  • 27
  • 46
  • How comes? I thought that the fact address and phone_number are unique this means that don't need branchid to be uniquely identified. – Softey Nov 29 '13 at 10:37
  • I assume that Address and Phone number are address and phone number of the branch if not then it would not be functionally dependent. – Edper Nov 29 '13 at 10:39