What is normalization and what are the different forms of
normalizations?
Answer Posted / asif nadeem
Normalization is simply a process which is use to store
data efficiently on data base but in this it is
underestimated rules that must be performed.
1) Delete the data which repeating again and again
2) Maintain data of rows and columns into their releated
tables and columns.
there are some types of Normalization
1) 1N
2) 2N
3) 3N
4) 4N
1N:it is known as first normalization and in thsi we
transfer data towards the releated columns and subsets in
which data is repeating is deleated
2N:in this form the 1N steps are implimented and after it
data is maintain in the same table and in columns
3N:in this 2N steps are performed and the subsets of
predcessors are deletd or they are arranged into the
different but of same tables, releation ship is built b/w
the data so that it can be easily accessable.
4N:in this type the 3N steps are performed and main thing
which extra in this is no repeated is present in the 4N
Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
Does partitioning ssd reduce performance?
What is the difference between a clustered index and a non-clustered index?
What is a unique key constraint?
What is report server project?
Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
Can binary strings be converted into numeric or float data types?
What is federation member?
State a few properties of relational databases?
Name three of the features managed by the surface area configuration tool? : sql server security
What are the new data types are introduced in sql 2000?
what are the three command line utilities and what are their primary functions?
What are different types of schemas?
Explain the third normal form(3nf)?
What is the default Port No on which SQL Server listens?