What is Normalization ?

Answer Posted / santhoshkavi

its a process of analysing the given relation schems based
on their functional dependencies and primary key to achieve
the properties
1.minimizing redundancy
2.minimizing insertion, deletion and update anamolies
types:
1NF
2NF
3NF

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Give the constructs of a package, function or a procedure.

542


Why do we need integrity constraints in a database?

587


Calculate difference between 2 date / times in oracle sql?

572


How to check database size in Oracle?

642


How to synchronize 2 schema's objects?

1690






What is oracle database 10g express edition?

599


What are the extensions used by oracle reports?

575


How does Oracle guarantee data integrity of data changes?

1936


What is Undo Management Advisor in Oracle?

613


What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

653


Explain the use of rows option in exp command.

585


Explain integrity constraint?

645


How to run the anonymous block again?

595


What is hash cluster in oracle?

596


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

546