7. (10p) Assume every student has a unique SSN, and can apply multiple colleges and may have multiply hobbies. We will record college name high school students applied and their hobbies in table apply(SSN, cName, hobby) Attribute cName represents one of the colleges that the student apply, and attribute hobby represents one of the hobbies that the student has. a. Assume student SSN is 123, he/she applied 3 colleges(MTU, MIT, UMich), he/she likes to ski, swim and dance. How to represent those data in table apply? SSN cName hobby b. What is the key(s) for this relation? C. Is this relation BCNF? Why? If not, convert it to BCNF. d. Explain why the above relation apply(SSN, cName, hobby) is a bad design and how to fix it