Results 1 to 5 of 5
  1. #1
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051

    Pupil skills DB

    Having real problems with a design for this one. Hoping for a few ideas....



    My students (60) sit at least 20 exam papers as they approach their final exam.

    Each paper has about 20 questions covering 1 topic and each question may be out of anything up to 5 marks

    If a pupil gets 1/5 on a question his mastery of that particular topic is 20%

    I envisage being able to provide students with a list of topics which they've mastered (and those that they haven't) in the run up to their final exam.

    I initially thought

    tbl1Paper
    ExamID
    Q1topic
    q2topic
    and so on



    tbl1topics
    topic ID
    Topicname

    tblstudent
    studentID
    studentname
    etc


    But this stores topics in two separate places and currently doesn't store what each question is out of

    I cant see a better way round it.

    Any thoughts would be more than welcome.

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    you also need tStudentPapers table
    ExamID
    StudentID
    DateTaken
    Score

  3. #3
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    thanks Ranman. But that still means I have topics in two tables (hardly normalised I thought) unless I have 20 Foreign Keys.

  4. #4
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    TTopics is for singular topics names to pick.
    tPaper is an exam with a collection of topics from tTopics.
    Good normalization.

  5. #5
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    no, you don't get 20 keys.
    there is 1 topic source. tTopics.
    all others are FK to tTopics.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 09-09-2015, 11:24 PM
  2. Mentor Mentee skills matching
    By yraza in forum Queries
    Replies: 2
    Last Post: 04-21-2014, 02:35 PM
  3. CRUD application and VBA skills
    By adeling in forum Access
    Replies: 4
    Last Post: 11-07-2013, 02:42 PM
  4. Need help designing a simple Skills/Training Matrix
    By RoyLittle0 in forum Database Design
    Replies: 5
    Last Post: 02-06-2013, 05:19 PM
  5. Query to match job and client skills?
    By kbp in forum Access
    Replies: 5
    Last Post: 01-27-2011, 05:15 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums