What is normalization and types of normalization?

Answer Posted / aa

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.

Is This Answer Correct ?    204 Yes 40 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what happens if you no create privilege in a database? : Sql dba

719


what happens if null values are involved in expressions? : Sql dba

736


What is sql and explain its components?

799


What is a temporal table?

666


Is it possible to create the following trigger: before or after update trigger for each row?

926






What is clustered index sql?

700


What are the disadvantages of not performing database normalization?

806


What packages(if any) has oracle provided for use by developers?

5323


What is partition by in sql?

784


what are date and time data types in mysql? : Sql dba

688


What is union and union all keyword in sql and what are their differences?

803


Does sql support programming?

769


what is collation? : Sql dba

799


Is left join inner or outer by default?

762


Is not null in sql?

732