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
Which are the two editions in which SQL Azure database available?
What is a covered index?
What is the difference between NOROW and LOCKROW?
What is normalization and its types?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
What is role playing dimension with two examples? : sql server analysis services, ssas
What are the ways available in sql server to execute sql statements?
What are cursors? Explain different types of cursors. What are the disadvantages of cursors? How can you avoid cursors?
What is awe?
What are orphan records?
Difference between 2NF &3NF ?
What does it mean to normalize data?
What is join query?
What are the database objects? : SQL Server Architecture
In what sequence sql statement is processed?