Question

Given the below functional dependency, MedicineCode → (MedicineName, ShelfLife, Manufacturer, Dosage), which of the following statements is not known to be true?

a. Manufacturer is functionally dependent on MedicineCode.
b. MedicineCode is a determinant.
c. MedicineCode is a candidate key of the relation MEDICINE (MedicineName, ShelfLife, Manufacturer, Dosage).
d. MedicineName is a determinant.
e. ShelfLife is functionally dependent on MedicineCode.

Answer 1

Option (d).

Step-by-step explanation:

Medicine code are used for the determination and identification of a particular medicine. The drug system and active ingredient can be easily classified by the medicine code.

Medicine code includes the manufacturer, dosage, shelf life and medicine name. The medicine name can not be treated as a determinant because it cannot affect its nature.

Thus, the correct answer is option (d).