What is normalization ?

Answer Posted / seenuvasan.a

It is a process of the analysing the given relation schemas based on their Functional Dependency(FDs) and primary key to achieve the properties,

-> Minimizing redundancy.
-> Minimizing insertion,deletion,and update anomalies.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why do you partition data?

538


Explain the uses of database trigger.

664


Why does sql need a server?

572


What are the two parts of design view?

590


Is pl sql a scripting language?

597






Can a foreign key be null?

597


What kind of join is join?

564


What is query syntax?

523


How do I restart sql?

536


Explain cursor types?

589


How to Execute a Package in PL/SQL.?

599


Which is better cte or subquery?

550


What is normalization? How many normalization forms are there?

563


What is difference between inner join and cross join?

528


Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

631