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
What is openxml in sql server?
Explain the disadvantages/limitation of the cursor?
How to specify the collation for a character data type in ms sql server?
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What are the different normalization forms?
Which sql server table is used to hold the stored procedure scripts?
What is Lock table in SQL?
Explain transaction server isolation?
How to verify the port number of the sql server?
What does it mean to normalize a database and why would you do it?
How to divide query output into multiple groups with the group by clause in ms sql server?
How to test odbc dsn connection settings?
What are sub reports?
How to find the second highest salary of an employee?
