is it sufficient to normalize a database up to 3NF?
Answers were Sorted based on User's Feedback
It all depends on users aproach towards data
selec/inserts/updates
... Normelization affects data retrival severely.
we can go up to BCNF
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / shwetal
If possible It should be normalize upto BCNF but it completely depends on the data
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
What is dba in dbms?
How to monitor firebird server activity?
How a Store Procedure called with a cursor out parameter.?
when All datafiles related to a Tablespace are removed ?
Which database server is best?
what are the advantages of a client or server model ?
How to activate all indexes in firebird?
What is the structure of a table in database?
Can an Alert message be changed at runtime ?
Can we create an List of Values without an RECORD GROUP ?
How can you get data from a database in an Excel sheet?
What is the quickest sorting method to use?