What is Normalization ?

Answer Posted / hema kumar sunnapu

Database designed based on the E-R model may have some amount of inconsistency, ambiguity and redundancy. To resolve these issues we have to do some amount of refinement is required. This refinement process is called as Normalization.
(OR)
Normalization is the process of efficiently organizing data in database. There are two goals of the normalization process: eliminating redundant data and ensuring data dependency make sense.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to write an inner join with the where clause in oracle?

601


Give the various rollback segment states.

592


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.

2903


How to drop an index in oracle?

623


How to create a new view in oracle?

630






What is archive log in Oracle?

622


How to write a query with a left outer join in oracle?

617


How to start a new transaction in oracle?

599


How to use "if" statements on multiple conditions?

733


How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

558


How to define a sub function?

679


How to change user password in oracle?

618


What is blob data type in oracle?

572


HI, Please let me know the syllabus for Oracle OCA and OCP Certification

1965


What are the various oracle database objects?

692