Py学习  »  NoSql

我可以对学生出勤NoSQL数据库做哪些改进?

Fawzi Rifa'i • 4 年前 • 748 次点击  

我在为学生考勤系统设计一个NoSQL数据库,我希望你的建议,以改善它,因为我是新的领域。

我想问一个问题。特定学生的课程,2。特定班级的学生,3。在特定日期参加特定课程的学员,4。特定班级的特定学生的出勤和缺勤计数。

{
  "attendance" : {
    "CS 331" : {
      "7-3-2019" : {
        "2014901001" : true
      }
    }
  },
  "class" : {
    "class01" : {
      "id" : "CS 331",
      "name" : "Software Design",
      "students" : {
        "2014901001" : true
      }
    }
  },
  "classEnrollment" : {
    "CS 331" : {
      "2014901001" : {
        "absence" : 0,
        "attendant" : 1
      }
    }
  },
  "instructor" : {
    "instructor01" : {
      "id" : "01"
    }
  },
  "instructorEnrollment" : {
    "01" : {
      "CS 331" : true
    }
  },
  "student" : {
    "student01" : {
      "id" : "2014901001",
      "name" : "Paul Howard"
    }
  },
  "studentEnrollment" : {
    "2014901001" : {
      "CS 331" : true
    }
  }
}
Python社区是高质量的Python/Django开发社区
本文地址:http://www.python88.com/topic/49361
 
748 次点击  
文章 [ 1 ]  |  最新文章 4 年前
Ali Alp
Reply   •   1 楼
Ali Alp    5 年前

这就是我将为这样一个用户需求设计的

{
  "class_collection": {
    "documents": [
      {
        "id": "CS_331_2019_1",
        "type": "CS 331",
        "name": "Software Design",
        "enrolled_instructor": [
          "instructor_id_1"
        ],
        "enrolled_students": [
          {
            "id": "student_id_1",
            "absence": 0,
            "attendant": 2
          },
          {
            "id": "student_id_2",
            "absence": 2,
            "attendant": 3
          }
        ]
      }
    ]
  },
  "class_attendance_collection": {
    "documents": [
      {
        "2019-03-12T18:00:00": {
          "class_id": "CS_331_2019_1",
          "attended": ["student_id_1"],
          "not_attended": ["student_id_2"]
        }
      },
      {
        "2019-03-13T16:00:00": {
          "class_id": "CS_331_2019_1",
          "attended": ["student_id_1","student_id_2"]
        }
      }
    ]
  },
  "student_collection": {
    "documents": [
      {
        "id": "student_id_1",
        "name": "name_1"
      },
      {
        "id": "student_id_2",
        "name": "name_2"
      }
    ]
  },
  "instructor_collection": {
    "documents": [
      {
        "id": "instructor_id_1",
        "name": "name_1"
      },
      {
        "id": "instructor_id_2",
        "name": "name_2"
      }
    ]
  }
}

享受编码的乐趣:)