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)

STUDENT (SID, Name, Dorm_No., DormType, DormCost, Club, Clubfee, ClubManager, Nickname) 

Answer rating: 100% (QA)

51 MultiValued Dependencies MVD are SIDClub SIDNickname 52 The functional dependencies according to ... View the full answer