retagged by
328 views

1 Answer

1 votes
1 votes

acc to the formal definition of 3NF:

This definition states that a table is in 3NF if and only if, for each of its functional dependencies XA, at least one of the following conditions holds:

  • X contains A (that is, XA is trivial functional dependency), or
  • X is a superkey, or
  • Every element of A-X, the set difference between A and X, is a prime attribute (i.e., each attribute in A-X is contained in some candidate key)

so since Primary key is also a Superkey therefore it satisfies the second condition, and hence relation is in 3NF.

Related questions

3 votes
3 votes
2 answers
1
0 votes
0 votes
0 answers
2
0 votes
0 votes
1 answer
3
bhucho asked Sep 13, 2023
263 views
please can someone help with part (a) of this question.
0 votes
0 votes
1 answer
4
chinmay_rajpurohit asked Mar 2, 2023
651 views
2NF , 3NF, BCNF decomposition allowed if lossless and dependency preserving , both conditions must preserve. Otherwise given decomposition wrong for normal forms. Is this...