The original table is
STU-Maj-Adv (SID, FID, Major)
FD: FID Major (each faculty specializes only one major)
(SID, Major) and (SID, FID) are all candidate keys (CK)
assuming a student can have multiple majors. A student can only have one faculty as his/her advisor for the major he/she chose.
an student normalized the following table and he/she got three solutions (a, b . c). Only one of them is correct. Identify the correct solution (note, fid is the ID of faculty advisor, sid is ID of student)
and give a detailed explanation of your choice.
a sm(sid, major), fm(fid,major)
b sm(sid, major), fs(fid, sid)
c fm(fid, major), fs(fid, sid)