I have a question about table design and normalization.
The table in questions is:


Is that table nomalized? or should i break it into two tables. One for all work orders and one for approved work orders that extends workorders and move all the info about approved work orders to the new table?

thanks

Are you repeating content? (Submitted by, Completed by, Approved by)

Normalization usually relates to multiple tables and duplication of data.

I would look at your "by", "comments" and any others you find to fit a pattern..

Strictly speaking, the table appears to be normalized since the fields with similar content is not the exact same content. However, I do like Stylish's recommendation.

I would recommend using a 'status' table, which has fields similar to the following:
ID, Status ID, Date, Status Updated By, Comments