Consider a relation dealing with majors (3 attributes) that respects these constraints: A student may have several majors and each major has many...

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 (write a table satisfying the constraint) What normal form* is this relation in?

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