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).

Question

Quizplus · Accepted Answer

We cannot infer whether MedicineName is a determinant or not from the given functional dependency. Although MedicineName is listed as functional dependent, it may or may not be a determinant.

Given the Below Functional Dependency