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
can you instantiate a com object by using t-sql? : Sql server database administration
Explain try...catch with sql server?
Do you know the capabilities of cursors?
List out what other servers you can use with ssrs?
What is the function of sql server agent windows service?
What are the advantages of sql azure?
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
Why I can not enter 0.001 second in date and time literals in ms sql server?
Distinguish between nested subquery and correlated subquery?
What is the difference between dropping a database and taking a database offline?
What is GUID in sql server?
Can you tell me some of the common replication dmv's and their use? : sql server replication
what is dbcc? : Sql server database administration
Explain encryption of entire databases without the need for application changes in sql server 2008?
What is difference between rollback immediate and with no_wait during alter database?
