Step1:Identify Each New Determinant
- For every transitive dependency, write its determinant as Primary Key for new table
Step2: Identify the dependent Attributes
- Identify attributes dependent on each determinant identified in Step 1 and identify dependency
Step3: Remove the dependent Attributes from transitive dependencies.
- Eliminate all dependent attributes in transitive relationship from each of the tables that have such a transitive relationship.
No comments:
Post a Comment