The Gateway to Computer Science Excellence
First time here? Checkout the FAQ!
x
+15 votes
963 views

Which normal form is considered adequate for normal relational database design?

  1. $2NF$
  2. $5NF$
  3. $4NF$
  4. $3NF$
asked in Databases by Veteran (59.5k points)
edited by | 963 views

4 Answers

+29 votes
Best answer
$3NF$,
because we can always have a $3NF$ decomposition which is dependency preserving and lossless (not possible for any higher forms).
answered by Veteran (55.1k points)
edited by
+13 votes
Answer: D
3NF will be adequate for normal relational database design since 3NF tables are free of insertion, update, and deletion anomalies.
answered by Boss (34k points)
+2

Rajarshi Sarkar can you please explain - 3NF tables are free of insertion, update, and deletion anomalies.

+11 votes
3 NF cause it ensures both lossless and dependency preserving ..In BCNF DP is not always possible although it is more strict than 3NF..
answered by Active (1.9k points)
0 votes
Ans: D
answered by Loyal (7.2k points)
0
But why not BCNF, sure 3NF is dependency preserving. BCNF is less redundant compare to 3NF. Size of DB is an concern.
0
3NF is always lossless and dependency preserving but BCNF is always lossless only. Dependency preserving is not guaranteed in BCNF


Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true

38,079 questions
45,571 answers
132,066 comments
49,040 users