Re: Advice on proper normalization
With 70 separate attributes, the JOIN would almost certainly reach a limit if you had 70 different attribute tables. Using an object table as the parent and an enumeration table of each attribute's name (or code) and value, you can have 1000 distinct attributes. The mental image is harder but has fewer limits.
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.