What is Normalization ?

Answer Posted / gaurav agrawal

Database normalization is a data design and organization
process applied to data structures based on rules that help
building relational databases. In relational database
design, the process of organizing data to minimize
redundancy is called normalization. Normalization usually
involves dividing a database into two or more tables and
defining relationships between the tables. The objective is
to isolate data so that additions, deletions, and
modifications of a field can be made in just one table and
then propagated through the rest of the database via the
defined relationships.

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 return top 5 rows in oracle?

550


How do I use unicode codesets with the weblogic jdriver for oracle driver?

552


Explain a private synonyms?

634


Why do you create or replace procedures rather that drop and recreate.

549


What is an oracle and why it is used?

623






What is the use of aggregate functions in oracle?

581


What is execute immediate in oracle?

549


22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

1606


Explain the importance of .pll extension in oracle?

555


What are the roles of dba?

614


What is oracle server autotrace in oracle?

614


How to write text literals in oracle?

614


I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

2888


What are the ways tablespaces can be managed and how do they differ?

1618


What is rowid and rownum in oracle?

545