TalkPHP - View Single Post - DC

bdm · 12-11-2007, 02:01 AM

Is it just me, or is that database not normalized?

If I'm thinking this right, from the users table, rank should be in its own lookup table. The best sign that your tables aren't normalized is when you start putting 1-2 at the end of your column names.

From the tutorials table, status should probably also go in its own lookup table. Also, the status field for both recipes and comments table should go in its own lookup table.

Also, it probably wouldn't be a bad idea to draw out an ERD (Entity Relationship Diagram) to visually see the relationship between each table (if any).

You could also most likely get away with using a tinyint as your category id unless you are expecting 127+ categories (http://dev.mysql.com/doc/refman/5.0/...ric-types.html)

Can someone clarify anything I've been saying? I'm no MySQL guru by any means.

@macov: Why do you think the users IP will change everything they log in?

12-11-2007, 02:01 AM	#6 (permalink)
bdm The Acquainted Join Date: Nov 2007 Posts: 127 Thanks: 14	Is it just me, or is that database not normalized? If I'm thinking this right, from the users table, rank should be in its own lookup table. The best sign that your tables aren't normalized is when you start putting 1-2 at the end of your column names. From the tutorials table, status should probably also go in its own lookup table. Also, the status field for both recipes and comments table should go in its own lookup table. Also, it probably wouldn't be a bad idea to draw out an ERD (Entity Relationship Diagram) to visually see the relationship between each table (if any). You could also most likely get away with using a tinyint as your category id unless you are expecting 127+ categories (http://dev.mysql.com/doc/refman/5.0/...ric-types.html) Can someone clarify anything I've been saying? I'm no MySQL guru by any means. @macov: Why do you think the users IP will change everything they log in?