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

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

2057


15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2356


Explain the dml?

1051


List out the components of logical database structure of oracle database.

1095


how to make an oracle object

2396


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

2314


Explain about achiever in sql?

1086


How to display employee records who gets more salary than the average salary in the department?

1126


What is recovery manager(rman) backup in Oracle?

1231


How to create a new table in your schema?

1130


What do you mean by merge in oracle?

1029


What is max rowid in oracle?

1084


How to do a full database export?

1153


Why oracle is used?

1108


How to start a new transaction in oracle?

1136