I need to create a db from a very large excel spreadsheet (currently
180 rows, and 2 columns for each day of the week)
Ea day there will be 5 entries (one for each plant) for all values in
the "common table". In addition each plant has to enter info based on
the process that they run; eg Fla (plant) my run 4 different processes
(process tableis in the tblManuf)
My question is what type of relationship do I need? Many to many? also
don't I want the ID value from each table to be stored in the table of
the other, so I know how to bring it all back together? (Ignore the
use of # in the field types) Any techniques for db normalization?
180 rows, and 2 columns for each day of the week)
Ea day there will be 5 entries (one for each plant) for all values in
the "common table". In addition each plant has to enter info based on
the process that they run; eg Fla (plant) my run 4 different processes
(process tableis in the tblManuf)
My question is what type of relationship do I need? Many to many? also
don't I want the ID value from each table to be stored in the table of
the other, so I know how to bring it all back together? (Ignore the
use of # in the field types) Any techniques for db normalization?