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 is sql server used for?
What are extended events in sql server?
What is a sql join?
What is the difference between a clustered index and a non-clustered index?
Explain how to maintain a fill factor in existing indexes?
Explain what are the database objects? : SQL Server Architecture
Explain what is the difference between a local and a global temporary table?
Explain what is analysis service repository?
What are the events recorded in a transaction log?
What types of replication are supported in sql server?
How ssrs maintain security?
What is compression - row-level and page-level compression?
Is sql server a database?
How to execute a sql statement using odbc_exec()?
what are the important architecture components of SSRS?