1. Consider a relation dealing with majors (3 attributes) th

1. Consider a relation dealing with majors (3 attributes) th

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