0

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

[U]WorkOrder[/U]
WorkOrderID
Submitted by
dateSubmitted 
DesiredcompletionDate
discription of task
schoolID
RoomNum
DateStarted
Datefinished
cost of materials
labor
overhead
completed by
completion comments
priorityid
budgetid
approved
approveddate
approved by
approvedcomments

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

3
Contributors
2
Replies
3
Views
8 Years
Discussion Span
Last Post by timothybard
0

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..

0

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

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.