3
7.6kviews
Consider a dependency diagram of relation R and normalise it upto third normal form.
written 8.0 years ago by | modified 2.2 years ago by |
Normalise the dependency diagram of ER diagram
ADD COMMENT
EDIT
1 Answer
written 8.0 years ago by | modified 2.2 years ago by |
Normalise the dependency diagram of ER diagram
written 8.0 years ago by |
Step 1: The relation R is already in 1NF, since all its values are atomic.
Step 2: Converting into 2NF form. A relation schema R is in second normal form (2NF) if every non-prime attribute A in R is fully functionally dependent on the primary key
Step 3: Converting into …