1.      Consider a relation dealing with majors  (3 attributes) that respects these constraints:   ·        A student may have several majors and...

1.      Consider a relation dealing with majors  (3 attributes) that respects these constraints:

·        A student may have several majors and each major has many advisors.

·        An advisor may advise only one major.

·        For each major a student has, s/he may be advised by one advisor in that major.

Identify the key, FDs and populate the table with a few values. What normal form* is this relation in?

    If problem above is not in BCNF, transform it into BCNF and state FDs and key of the new relation(s).