Member Avatar for tornatom

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
  • 112 Views
  • 8 Hours Discussion Span
  • Latest Post Latest Post by timothybard
Member Avatar for Stylish

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

Member Avatar for timothybard

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.