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 22

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

Total Answers and Comments: 7

Last Update: May 23, 2006

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

Go To Top