Interested to Buy Any Domain ? << Click Here >> for more details...
What is normalization and what are the different forms of
normalizations?
- 2 Answers
- 14298 Views
- I also Faced
- E-Mail Answers
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
Why use cursor in sql server?
What are different types of constraints?
What is the ‘fillfactor’?
What program is used to store the data source file?
what is a traditional network library for sql servers? : Sql server database administration
Explain few examples of stored procedure over triggers?
What are a scheduled jobs?
What is fill factor and pad index?
What does it mean to invest in the index?
Can we do dml on views?
Ms sql server index?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
How to get a list all databases on the sql server?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
Define normalisation?
