Jump to content

is this normalize?


dvayne

Recommended Posts

i guess you are talking about the levels of normalization a table goes thru in developing your tables?

the higher the level the less the redundancy in the tables. here you have author twice.

continue to take out the redundant fields from your tables, and have foreign keys in all your tables that

relate to one another. so briefly, i think not.

 

Link to comment
https://forums.phpfreaks.com/topic/97878-is-this-normalize/#findComment-500820
Share on other sites

Without actually knowing what the table names are (and what you're intending to store) it's difficult to say whether it's normalised or not. At a guess I would say your first table is for "posts" and your 2nd for "comments" seeing as the comments appear to be linked to the posts via the "post" field in the 2nd table.

 

Without a doubt, normalise that author field. Also consider normalising the "status" of the post to a "statuses" table. This way you can add further statuses in the future should the need arise. Also, if you're planning on making people register before allowing comments then it would seem wise to normalise the mail/siteurl along with the author, however I know that anonymous posting is allowed on a lot of blogs today, so they may actually not need normalising at all.

Posts should definitely have a normalised author. I would imagine people have to sign up to post in the first place...

Link to comment
https://forums.phpfreaks.com/topic/97878-is-this-normalize/#findComment-501075
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.