如何设计考勤数据库 [英] how to design attendance database

问题描述

我正在做大学生考勤系统的项目。每个教师最多可以有4个科目，大约有36个科目。老师每天登录到那里，每天都要加入他/她的科目。我可以设计数据库为此，我应该创建哪些表？

i am doing project on college student attendance system.each teacher can have maximum 4 subjects and there are around 36 subjects.each teacher log in to there account and add attendance of his/her subject every day.how can i design database for this,what tables should i create?

推荐答案

从需求收集和分析开始，与用户一起查找，除其他外，

1.涉及的人员和内容：教师，学生，主题等=>实体

2.他们的关系是什么：例如每个老师都可以教多个科目，每个老师都可以教许多学生等等=>关系

3.他们捕获的数据，他们目前用于完成这项工作的任何系统，文件（表格，信件）？ =>显示数据属性和现有工作流程。

4.还有什么其他要求。

这里不可能解释数据库的设计，你可以参考数据库设计简介 [ ^ ]。这是一个试验和错误的问题，但你通过更多练习会变得更好。始终与用户一起完成您的设计，直到他们满意为止。

Start with requirements gathering and analysis with the users to find out, among other things,
1. Who and What are involved: Teacher, Student, Subject, etc => Entities
2. What are their relationships: e.g. every teacher can teach multiple subject, every teacher can teacher many students, etc => Relationship
3. What data do they capture, any system, documents (forms, letters) they use to do this job currently? => Reveal data attributes and existing work flow.
4. What are other other requirements.
It is impossible to explain the design of a database here, you may refer to Introduction to database design[^]. It is a matter of trials and errors, but you get better with more practice. Always go through your design with the users until they are satisfied.

1。教师

2.学生

3.科目

4. SubjectByTeacher（TeacherId，SubjectId）

1. Teachers
2. Students
3. Subjects
4. SubjectByTeacher (TeacherId, SubjectId)

为教师，学生，科目等创建一个主表.u可以使用id连接每个表不使用名称。



例如：



主题主表：

Create a master table for both like teachers,students,subjects,etc.u can use id for concatenation for each table don't use name.

Eg:

Subject master table:

Id        Subject
--        -------
1         English
2         Maths

教师主表：

Teacher master table:

Id        Teacher_Name
--        ----------
1         Sruthy
2         Sreelakshmi

学生主表：

Students master table:

Id        Students_Name
--        ------
1         Vimal
2         Tadit

这篇关于如何设计考勤数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！