Given the below functional dependency, MedicineCode → (MedicineName,ShelfLife,Manufacturer,Dosage)
Which of the following statements is not known to be true?
A) MedicineCode is a determinant.
B) MedicineName is a determinant.
C) Manufacturer is functionally dependent on MedicineCode.
D) ShelfLife is functionally dependent on MedicineCode.
E) MedicineCode is a candidate key of the relation MEDICINE (MedicineName, ShelfLife, Manufacturer, Dosage, MedicineCode).

Question

Quizplus · Accepted Answer

Since MedicineName is not a determinant, it means that different medicines can have the same name but different codes, shelf lives, manufacturers, and dosages. Therefore, MedicineName alone cannot uniquely identify a medicine in the relation.

Given the Below Functional Dependency, MedicineCode → (MedicineName,ShelfLife,Manufacturer,Dosage)