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
Are resultset updatable?
Explain full-text query in sql server?
How to how to convert numeric expression data types using the convert() function??
What do you mean by data manipulation language?
Other than truncate statement, which other command can by-pass the trigger on the tables?
Why truncate is ddl?
What is partition index in sql server?
Explain about remote stored procedure?
What is store procedure? When do you use?
What is change data capture (cdc) in sql server 2008?
how can u get last observation in an unknown dataset ?
What is stretch database in sql server?
Can you explain various data region available in ssrs with their use?
Explain can you implement data mining in ssrs?
How to execute a sql statement using mssql_query()?
