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
How to extract metadata for the entire database?
What are the different stages in 'data warehousing'?
Why rdbms is called relational?
What are stored-procedures? And what are the advantages of using them.
Enlist the cursor types.
What is view dbms?
What is join? Mention its types.
How do you open .db files?
What is a candidate key in a database?
What is database implementation?
What is the diff bet plan,package,dbrm?
What is a checkpoint in dbms?
what are database files, control files and log files. How many of these files should a database have at least? Why?
What are indexes? What are b-trees?
What are the various types of relationships in database? Define them.