S
shane
I'm working on getting my tables normalized and am working on definining a
primary key. Production works a 12hr rotating schedule so we have 4 shifts,
2 days and 2 nights (A, B, C, and D respectively). There are also 4
departments that will be entering information, where 2 of these departments
are broken down into cells of 4 lines each. Line numbers are always
associated with the same cell.
On the reports we want to combine data from each department by date, shift,
and cell.
After reading about normalizing I'm at odds with creating a primary key that
is not a multi-valued field. Any suggestions are greatly appreciated.
primary key. Production works a 12hr rotating schedule so we have 4 shifts,
2 days and 2 nights (A, B, C, and D respectively). There are also 4
departments that will be entering information, where 2 of these departments
are broken down into cells of 4 lines each. Line numbers are always
associated with the same cell.
On the reports we want to combine data from each department by date, shift,
and cell.
After reading about normalizing I'm at odds with creating a primary key that
is not a multi-valued field. Any suggestions are greatly appreciated.