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 |
Is sql is a dbms?
What is the importance of query in database?
What are the types of Calculated columns available ?
What is relational database ? Give me an example !
What is the rdbms concept in sql?
Is there a way to detect whether fbclient.dll or fbembed.dll is loaded?
What is the use of COMPRESS option in EXP command ?
Define database lock?
How do you create a blank database?
what the List of Values (LOV) supports ?
What are the characteristics of database management system?
What is difference between database and website?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)