what is the difference between first normal form & second
normal form?

Answer Posted / arju

a relation is in first normal form if all the domain
contain atomic value
and it is in second normal form if every non key attribute
is fully dependent on the key attribute and it is in first
normal form.

Is This Answer Correct ?    11 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is SQL Tuning Advisor in Oracle?

631


What is a dynamic performance view in oracle?

604


What is enter substitution variable in oracle?

570


How to set a transaction to be read only in oracle?

578


What are triggers in oracle?

555






What is a sub query? Describe its types?

540


How to see the table columns used in an index?

589


What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

3822


How does oracle handle read consistency?

674


What is a user role in oracle?

613


What are the execution control statements?

611


What are the limitations oracle database 10g xe?

568


What are the various constraints used in oracle?

550


What is a trace file and how is it created in oracle?

548


How to list all tables in your schema?

603