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

Showing Answers 1 - 7 of 7 Answers

mdr.mohanrao

  • 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

prashant

  • Jul 12th, 2005
 

false

  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

DataGeek

  • 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 apps...you would generally go with 3NF....

For reporting applications ...you would probably go with denormalised..

venky

  • 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

osnarayan

  • 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.
Thanks
OS.Narayan

  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