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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different type of relationships in the dbms?

501


What are notification services?

502


What is the purpose of queries in a database?

543


How do you create a database for an organization?

478


How does index hunting help in improving query performance?

516






Define stored procedures.

547


Explain the advantages and disadvantages of a hierarchical database?

604


What are stored procedures in a database?

481


What is a database in business?

544


Differentiate between ‘delete’, ‘truncate’ and ‘drop’ commands.

535


What are the steps in creating a database?

480


What is difference between database and file?

443


What is the default '-sort' order for a sql?

519


What's the difference between clustered and non-clustered indexes?

499


What are stand-alone procedures?

545