a relation is in first normal form if all the domain contain atomic value

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

Question Posted / arju

11 Answers
35477 Views
IBM, Oracle, I also Faced
E-Mail Answers

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 the usage of synonyms?

1142

What is oracle server autotrace in oracle?

1166

What are the different types of modules in oracle forms?

1001

How to define a variable of a specific record type?

1077

How to use subqueries in the from clause in oracle?

1111

What is a package in oracle?

1101

What is oracle database client?

1032

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2209

How to resolve the ORA-39133 error in Oracle?

1113

Is there a function to split a string in plsql?

1055

How to fetch the row which has the max value for a column?

1000

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2307

Is there an oracle sql query that aggregates multiple rows into one row?

976

How index is implemented in oracle database?

1006

What happens if the imported table already exists?

1033