Consider the table:

STUDENT $($StudentNumber$,$ StudentName, Dorm, RoomType, DormCount, Club, ClubCost, Sibling, Nickname$)$

Assume that students pay different dorm costs depending on the type of room they have but that all members of a club pay the same cost. Assume that

students can have multiple nicknames.

State any multivalued dependencies in STUDENT.

State the functional dependencies in STUDENT.

Transform this table into two or more tables such that each table is in BCNF and in $4$NF$.$ State the primary keys, candidate keys, foreign keys, and

referential integrity constraints.