Database Interview Questions and Answers
<< Previous Question Next Question >>
 Question: 1226 Page Views: 

What do you mean by normalization?



Posted By: Avi Date: 1 October 2010 10:56:06 AM
 Answer:

Basically normalization is a process in realational databse design to organise the data and avoid data redundancy. It usually involves dividing database into two or more tables and then define a relation between them. One of the table is the main table and rest are the transaction tables. Updations ,Deletions and additions are made in the main table and then are propagated to transaction tables which are related to it.


Posted By: avibtech

Date: 1 October 2010 10:56:06 AM
Post a better Answer if you have
 
(Will show your Gravatar icon)  
  Country flag

Loading
Enter the text as shown in the image Zl2zcm
Related Questions
Database : What is a Foreign Key?

What is a Foreign Key?

A foreign key is a referential constraint between two tables. The foreign key identifies a column or....
Category: Database Date: 8/20/2009 3:01:26 AM
Database : What is a Primary Key?

What is a Primary Key?

Primary key is the unique identifier for a record in the table. Here record refers to the value in t....
Category: Database Date: 8/20/2009 2:57:19 AM
Database : What is a DBMS?

What is a DBMS?

DBMS is a system where all interrelated data is atored and it allows the user to access data, modify....
Category: Database Date: 8/20/2009 2:56:07 AM
Database : What is namespace for xml?

What is namespace for xml?

System.XML
Category: Database Date: 7/25/2009 6:26:47 PM
Database : What is the difference between an explicit and an implicit lock?

What is the difference between an explicit and an implicit lock?

Explicit Lock: Lock is explicitly requested for a record or table. Implicit Lock: Lock is implied....
Category: Database Date: 7/25/2009 6:21:47 PM
 
Signup for our weekly email newsletter
email newsletter
Questions Categories