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|c at_id(pk) , catname , parent_id

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

tb_sources|sour ce_id(pk) , sourcename

tb_phptos|photo _id(pk) , photofilename

tb_tags|tag_id( pk) , tagname

tb_articles_pho to|article_id(f k) , photo_id(fk)

tb_articles_tag s|article_id(fk ) , tag_id(fk)

tb_articles_cat egories|article _id(fk) , cat_id(fk)

thanks