Consider the table: STUDENT (StudentNumber, StudentName, Dorm, RoomType, DormCost, 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. Transform this table into two or more tables such that each table is in BCNF and in 4NF. State the primary keys, candidate keys, foreign keys, and referential integrity constraints.