Table design and information normalization

P

pess

Joined
Aug 12, 2011
Messages
2
Reaction score
0
I have a table called “tblPARTS”. We keep all parts used by our company in this table. We categorize these parts using a field called “PART TYPE”. One of these part types is “PLANTS”. Although we need to treat plants as parts, we also need to add extra fields to this part type like “WATER REQUIREMENTS” which will be needed by installation team later. And because this extra field will be only applicable to “PLANT” type parts, I thought that I will need to create a new table “tblPLANTS”, then to transfer and synchronize all “PLANT” type parts in “tblPARTS” table with “tblPLANTS” table. This way if I need to process plant water requirements I will refer to “tblPLANTS” table, and if I want to add plants as parts I will use “tblPARTS” table. :sleep:



Is this information duplication? Is this an acceptable design? :confused:
 
Back
Top