Data Model Design This homework will focus on concepts related to the creation of a data model 2. Given the relation StudentEnrollment(id, name, major, mailboxNumber, courseNumber, semester,professor) abbreviated E(i, n, m, b, c, s, p) and the functional dependencies i -nm, ics nmp, cs -p, and mb-i (a) (2 points) What are the keys of the relation? b) point) This relation is not in BCNF. Why not? (c) (9 points) Decompose the relation into sub-relations that are in BCNF using the algorithm pre- sented in class. Use the first violating FD above as the starting point for your first decomposition Make sure you've listed any FDs that hold for your sub-relations. (d) (2 points) Which of the original FDs isn't preserved by your decomposition? How do you know? (e) (6 points) Decompose the original relation into sub-relations in 3NF, using the synthesis algorithm described in class