Use the following information to answer the questions below...

7.0 Consider the following relation RM- DORM- STU- NBR STU- NAME DORM TYPE COST CLUB CLUB_COST 700 500 800 1172 Black Yellow 2 BED 450 250 500 400 750 Tech MKT FIN ACC FIN ACC MKT Tech 25 30 30 40 30 40 30 25 1111 Smith Rose IBED 1114 Smith Rose 2 BED 1152 Johnson Yellow I BED 1190 Owens Red 3 Beds 1200 HoweRed 2 BED 1300 Furner Blue 3 Beds 1400 FanGreen IBED Assume that students pay different dorm costs, depending on the type of room they have, but that all members of a club pay the different cost. a. State the functional dependencies. b. Transform this table into two or more tables such that each table is in State the primary keys, candidate keys, foreign keys, and referential integrity constraints