Results 1 to 7 of 7
Thread: Represent database
Feb 5, 2011, 11:19 #1
- Join Date
- Feb 2011
- 0 Post(s)
- 0 Thread(s)
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.
Thanks in Advanced.