如何控制数据库中学生的成绩?

此问题是转发器此处，但我对问题的描述不好，所以请耐心等待我，因为我像学生一样需要这个系统:(

This question is repeater here but my bad with description of question so bear with me, cuz I need this system so much as a student :(

我有使用Laravel建立大学的系统，以及带有科目名称的学生分数的系统.

I have system for my university build with Laravel, for students' marks with names of subjects.

系统如下:

我们都知道每所大学都设有部门(例如IT，会计等). 每个部分包含四个阶段.

We all know each university contains departments e.g ( IT , Accountant etc .. ) and each section contains Four stages.

我们一年还有两个学期，每个学期都有新科目，每个学生都有他的分数.

Also we have two semester for year, each semester contains new subjects with his mark for each student.

当然，有仪表板供经理人添加每个学生的主题和分数.

Of course there is Dashboard for manager people to add the subject and the marks for each student.

然后系统的结果将是(frontend):一次输入，当任何学生输入他的id并单击enter时，它将向我显示他所有的学科以及整个学年和学期的分数.

And The result of system will be ( frontend ): One input, when any student enter his id and click enter will show to me all his subject and the marks for all year and semester.

现在我仍然在那里:

• 学生(id-名称-Department_id-stage_id-日期)
• 部门(id-名称-日期)
• 阶段(id-名称-日期)

我的成绩表问题！怎么做呢? :(

My problem with the marks table! How can make it? :(

在最后一个问题中，有一个我表示敬意的人 Ruhith Udakara 给我这个答案:

In last question some one with all my respect Ruhith Udakara give me this answer:

现在我需要数据库的最佳设计，因为如果我能进行良好的设计，那么其他事情对我来说将变得很容易.

And now I need the best design for my database because if I reach to good design the rest of other things will be easy for me.

谢谢.