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

How do we accept inputs from user during runtime?

784


What is pls_integer in pl sql?

826


What is a sql driver?

735


What are the 3 modes of parameter?

910


How to revise and re-run the last sql command?

895


define join and explain different type of joins? : Sql dba

775


What are the triggers associated with image items?

836


What is view? Can we update view

1121


Can we create clustered index without primary key?

751


What are pl sql data types?

779


What is left join in postgresql?

825


Define implicit and explicit cursors.

863


What are sql ddl commands?

802


what is online transaction processing (oltp)? : Sql dba

766


What is cascade in sql?

744