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
What are the different type of relationships in the dbms?
What are notification services?
What is the purpose of queries in a database?
How do you create a database for an organization?
How does index hunting help in improving query performance?
Define stored procedures.
Explain the advantages and disadvantages of a hierarchical database?
What are stored procedures in a database?
What is a database in business?
Differentiate between ‘delete’, ‘truncate’ and ‘drop’ commands.
What are the steps in creating a database?
What is difference between database and file?
What is the default '-sort' order for a sql?
What's the difference between clustered and non-clustered indexes?
What are stand-alone procedures?