PatientDX

```
Name   Disease
Aa      HIV
Aba     DM
Bb      HT
Bb      DM
Aa      HT

```

I want to get patient names who have both HIV, DM or all diseases or something like that. I want to make analysis by disease checkboxes in UI. How can I do it? Is my table design bad? Could you suggest me a better way to achieve that? Disease names can be as many as 100. So, I want to make it easy to find out patients who have particular 3 diseases, 4 or 5 and so on. Thank you.