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
Define tool Manage Statistics in SQL Server 2000 query ?
How many ways to create table-valued functions?
How to execute a sql statement using mssql_query()?
How to create an inline table-valued function?
What is 'Join' and explain its various types.
How to truncate the log in sql server 2012? : sql server database administration
What is named calculation? : sql server analysis services, ssas
What is cdc in sql server?
When do you think a developer should use sql server-based cursors?
How to display a past time in days, hours and minutes?
How to recover from sql injection? : sql server security
Which autogrowth database setting is good?
How many triggers you can have on a table?
optimization techinques
What is nolock?
