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

What is a trigger oracle?

1072


What is an oracle recycle bin?

978


How are extents allocated to a segment?

1106


What is the Tune Query

2268


How to save query output to a local file?

1004


What is the fastest query method to fetch data from the table?

1343


Which are the five query types available in oracle?

934


How would you begin to troubleshoot an ORA-3113 error?

2066


What is the parameter mode that can be passed to a procedure?

1021


Explain do view contain data?

986


How to start your 10g xe server from command line?

1055


What are triggers in oracle?

1009


Design database draw er diagram for a certain scenario ?

4562


when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1983


What is oracle sid?

939