which is best?? muliple table or single table??

Question

HI I am still confused that whether I need to use multiple table in a single database or single table in single database??

I do have near about 30 columns for one record.

Answer 1

That's going to be highly dependent on what kind of data you're storing, but it's quite common for databases to have multiple tables. Normalization is the term you want to search for and read up on.

When I say "what kind of data you're storing" I don't just mean in general terms like text vs. numeric data. It depends more on what specifically the table in your application represents. If you're storing Customer data and Product data in the same table, it almost certainly should be split into two tables (or possibly more). If all of your data can be described as one type, then it might be okay to have only one table.