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 to get the definition of a stored procedure back?
Does transparent data encryption provide encryption when transmitting data across the network?
How to convert numeric expression data types using the cast() function?
What are the advantages of using third-party tools?
How does normalization work?
What is impersonation? What are the different impersonation options available in ssas? : sql server analysis services, ssas
What do you know about normalization and de- normalization?
You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?
Explain alternate key, candidate key and composite key in sql server?
What is faster join or union?
What is normalization of database?
What are the advantages of policy management?
Determine when an index is appropriate?
Explain sql delete command?
What are the steps you will take to improve the performance of a poor performing query?
