Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between first normal form & second
normal form?
- 11 Answers
- 35016 Views
- IBM, Oracle, I also Faced
- E-Mail Answers
Answer Posted / aysh
First normal form (1NF or Minimal Form) is a normal form
used in database normalization. A relational database table
that adheres to 1NF is one that is free of repeating
groups.Second normal form (2NF) is a normal form used in
database normalization,where a table that is in first
normal form (1NF) must meet additional criteria if it is to
qualify for second normal form. Specifically:a 1NF table is
in 2NF if and only if none of its non-prime attributes are
functionally dependent on a part (proper subset) of a
candidate key. (A non-prime attribute is one that does not
belong to any candidate key.)
| Is This Answer Correct ? | 11 Yes | 3 No |
Post New Answer View All Answers
What is PL/SQL ?
How can we force the database to use the user specified rollback segment?
How to write date and time interval literals in oracle?
what is a Nested Loop join?
What is the data pump import utility?
What is a trigger oracle?
What is an oracle table?
How to invoke the data pump export utility?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
How to turn on or off recycle bin for the session?
How to check the oracle tns settings?
How to use subqueries in the from clause in oracle?
Give the different types of rollback segments.
What is a initialization parameter file in oracle?
is there a tool to trace queries, like profiler for sql server?
