what is the difference between first normal form & second
normal form?
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 oracle database 10g express edition?
How to retrieve data from an cursor to a record?
What would you do with an in-doubt distributed transaction?
What is background process in Oracle?
What is the difference between substr and instr?
Will you be able to store pictures in the database?explain.
How to call a stored function in oracle?
How do you store pictures in a database?
State some uses of redo log files?
What happens if you lost a data file?
Difference between pre-select and pre-query
Explain what are the type of synonyms?
what is insert all statement in sql
What are joins, explain all types of joins?
What is the difference between PFILE and SPFILE in Oracle?