Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between first normal form & second
normal form?
- 11 Answers
- 35489 Views
- IBM, Oracle, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / somu.kattikar
First Normal Form:
1.it doesnt contain the duplicate rows and null values.
2.those values can be moved into new table.
second normal form:
1.each columns are completely depend upon key
| Is This Answer Correct ? | 40 Yes | 7 No |
Answer / nagulmeera
first normol form contain multi valued attribute.
in second normal form contain partially depended on non key
attribute
| Is This Answer Correct ? | 15 Yes | 7 No |
Answer / 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 |
Answer / 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 |
Answer / imran khan
First normal form, sets the very basic rules for an
organized database i.e. Eliminate duplicative columns.
Create separate tables for each group of related data and
identify the row with a unique column i.e the primary key.
Second normal form further removes the duplicate data:
i.e. Meet the requirements of the first form of
normalalization. Create relationships between new tables
through foreign keys.
| Is This Answer Correct ? | 12 Yes | 6 No |
Answer / amit tailor
first normal form is repating group avoid. and one primary
key difine.
second normal form also repating filed avoid and all null
key is the candidate key. more then primary key is "compose
key"
| Is This Answer Correct ? | 9 Yes | 4 No |
Answer / manoj gogoi
1NF: NO duplicate records.
2NF: No composite primary key
| Is This Answer Correct ? | 8 Yes | 4 No |
Answer / gopi
1NF: Eliminate duplicative columns from the same table and
create sepearate table for related group of data into
2NF: Remove and create sepearate table for common set of
data form multiple rows and create foregin key relationship
| Is This Answer Correct ? | 6 Yes | 3 No |
Answer / senthilkumar.a
FIRST normal form does not allow multi-valued attributes
which leads to the redundancy of data
SECOND normal form where EVERY non-prime attributes is
fully functionally dependent of ALL prime attributes
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / prabhu
to reduce the retundant column for that only we r using the
first normal form
create seperate table for not functionality dependent
on primary key this is 2nd normal form
| Is This Answer Correct ? | 3 Yes | 4 No |
t1 col1 col2 nishi 5000 lucky 6700 akash 7000 i want that a query that when i insert 7000 it will show me data already present and data will not insert. if data is not present it will insert.
How to convert characters to numbers in oracle?
How to do a full database export?
What is proxy method?
Describe the different type of Integrity Constraints supported by ORACLE ?
Preparing for Oracle PL/SQL Interviews – Need Help with Common Questions
What is a trigger and what are its types in oracle?
How are extents allocated to a segment?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
Does oracle charge for java?
What is the fastest query method to fetch data from the table?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
Oracle General 
