Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between first normal form & second
normal form?
- 11 Answers
- 35491 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
Explain the difference between replace() and translate() functions in oracle?
How to define an anonymous procedure with variables?
Difference between pre-select and pre-query
How to delete a user account in oracle?
How to write a left outer join with the where clause in oracle?
What are the differences between date and timestamp in oracle?
What is the recommended interval at which to run statspack snapshots, and why?
How to get a list of all user accounts in the database?
What would you do with an in-doubt distributed transaction?
How do I escape a reserved word in oracle?
What is coalesce function?
What is the difference between sharding and partitioning?
what is reindexing?
How to run create database statement?
what is the difference between data migration and production migration.
