what is normalization?
what is denormalization?
Answer Posted / koti
In relational database design, the process of organizing
data to minimize redundancy. Normalization usually involves
dividing a database into two or more tables and defining
relationships between the tables. The objective is to
isolate data so that additions, deletions, and modifications
of a field can be made in just one table and then propagated
through the rest of the database via the defined relationships.
De-normalization is introducing redundancy.
Is This Answer Correct ? | 12 Yes | 4 No |
Post New Answer View All Answers
What are SSL and TSL protocols?
Explain SSRS Architecture?
List the data types available in mssql?
Explain about the command-line tool SQLCMD?
What is difference between count (*) and count 1?
What is database dimension? : sql server analysis services, ssas
Is it possible for a stored procedure to call itself or recursive stored procedure?
How to change the password of a login name in ms sql server?
How do you debug a procedure in sql server?
What do you do in data exploration
What is the significance of master, tempdb and model databases?
Explain indexed views?
Can you explain about buffer cash and log cache in sql server?
Explain different types of collation sensitivity?
Tell me what is log shipping?