Can anyone please suggest me solution for this problem of database normalization ?
My problem is :
I have created one table named as student and one more table of BCS which contain attributes subject_id,subject_name so relation between student and BCS is many to many so how should I normalized it ? rather I want to ask which is the correct way to represent the tables.
I have created the table named as student_BCS_xref
student_BCS_xref(course_id(fk from Course Table),stud_id(fk from Student table),sub1,sub2,sub3,sub4).
something else which will make database more efficient.