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 the concept of normalization.

Answer Posted / nashiinformaticssolutions

Normalization is the process of organizing data to minimize redundancy and improve data integrity.
Normal Forms:
• 1NF: Eliminate repeating groups, ensure atomicity.
• 2NF: Ensure 1NF and remove partial dependencies.
• 3NF: Ensure 2NF and remove transitive dependencies.
• BCNF: Ensure every determinant is a candidate key.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention what is the function that is used to transfer a pl/sql table log to a database table?

990


how are mysql timestamps seen to a user? : Sql dba

1139


Is it possible to read/write files to-and-from PL/SQL?

1102


Is primary key is clustered index?

1002


what is an index? : Sql dba

995


What is flag in sql?

1032


Is sql a oracle?

979


Explain scalar functions in sql?

1066


How to get help at the sql prompt?

1114


What is cost in sql execution plan?

982


How many disk partitions should I have?

988


i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this

1582


Name the different types of indexes in sql and define them.

1151


How to add new employee details in an employee_details table with the following details

1091


What is mdf ldf and ndf?

1002