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 google scholar a database?
How to get a book from database MS access that contain 'i' charactor in it's name like internetbook or networkingbook. what will be java query for this purpose?
How do you set up a database?
I have a table which has lot of inserts, is it a good database design to create indexes on that table?
What is 3 level architecture dbms?
What are the applications of rdbms?
What are the steps in creating a database?
What is the purpose of reports in a database?
Why are forms important in databases?
What is use of dbms?
Explain the importance of partitioning.
How do you create a blank database?
Oracle (3253)
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)