Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2016
    Posts
    1

    Unanswered: design exams system

    Welcome
    I would like to design a school exams system and I would like to get advice about the number of tables and the type of relationships with each other . Please help

    picture Attache
    Attached Thumbnails Attached Thumbnails Exam.JPG  

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    495
    Provided Answers: 24
    Ive used:

    subjects table
    SubjectName key Geometry 101
    SubjGroup math

    Teachers tbl
    TeachID auto
    firstname
    lastname


    students table
    studentID auto
    firstname
    lastname
    schoolID

    ClassRoom tbl Geometry 101 for Fall 2015
    ClassRmID auto
    StartDate Fall 2015
    Subject Geometry 101
    TeachID
    Room


    ClassRoster table whos in the class room
    ClassRmID key
    StudentID key


    ClassWork tbl class work assigned
    WorkID auto
    ClassRmID
    TestType quiz,lab, homework
    AssignDate
    TotalPoints

    StudentClassWork tbl class work results /student
    WorkID
    studentID
    Grade
    Date


    Test tbl
    TestID
    TestName
    TestSubj
    WorkID

    TestQA tbl
    TestID
    Q#
    Question
    Answer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •