dvayne Posted March 25, 2008 Share Posted March 25, 2008 Quote Link to comment Share on other sites More sharing options...
eddierosenthal Posted March 25, 2008 Share Posted March 25, 2008 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. Quote Link to comment Share on other sites More sharing options...
teng84 Posted March 25, 2008 Share Posted March 25, 2008 i believe that is not normalize you have author on each table better to have only one and only id then relate them.... Quote Link to comment Share on other sites More sharing options...
aschk Posted March 26, 2008 Share Posted March 26, 2008 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... Quote Link to comment Share on other sites More sharing options...
Barand Posted March 26, 2008 Share Posted March 26, 2008 You need to question every column. For example, is "mail" dependent on the "author"? If it is, it belongs in an author table Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.