What is database normalization?

Answer Posted / anirudh

Normalization is breaking the database into different
tables and defining a relationship between them.
Objective is to isolate the data so that additions and
deletions can be made in one table and propagated to other
tables through relationships.

Is This Answer Correct ?    20 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is usually the first word in a sql query?

812


What options are available to audit login activity? : sql server security

824


In what three ways is the return statement used in a stored procedure?

707


Explain how would you store your query in an SSRS report or a Database server?

102


Do you know how to send email from database?

729






What do you mean by an execution plan? Why is it used? How would you view it?

708


How to sort query output in descending order in ms sql server?

745


What is Cross Join and in which scenario do we use Cross Join?

770


how do you test proper tcp/ip configuration windows machine? : Sql server database administration

708


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 ...

1757


Why is normalisation important?

670


What is Federation Root Database?

100


How much is a sql server license?

687


How to list all columns in a table using odbc_columns()?

727


What is the difference between row_number and dense_rank?

598