CrimpJiggler Posted February 26, 2013 Share Posted February 26, 2013 I have a database of chemicals. Some of the chemicals are drugs while others are solvents and different types of chemicals. For the drugs, I need to add a pharmacology field and a medicinal properties field but the other types of chemicals don't need this field. The other types of chemicals will need their own special fields too. Should I just add all these fields to the same table or is there a better way of doing it? For example, would it be better if I added a seperate table that holds all these special information fields? Quote Link to comment Share on other sites More sharing options...
trq Posted February 26, 2013 Share Posted February 26, 2013 Take a look into database normalisation techniques. Adding new fields is almost always not the right answer. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.