Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

Explain 1st, 2nd, 3rd normalization form of data base

Answer Posted / padma

1st normal form: first identify the repeating group of
fields n group them into separate table
2nd normal: it should be in 1st normal form and check all
fields are dependent on primary key
3nd normal form: it should be in 2nd normal form and check
all the fields r independent of any other non-key attribute
ie removes the fields that dependent on non-key

1st normal: first identify repeating fields and group them
another table
2nd normal: it should be in 1st normal form and identify
that all fields all dependent on primary key.
3nd normal: it should be in 2nd normal form and check all
fields all indpendent of other non-key attribute

Is This Answer Correct ?    49 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2422


What is the usage of control file in oracle?

1141


How to use "out" parameter properly?

1119


How do you bind variables in oracle?

1017


What are the arithmetic operations?

1146


Can we create trigger on materialized view in oracle?

1040


Give the various rollback segment states.

1083


What is the difference between translate and replace in oracle?

1214


How to drop an index?

1010


21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2165


What is the difference between hot backup and cold backup in oracle?

1074


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

1033


What are the original export and import utilities?

1253


What suggestions do you have to reduce the network traffic?

1018


What are the types of partitions in oracle?

1076