Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between first normal form & second
normal form?
- 11 Answers
- 35801 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
Which is faster join or subquery in oracle?
What is clustered table in Oracle?
what is the dual table in oracle?
What is index-organized table in Oracle?
What is tns service name?
How to get execution path reports on query statements?
What is recovery manager(rman) backup in Oracle?
6. Display the client name and order date for all orders using the traditional method.
What is the maximum number of triggers that can be applied to a single table?
What are the attributes of cursor?
What is an Oracle index?
How can we find out the current date and time in oracle?
What happens to the data files if a tablespace is dropped?
What are the numeric comparison operations?
What is parameterized cursor in oracle?
