A database schema that stores information about students, and courses is designed in the following manner:

Student$-$Course$($SSN$,$ QU$-$ID$,$ S$-$name, S$-$address, S$-$phone, semester, year, course$-$no$,$ c$-$title, c$-$hours, grade$)$

Where:

$-$ SNN or QU$-$ID uniquely identify the student details such as S$-$name, S$-$address and S$-$phone.

$-$ Course$-$no uniquely identifies course title $($c$-$title$)$ and credit$-$hours $($c$-$hours$).$

$-$ A course may be offered several times in different semesters and years.

$-$ A student can register several courses in one semester.

$-$ A course may have many students registered in it in a given semester.

$-$ We record$/$store information over multiple years and semesters.

$-$ A student may register the same course in different semesters $($i$.$e$.$ it is allowed for a student to repeat a course in different semesters$).$

$-$ A student cannot register the same course in the same semester more than one time.