Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2009
    Posts
    1

    Unanswered: Help needed with Data Model

    Hi, I have a problem with a database that I am working on and would like to ask for assistance.

    I am trying to set up a database to hold the records of exam candidates. The candidate may need to take more than one exam and any examination may have more than one paper. The papers are all set for a specific data and time at a single examination center.

    I have set up 4 tables, Exam Center, Exams, Candidate and Timetable but I seem to be tying myself up in knots and can not get a sensible relationship to the candidate.

    I think the data looks normalised but that may be the real problem. Please see the attachment.

    I would welcome any assistance.

    Mark.
    Attached Thumbnails Attached Thumbnails Relationship Dia.jpg  

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    First, get rid of the timetable table, just put the date in the exams table. Then relate your exams to candidates with a M:M relationship.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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