Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.
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).