学生时间表中的可用时间 [英] available time in student schedule

问题描述

嗨 我有一个针对大学学生的小型日程安排系统
这个系统在asp.net
我想要一些有帮助的步骤，并指导我如何在每个学生时间表中找到可用的时间
根据空闲时间，我可以和他们开会.
这是数据库结构的一部分

教师表(包括有关他们的全部信息，例如ID，姓名，电子邮件…)
学生表(包括有关他们的完整信息，例如ID，姓名，级别…)
课程(teacher_id，课程名称和编号，开始时间，结束时间，section_no)

希望很清楚
在此先感谢您.

Hi I have small scheduling system for students in university
This sysem in asp.net
I want steps that help and guide me how can I find the available time in each student schedule
Based on the available time I can do the meeting with them
This is a part of the DB structre

Teacher’s table ( this consist of the whole info about them e.g ID,name ,email…)
Student’s table (this consist of the whole info about them e.g ID,name ,level …)
courses( teacher_id,courses name and number,begin_time,end_time,section_no )

hope that is clear
Thanks in advance.

推荐答案

这确实取决于您的数据库结构.您可以更新您的帖子并提供一些详细信息吗?不要发布答案-而是更新您现有的问题.

It really depends on your DB structure. Can you update your post and give some details on that too? Don''t post an answer - instead, update your existing question.

请一位编程课程讲师为您做这件事.

确定问题是成功的一半.在这一点上，设计和实现解决方案应该很容易，因为您是现有代码中的熟悉者，而不是我们.

但是，从编程角度来看，这是一个有趣的问题.困难的部分是确定白天有多少时间可用，以及是否有足够的时间进行所需的会议.您计划中的漏洞是假设学生除了上课时间(医生的约会，性别，办事等)之外没有其他事情.最简单的方法是在网站上发布您的日程安排，然后让学生选择日期/时间.这使您可以指定可用时间，并强迫学生选择适合自己日程的东西.

Have the one of the programming course instructors do it for you.

Identifying the problem is half the battle. Designing and implementing a solution should be easy at this point because you''re the one familiar witrh your existing code - not us.

It''s an interesting problem from a programming perspective, nonetheless. The hard part is determining what chunks of time are available during the day, and if any of them are long enough to conduct the desired meeting. The hole in your plan is assuming that the student isn''t somehow otherwise occupied by something other than in-class time (doctor''s appointment, sex, running errands, etc). The easiest thing to do is to post your schedule on the web site, and let the student pick a date/time. This lets you specify periods of availability, and forces the student to pick something appropriate for their schedule.

这篇关于学生时间表中的可用时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！