How to do Normalization? [closed]

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifyin开发者_StackOverflowg this question so that it can be reopened, visit the help center. Closed 11 years ago.

Hi i am new to this concept and i need your suggestion. i have an excel spreadsheet having about 35 columns and i have to create tables out of it. i have to draw an ER diagram but i dont know which should be the main table having foreign keys of all other tables or is there going to be one main table or multiple main tables?

---

Normalization is a database concept - it is all about removing redundancies from your data.

There are several different normalization forms, each building on top of the previous.

First normal form - each column in a table should only hold one value, so things like a comma separated list is a no no.

To be honest, the subject matter can get very complex - see this article on how to apply normalization to a table.