edited by
10,221 views
31 votes
31 votes

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

  1. $2NF$
  2. $5NF$
  3. $4NF$
  4. $3NF$
edited by

8 Answers

Best answer
62 votes
62 votes
$3NF$,
because we can always have a $3NF$ decomposition which is dependency preserving and lossless (not possible for any higher forms).
edited by
21 votes
21 votes
Answer: D
3NF will be adequate for normal relational database design since 3NF tables are free of insertion, update, and deletion anomalies.
13 votes
13 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..
3 votes
3 votes

Reason of choosing 3NF over BCNF.

               1.We normally choose to retain dependency preservation.

               2.A high penalty in system performance is to be paid or risk the integrity of the data in our database.

Both the reason describe the nature of preference or security and data over the redundancy ,which is satisfy by the 3NF.

Although BCNF satisfy this problem but dependencies are not preserved always.

SO 3NF is correct answer .

Answer:

Related questions

19 votes
19 votes
4 answers
2
Kathleen asked Sep 25, 2014
13,875 views
A counting semaphore was initialized to $10$. Then $6 P$ (wait) operations and $4V$ (signal) operations were completed on this semaphore. The resulting value of the semap...
32 votes
32 votes
3 answers
3
Kathleen asked Sep 25, 2014
10,005 views
When the result of a computation depends on the speed of the processes involved, there is said to becycle stealingrace conditiona time locka deadlock
18 votes
18 votes
4 answers
4