what is normalization?
what is denormalization?
- 9 Answers
- 32740 Views
- Satyam, I also Faced
- E-Mail Answers
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
Can two tables have the same primary key?
what is database replicaion? : Sql server database administration
What are the steps to insert a table?
What is a not null constraint?
Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)
What is efficiency data?
Which are ddl commands?
Explain the dirty pages?
What do you mean by an execution plan? Why is it used? How would you view it?
What is similarity and difference between truncate and delete in sql?
How to delete existing rows in a table?
What is the difference between TRUNCATE and DROP?
How many categories of data types used by sql server?
What are the different types of lock modes in sql server 2000?
How can you find out how many rows returned in a cursor?
