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

Answer / nagulmeera

first normol form contain multi valued attribute.

in second normal form contain partially depended on non key
attribute

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.)

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.

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.

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"

Answer / manoj gogoi

1NF: NO duplicate records.

2NF: No composite primary key

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

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

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

How to write a left outer join with the where clause in oracle?

0 Answers  

why can't we assign not null constraint as table level constraint

3 Answers   CTS, Wipro,

what is meant by magic query

0 Answers  

How to manage transaction isolation level?

0 Answers  

What is Partitions in Table ?

2 Answers   Atiric Software,

if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.

1 Answers   MasterCard,

18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client <clientno> has placed orders to the value of <total value>

2 Answers   Wipro,

What are the advantages of oracle 12c?

0 Answers  

how to genarate random numbers in oracle for particular row?

3 Answers  

What is a read only transaction in oracle?

0 Answers  

what is the syntax of DELETE command?

8 Answers  

What are the four Oracle system processes that must always be up and running for the database to be useable?

0 Answers