Answer / anjana

Normalization is the process of efficiently organizing data
in a database. There are two goals of the normalization
process: eliminating redundant data (for example, storing
the same data in more than one table) and ensuring data
dependencies make sense (only storing related data in a
table). Both of these are worthy goals as they reduce the
amount of space a database consumes and ensure that data is
logically stored.

Answer / ghous

well normalization is a broader concept and couldbe called
the back bone of RDBMS..
it involves multiple steps and levels ranginf grom 1-5
that removes dependencies repetition etc...

Answer / raj

It is the process of deciding which attributed has to
grouped to avoid data redundancy.

Answer / jerry joseph

Normalization is the process of removing redundant data and
preventing anomalies during database updates.

we have 1st degree, 2nd degree 3rd degree etc..

3rd degree normalization is commonly used.

Answer / jai

It is the process of desiging narrow tables from the
collection of data to avoid repition of data

Answer / guest

Well a relational database is basically composed of tables
that contain related data. So the Process of organizing this
data into tables is actually referred to as normalization.

Answer / suhail qaiser

normalization is a design process for representing data in
tabular format.the five normal forms are progressive rules
to represent the data with minial redundancy

Answer / ricky

relational database is composed of related data. so method
to combine these table together is known as normalisation.

Answer / maheswar reddy s

Normalization is database scheema design technique.by which an existing database modified to minimize the redundency and dependency of data

Define the term DML, DDL and DTL?

1 Answers  

Give an example of SQL injection attack ?

1 Answers   HAL,

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

1 Answers  

What's the difference between DELETE TABLE and TRUNCATE TABLE commands?

9 Answers  

Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

1 Answers   iSoft,

Explain few examples of stored procedure over triggers?

1 Answers   ADITI,

What is data source in connection string?

1 Answers  

What is normalization and what are the advantages of it?

0 Answers  

What are the grouping functions?

1 Answers  

what are the new features of sql server 2005?

8 Answers   HP, Keane India Ltd,

Why variables called the most powerful component of ssis?

1 Answers  

What does the on delete cascade option do?

1 Answers