what is the difference between first normal form & second
normal form?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you assign multiple query result rows to a variable?

551


Can we call procedure inside function in oracle?

612


What is catalog in Oracle?

652


What is the exact use of Collections?

1682


What happens to the current transaction if the session is ended?

527






How to apply filtering criteria at group level in oracle?

587


Calculate difference between 2 date / times in oracle sql?

572


What is the relationship among database, tablespace and data file?

542


What is a database table in oracle?

572


Explain a synonym?

606


What is oracle host variable?

535


What is truncate oracle?

533


How to export your connection information to a file?

597


What is the purpose of tables, private synonyms and public synonyms in Oracle?

591


What is an oracle tablespace?

608