is it sufficient to normalize a database up to 3NF?

Question Posted / shivakrishna

4 Answers
5742 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

is it sufficient to normalize a database up to 3NF? ..

Answer / ramesh

3NF is morethan enough.

Is This Answer Correct ?

3 Yes

1 No

is it sufficient to normalize a database up to 3NF? ..

Answer / praveen hattikal

It all depends on users aproach towards data
selec/inserts/updates
... Normelization affects data retrival severely.
we can go up to BCNF

Is This Answer Correct ?

2 Yes

0 No

is it sufficient to normalize a database up to 3NF? ..

Answer / shwetal

If possible It should be normalize upto BCNF but it completely depends on the data

Is This Answer Correct ?

1 Yes

0 No

is it sufficient to normalize a database up to 3NF? ..

Answer / jdfiji

dependent on application. Most transactional based
databases require this to avoid duplication etc. However,
OLAP, these type of databases (typically those used in data
warehouses etc.) are not necesarrily normalised as they are
built for performance of querying the data contained within.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Database Management Interview Questions

What will the SHOW_ALERT function returns ?

3 Answers College School Exams Tests, DSS,

What is the difference between Memory_target and Memory_max_target? Why its required to resize these parameter?

1 Answers Sutherland,

How many types of database language exist?

0 Answers

Explain the necessary techniques to control deadlocks?