Normalization and denormalization
Answers were Sorted based on User's Feedback
Answer / vishnu
In relational Database design, the process of organizing
data to minimize redundancy is called Normalization.
Normalization usually involves dividing a database into two
or more tables and defining relationship b/w the tables.
1) 1st NF: Eliminate Repeating Group(Column)
2) 2nd NF: Eliminate Redundant Data
3) 3rd NF: Eliminate Columns Not dependent on Primary key
4) 4th NF: Isolate Independent Multiple Relationships
5) 5th NF: Isolate Semantically Related Multiple Relationships
De-normalization is the process of attempting to optimizing
the performance of a database by adding redundant data. It
is sometimes necessary bcoz current DBMSs implement the
relational model poorly. its a technique to move from higher
to lower normal forms of database modeling in order to speed
up database access.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / sakthi
Normalization:
Process of decomposing a longer table into
smaller one, by using normalizaton we can fetch the data
faster. there are different types of normalization below
listed are few important one.
1) 1st normal form
2) 2nd normal form
3) 3rd normal form
4) 4th normal form
5) 5th normal form
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / pragyan
database normalization is a data design and organization process applied to data structures based on rules that help building ralational databases.and usually it involves dividing a database into two or more tables and defining relationships between the tables.
de-normalization is the process of attempting to optimize the performance of a database by adding redundant data..
Is This Answer Correct ? | 1 Yes | 0 No |
What is resultset concur_updatable?
Hi..here i would like to know the Backup and Restore models?
Can a function call a stored procedure in sql server?
Why I am getting "the microsoft .net framework 2.0 in not installed" message?
What is indexed views? plz explain with example?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
Tell me the phases a transaction has to undergo?
What is ms sql server triggers?
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
How to update muliple row in single query?
What are the disadvantages of using querystrings to send data from one page to another?
How to insert multiple rows with one insert statement in ms sql server?