what is your idea about this database design?

[ali1]

Hi all;

I appreciate that you write your idea for this db,is it correct?

magazine db design:
-one article can belong to many categories.
-one article can have null or many photos.
-one article can have null or many tags.

tb_categories|cat_id(pk) , catname , parent_id

tb_articles|article_id(pk) , title , subtitle , textbody , source_id , date , remark

tb_sources|source_id(pk) , sourcename

tb_phptos|photo_id(pk) , photofilename

tb_tags|tag_id(pk) , tagname

tb_articles_photo|article_id(fk) , photo_id(fk)

tb_articles_tags|article_id(fk) , tag_id(fk)

tb_articles_categories|article_id(fk) , cat_id(fk)

thanks