please answer

Below we have a college enrolment table with columns s_id course and hobby s_id course hobby 1 Science Cricket Maths Hockey 1 2. 2 C# Cricket 2 Php Hockey As you can see in the table above, student with s_id 1 has opted for two courses, Science and Maths, and has two hobbies, Cricket and Hockey. You must be thinking what problem this can lead to, right? Well the two records for student with s_id 1, will give rise to two more records, as shown below, because for one student, two hobbies exists, hence along with both the courses, these hobbies should be specified. s_id course hobby 1 1 Science Maths Science Maths Cricket Hockey Hockey Cricket 1 1 And, in the table above, there is no relationship between the columns course and hobby. They are independent of each other. So there is multi-value dependency, which leads to un-necessary repetition of data and other anomalies as well. We can decompose the table into 2 tables. CourseOpted Table s id course 1 Science Maths 1 2 C# Php 2 And, Hobbies Table, s_id hobby 1 1 2 Cricket Hockey Cricket Hockey 2 N A table can also have functional dependency along with multi- valued dependency. In that case, the functionally dependent columns are moved in a separate table and the multi-valued dependent columns are moved to separate tables. Now this relation satisfies the: O Boyce and Codd Normal Form O Fourth Normal Form O Second Normal Form O Third Normal Form