What is Normalization ?

Answer Posted / chirala venkata suresh

It is set of rules that have been established to aid in the
design of tables that are meant to
be connected through relationships. This set of rules is
known as Normalization.

1.Avoiding repetitive entries
2.Reducing required storage space
3.Preventing the need to restructure existing tables to
accommodate new data.
4.Increased speed and flexibility of queries, sorts, and
summaries.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Describe the types of sub query?

555


How can I combine multiple rows into a comma-delimited list in oracle?

583


Where is the export dump file located?

574


How do I recompile a procedure in oracle?

527


What is transaction control statement and how many types of transaction control statement in Oracle?

565






How to pass a parameter to a cursor in oracle?

597


What exactly do quotation marks around the table name do?

545


Calculate difference between 2 date / times in oracle sql?

572


What is control file used for?

602


What is a data dictionary and how can it be created?

615


How are extents allocated to a segment?

580


How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

1831


How a tablespace is related to data files?

583


What is catalog in Oracle?

649


How to create a table in a specific tablespace?

543