Suppose you have a Relation that has an atomic Primary Key and noRepeating Groups. All non-key columns are functionally dependent on the Primary Key, but it has a Transitive Functional Dependency. How would you resolve this Transitive Functional Dependency? you would create a 1:M relationship between the initial table and a new table and place the columns that are Transitively Functionally Dependent on the many side. You would move the columns that are Transitively Functionally Dependent to a parent table. The column they were Transitively Functionally Dependent on serves as the Foreign Key to the parent table Transitive Functional Dependencies can only exist with a Composite Primary Key and the, therefore, can;t exist in the table as it has an atomic Primary Key. You would move the column that are Transitively FUnctionally Dependent to a child table. The column they were Transitively Functionally Dependent on serves as the Primary Key to the child Table
Suppose you have a Relation that has an atomic Primary Key and noRepeating Groups. All non-key columns are functionally dependent on the Primary Key, but it has a Transitive Functional Dependency. How would you resolve this Transitive Functional Dependency?
you would create a 1:M relationship between the initial table and a new table and place the columns that are Transitively Functionally Dependent on the many side.
You would move the columns that are Transitively Functionally Dependent to a parent table. The column they were Transitively Functionally Dependent on serves as the Foreign Key to the parent table
Transitive Functional Dependencies can only exist with a Composite Primary Key and the, therefore, can;t exist in the table as it has an atomic Primary Key.
You would move the column that are Transitively FUnctionally Dependent to a child table. The column they were Transitively Functionally Dependent on serves as the Primary Key to the child Table
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
