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

GeekInterview.com > Interview Questions > Concepts > Data Modeling

Go To First | Previous Question | Next Question

Data Modeling | Question 4 of 27

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

Total Answers and Comments: 8

Last Update: September 14, 2009

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

June 20, 2005 15:21:13

mdr.mohanrao

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

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.

Is this answer useful? Yes | No

July 12, 2005 04:05:15

prashant

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

false

Is this answer useful? Yes | No

July 21, 2005 01:59:37

Amritashan S. Lal

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

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.

Is this answer useful? Yes | No

August 23, 2005 17:50:41

Sriharsha Hanumanth

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

False. No commerical database can be in 3NF.

Is this answer useful? Yes | No

December 11, 2005 19:25:37

DataGeek

RE: Is this statement TRUE or FALSE – all databases mu...

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

Is this answer useful? Yes | No

January 30, 2006 19:53:36

Gajanan Bhat

RE: Is this statement TRUE or FALSE – all databases mu...

Depends on the applicaton....

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

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

Is this answer useful? Yes | No

May 23, 2006 10:58:43

venky

RE: Is this statement TRUE or FALSE – all databases mu...

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

Is this answer useful? Yes | No

September 14, 2009 02:59:20

osnarayan

Member Since: September 2009 Contribution: 1

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

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

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank