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 is a recursive stored procedure?

612


What is a join query?

542


How do I run pl sql in sql developer?

618


Can we use ddl statements in stored procedure sql server?

507


How can I speed up sql query?

517






What are the different types of joins in sql?

575


What are pl/sql packages?

565


Explain isolation levels. : Transact sql

571


Why do we create views in sql?

545


What is the source code of a program?

500


what is single byte over head in oracle..?

1860


Explain what is a view?

587


Can primary key be changed?

519


What is pl sql script?

558


How can triggers be used for the table auditing?

588