Is this statement TRUE or FALSE – all databases must be in third normal form?

Showing Answers 1 - 8 of 8 Answers


  • Jun 20th, 2005

In general all organization data bases are normalised to 3nf inorder to remove redundancy and efficent access.A data base can also be created with out normalisation.Hence it is not a mandatory that a database should be in 3nf.

  Was this answer useful?  Yes


  • Jul 12th, 2005


  Was this answer useful?  Yes

Amritashan S. Lal

  • Jul 21st, 2005

False. It is not necessary that all databases should be in the Third Normal Form. It is upto the requirement of the application. 
Adhering to the third normal form, while theoretically desirable, is not always practical. If you have a Customers table and you want to eliminate all possible interfield dependencies, you must create separate tables for cities, ZIP codes, sales representatives, customer classes, and any other factor that may be duplicated in multiple records. 
In theory, normalization is worth pursuing; however, many small tables may degrade performance or exceed open file and memory capacities.

Sriharsha Hanumanth

  • Aug 23rd, 2005

False. No commerical database can be in 3NF.

  Was this answer useful?  Yes


  • Dec 11th, 2005

What kind of a response is that?  You are missing the point here. 3NF is certainly achievable but not mandatory.

  Was this answer useful?  Yes

Gajanan Bhat

  • Jan 30th, 2006

Depends on the applicaton....

For transactions would generally go with 3NF....

For reporting applications would probably go with denormalised..


  • May 23rd, 2006

False, all databases need not be in 3NF, however in most cases in the business world databases tend to be in 3NF or BCNF

  Was this answer useful?  Yes


  • Sep 14th, 2009

Yes. It is true that all the database should be in the third normal form. Hope, Third Normal Form is sufficient to tune the database and make it perfect. 4th Normal Form onwards it is not at all required to normalize. After third Normal Form, IF there may be Performance Issue, then we can Denormalize the database. So minimum one database to be in the Third Normal Form. Upto THird Normal Form all Business requirements usually Satisfies.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions