5. Consider the table: STUDENT (SID, Name, Dorm_No., Dorm Type, DormCost, Club, Clubfee, Club Manager, Nickname) Assume that students pay different dorm costs, depending on the type of room they live in. A student can join many clubs. Each club has a manager. All members of a club pay the same club fee. Assume that a student can have multiple nicknames. 51. List any Multi-Valued Dependencies (MVD). (note, MDV: X Y means when a value of x is given there are multiple values of y to associate with that value of x. Use double arrowheads for MVD. Refer to text for more examples of Multivalued Dependencies) 52. List the functional dependencies based on given information. 53. Normalize STUDENT table into a set of tables such that each table after normalization is in at least 3NF. (Don't forget to indicate the primary keys and foreign keys in the results). 54. Draw an ER model based on the tables after normalization (Note: This is a reverse engineering that convert a set of tables back to an ER diagram). 6 Show an example of table (with business meaning) that is in 3NF, but not in BCNF. Give explanation of your example. Don't use the example discussed in text or in class. Note, to show such as table you need to indicate candidate key(s) and all FDs. 7. Briefly describe the situation where denormalization is needed (show an example). (there is a section in text about this concept)