Table Desgin

Expand Post »

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

WorkOrder
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

tornatom

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Apr 2009

Permalink

Apr 1st, 2009

Re: Table Desgin

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

Stylish

Reputation Points: 44

Solved Threads: 19

Junior Poster

Offline

148 posts
since May 2007

Permalink

Apr 1st, 2009

Re: Table Desgin

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

timothybard

Reputation Points: 27

Solved Threads: 29

Posting Whiz

Offline

317 posts
since Mar 2007

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Database Design Forum Timeline: Loans payment ER

Next Thread in Database Design Forum Timeline: College Assignment

DaniWeb Message

Cancel Changes

User Name
Password