学校管理时间表数据库表 [英] database table for school management timetable

问题描述

我正在.net上使用C#.只告诉我数据库表将意味着时间表的属性或列名.

I am working on .net and using C#. Only tell me what will be the database table means attributes or column names for time table.

推荐答案

首先，应该有一个表，其中包含每日的详细信息.
我的意思应该是这样.
PID(PK)，日期，时间，期间编号，AssignTo(FK)(教师ID)

第二个表，其中包含教师大师.其中包含所有的老师.
TID(pk)，TeacherName

第三表.日程安排老师.
STID(pk)，日期，时间，PID(FK)，IsAvailable(布尔)

现在，首先，您必须制定程序将每天的时间分配给可用的老师.
之后，您必须检查哪些空闲时段?哪些是免费的老师，谁没有分配.然后您可以将免费时间分配给该免费教师.

希望您能有所了解.我刚刚在这里只取了3个交易表.但是根据要求，您必须进行更改.通过这个示例，我试图给您一些想法，如何设计表.

希望对您有所帮助.

谢谢，
Viprat

Hi,

Firstly there should be one table which contains the details of everyday periods.
I mean it should be like this.
PID(PK),Date, Time, PeriodNo, AssignTo(FK)(TeacherID)

Second Table Which contains Teacher Master. Which contains all the teachers.
TID(pk), TeacherName

Third Table. Schedule Teacher.
STID(pk), Date, time, PID(FK), IsAvailable(bool)

Now Firstly you have to make procedure to assign every day`s periods to available teachers.
After that you have to check that which are the free periods? and which are the free teachers, who are not assigned. and then you can assign that free periods to that free teachers.

I hope you will get some idea what you have to do. i have just taken here only 3 transaction table. But as per requirement you have to do changes. Using this example i am trying to give you some idea how can you design your tables.

I hope it might be help you.

Thanks,
Viprat

这篇关于学校管理时间表数据库表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！