Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
How do I start sql server 2016?
Is resultset an interface?
What is the difference between set and select?
What does truncate do?
what are the three command line utilities and what are their primary functions?
What is self contained sub query?
In which tcp/ip port does sql server run? Can it be changed?
What is difference between rownum and row_number?
What is candidate key with example?
What are the default system databases in sql server 2000?
What is reportserver and reportservertempdb ?
What are the steps you should follow to start sql server in single-user mode?
Can sql server 2016 run on windows 7?
How to create a new table in a given schema?
Explain the rules for designing files and file groups in sql server?
