From Functional Dependency for determine candidate key. Use the following relation EMPLOYEE: E-ID E-NAME E-CITY E-STATE E001 John Delhi Delhi E002…

From Functional Dependency for determine candidate key.

Use the following relation EMPLOYEE:

E-IDE-NAMEE-CITYE-STATE
E001JohnDelhiDelhi
E002MaryDelhiDelhi
E003JohnNoidaU.P.

Functional dependencies:

  1. E-ID → E-NAME
  2. E-ID → E-CITY
  3. E-ID → E-STATE
  4. E-CITY → E-STATE

From the Sonali & Janata Bank Assistant Database Administrator 2022 – Written exam, question 4 of 9.

More from this paper