- #1
Shaitan00
- 18
- 0
I am trying to write the RELATIONAL ALGEBRA statement for a query defined as follows:
"Find the diseases for which there is only one medication"
I have a table TREATMENT with two attributes, DISEASE & MEDICATION
TREATMENT (disease, medication)
This table holds a list of diseases and corresponding medication, of course for each diseases that can potentially be multiple medications, and for some only one. For example assume you have something that resembles the following:
Disease | Medication
--------------------
FLU | med1
FLU | med2
CANCER | med3
HIV | med4
FLU | med5
In this case you would expect to get CANCER & HIV (as they only have 1 corresponding medication) whereas FLU would be excluded because it has 3... (etc...)
Any help would be greatly appreciated...
Thanks,
"Find the diseases for which there is only one medication"
I have a table TREATMENT with two attributes, DISEASE & MEDICATION
TREATMENT (disease, medication)
This table holds a list of diseases and corresponding medication, of course for each diseases that can potentially be multiple medications, and for some only one. For example assume you have something that resembles the following:
Disease | Medication
--------------------
FLU | med1
FLU | med2
CANCER | med3
HIV | med4
FLU | med5
In this case you would expect to get CANCER & HIV (as they only have 1 corresponding medication) whereas FLU would be excluded because it has 3... (etc...)
Any help would be greatly appreciated...
Thanks,
Last edited: