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?