I have to create database of student having different subjects and marks in respective subjects.
Now many students will many subjects so there is many to many relationship.
My database design:
(FK)Stud_id, Sub_id, Sub_name, Marks.
1) is this design is right or wrong?
2) Secondly i want to find name of the student who scored second highest marks.