帮助设计学校管理系统的数据库
你好，我即将创建一个学校管理系统，它应该确保教师、课程、班级、家长、学生、成绩单、入学、管理、出勤之间的关系......
关于数据库结构和系统的一些好主意将受到赞赏。
Hello I'm about to create a school management system where it should assure the relashionship between teachers, courses, classes, parents, students, report card, enrollment, administration, attendence ...
Some good ideas on the DB structure and the system will be appreciated.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（4）
我认为他们正确的关键是如何随着时间的推移存储信息。
设置数据库模式
例如，您不能仅使用Class ----- StudentClass ----- Student
，因为诸如“11 年级科学班”之类的班级每个学期都会有不同的学生入学人数。所以每个课程都需要链接到一个学期。链接到学期，以便您可以查看 2010 年或 2011 年等哪些学生在 11 年级学习科学。
同样适用于学生的状态，他们目前是否就读？大部分工作都是围绕跟踪对象随时间的状态而变化的。
如何归档取决于您以及您希望如何使用这些数据？您想将其存储为 3NF 吗？
I think they key thing to get correct is how the information is stored over TIME.
For example you cannot just set up a DB schema with
Class ----- StudentClass ----- Student
Because a class such as - 'Year 11 Science class' will have different intakes of students each semster. So each class needs to link to a semester. Linking to semester so you can see which students where in Year 11 Science in 2010 or in 2011 etc.
Same applies for Status of students are they currently enrolled or not? Most of the work is around traking the state of objects over time.
How you go about archiving this is up to you and how you want to use the data? Do you want to store it as in 3NF?
来自数据库答案（众多答案之一）
数据库模型是独立于引擎的。 RDBMS 风格对于实施很重要
From Database Answers (one of very many)
DB model is engine independent. RDBMS flavour matters for implementation
您可以考虑查看 http://open-school.org/ 现有的开源解决方案，并查看它处理的事情种类繁多，然后看看您是否还有额外的事情需要处理。
You could consider looking at http://open-school.org/ for an existing open source solution and see the kinds of things it handles, then see if you have extra things to handle.
有一个名为 BANNER 的应用程序，用于处理一所小型大学的管理。它几乎包含了所有内容。它是基于 Oracle 的。如果你能得到它的描述，你可能会得到一些指示。
我看到您已经获得了数据库答案的指针。多好的资源啊！
There's an application called BANNER that deals with the administration of a small college. It's got just about everything in it. It's Oracle based. If you can get a description of it, you might pick up a few pointers.
I see you already got the pointer to Database Answers. What a good resource!