I just realized now, in your example of the table in your first post. I didn't realized this until your latest post but, here's the table what it should look like which is what the group wanted to go with:
jobOrder :
{
jobId = 1, jobName = "Couch for Joe"
}
Parts {
partId = 1, jobId = 1, productId = 2, qty = 4
partId = 2, jobId = 1, productId = 2, qty = 1
partId = 3, jobId = 1, productId = 2, qty = 8
partId = 4, jobId = 1, productId = 2, qty = 1
}
Products {
productId = 1, productName = "3/4 inch steel caster"
productId = 2, productName = "Fluffy stuffing"
productId = 3, productName = "Framing wood"
productId = 4, productName = "Cloth covering"
}
The differences is that the productID in the parts table is all the same for each job order. That's too much redundency. I wanted to move the productID column into the job order table which will reduce the redundency. The business rule regarding job orders is that there is 1 product per job order, there can be more than 1 part per job order.
__________________
Looking out the window, that's an act of war. Staring at my shoes, that's an act of war. Committing an act of war? Oh you better believe that's an act of war
|