What is Normalization ?

Answer Posted / vikas mohan

It is a technique for designing a database system and is a
process in which data in a single table is being replaced
into number of tables with the same data along with some key
relationships being set up among the tables.
and also reducing duplication in the database,with
the ultimate goal of eliminating duplicate data entirely.

all the best

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to use windows user to connect to the server?

536


Explain implicit cursor.

567


How to upsert (update or insert into a table)?

545


How to use like conditions in oracle?

577


How to pass a cursor variable to a procedure?

570






In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??

1369


How to create an initialization parameter file?

546


How many file formats are supported to export data?

668


How to connect to the server with user account: sys?

568


How can we delete duplicate rows in a table?

570


how to clone 9i Database on to 10g Database.

1833


What is a system tablespace?

611


What are the various types of snapshots ?

568


In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

1789


What is the use of aggregate functions in oracle?

589