Regarding to the Sql Server

Question

Hai Sir,

             I have a small requirement in my mini project,I am explaining in this post briefly.

                              I want to do the project on Internal Assessment System. In that I have  Course(B.TECH,B.E,MBA etc.),Department(CSE,ECE,IT etc.),Semester(I-I,I-II,II-I,II-II etc.),Subjects(OS,JAVA,EDC etc.).For that I want to calculate internal marks for every semester has 3 internals and assign every subject have three internals at every semester.

                              So,How can I choose tables in the Database?