Get premium membership and access questions with answers, video lessons as well as revision papers.

Describe what is meant by full functional dependency and describe how this type of dependency relates to 2NF. Provide an example to illustrate your answer.

      

Describe what is meant by full functional dependency and describe how this type of dependency relates to 2NF. Provide an example to illustrate your answer.

  

Answers


kelvin
The formal definition of second normal form (2NF) is a table that is in first normal form and every non-primary-key column is fully functionally dependent on the primary key. Full functional dependency indicates that if A and B are columns of a table, B is fully functionally dependent on A, if B is not dependent on any subset of A. If B is dependent on a subset of A, this is referred to as a partial dependency. If a partial dependency exists on the primary key, the table is not in 2NF. The partial dependency must be removed for a table to achieve 2NF
kevowmuchiri answered the question on July 9, 2018 at 19:04


Next: Describe the characteristics of a table in second normal form (2NF).
Previous: Describe the characteristics of a table in third normal form (3NF).

View More Computer Science Questions and Answers | Return to Questions Index


Learn High School English on YouTube

Related Questions