Hi

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).

or

something else which will make database more efficient.


Thanks in Advanced.

Nikhil Kulkarni