How many tables should I have for a news site project?

[soche123]

Since there so many sections in news like national, international, sports, entertainment, business.

currently I have only two. One for categories which contains id,title and parent of category and other for news which has all the title, description,category,details, image and date.

will creating more tables for subsection like sports,national, international be a good move? What do you propose?

[JimL]

It’s a very bad move. Your db scheme is the way it should be now. Read up on database normalization for more info regarding (normal) db scheme layout

[astonecipher]

You could add another table for sections, but it depends what categories encompasses.