0

In this SQL diagram, I have two medication tables. One medication table is for Mastitis disease treatment and the other medication table is for the treatment of other diseases. The fields are similar except for the foreign keys. Any advice on how to refactor the schema to remove redundancies? sql schema

fardown
  • 713
  • 2
  • 12
  • 23
  • 1
    Please [use text, not images/links, for text (including code, tables & ERDs)](https://meta.stackoverflow.com/q/285551/3404097). Use a link/image only for convenience to supplement text and/or for what cannot be given in text. And never give a diagram without a legend/key. – philipxy Dec 02 '18 at 03:18
  • It all depends on the `SELECTs` you will use. – Rick James Dec 02 '18 at 19:32
  • Is "mastitis" not a form of "problem"? – Rick James Dec 02 '18 at 19:33
  • Yes! Thanks for marking it as a duplicate question and pointing me to the right path. – fardown Dec 03 '18 at 11:21

0 Answers0