+ Post New Thread
Results 1 to 6 of 6
How do you do....it? Thread, Simple Database Design - Friday Afternoon Brain Meltdown in Technical; Trying to knock up (what should be) a very simple database in Access. Student name, class etc - each student ...
  1. #1

    Join Date
    Feb 2006
    Location
    Derbyshire
    Posts
    1,381
    Thank Post
    181
    Thanked 211 Times in 171 Posts
    Rep Power
    65

    Simple Database Design - Friday Afternoon Brain Meltdown

    Trying to knock up (what should be) a very simple database in Access. Student name, class etc - each student has an identical series of goals and two sets of scores plus associated notes for each. I think I'm either over or undercomplicating this, or my brain has just melted on a Friday afternoon. How many/what tables would you break this down into in Access if you were setting this up? I know it's going to be one of those kick yourself when somebody else points it out answers.

    Initially, I had a Student table and a ScoreSet1 and ScoreSet2 table but this only left me with 1 set of notes for each ScoreSetX and I need 1 set of notes for each goal. Redid this into a Goals, Student and Scores table but now staring blankly and forgetting how to link it all together so each student would have only 2 entries per 1 goal + notes entry. Doh!

  2. #2

    elsiegee40's Avatar
    Join Date
    Jan 2007
    Location
    Kent
    Posts
    9,982
    Thank Post
    1,852
    Thanked 2,295 Times in 1,694 Posts
    Rep Power
    818
    Basic tables:
    Class details - one row for each unique class
    Student details - one row for each unique student (and putting them in a class)
    Goal task details - one row for each unique goal task

    With appropriate links to tables above:
    Student-Goals
    Student ID, Goal ID, Score, Notes
    Last edited by elsiegee40; 12th June 2009 at 03:42 PM.

  3. Thanks to elsiegee40 from:

    OutToLunch (12th June 2009)

  4. #3

    Join Date
    Feb 2006
    Location
    Derbyshire
    Posts
    1,381
    Thank Post
    181
    Thanked 211 Times in 171 Posts
    Rep Power
    65
    Quote Originally Posted by elsiegee40 View Post
    Basic tables:
    Class details - one row for each unique class
    Student details - one row for each unique student (and putting them in a class)
    Goal task details - one row for each unique goal task

    With appropriate links to tables above:
    Student-Goals
    Student ID, Goal ID, Score, Notes
    I think that's where I'd just got to at the moment, except as each goal has 2 scores and 2 notes for it I'd lost myself again...

    Ended up with Student ID, Goal ID, Score1, Notes1, Score2, Notes2. Think that should still be the 'proper' way of doing it?

  5. #4

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    11,239
    Thank Post
    882
    Thanked 2,742 Times in 2,316 Posts
    Blog Entries
    11
    Rep Power
    784
    Code:
     
    Students:
    ID
    Name
    class
     
    Goals:
    ID
    Goal Name
     
    Marks:
    ID
    GoalID - Linked to GoalID in goals
    StudentID - Linked to ID in Students
    Set (1 or 2)
    Mark
     
    Notes:
    ID
    StudentID - linked
    GoalID - linked
    Note
    The above would provide for the most extendable dataset but the frontend could be trickier because of it.
    Last edited by SYNACK; 12th June 2009 at 03:49 PM.

  6. Thanks to SYNACK from:

    OutToLunch (12th June 2009)

  7. #5

    Join Date
    Feb 2006
    Location
    Derbyshire
    Posts
    1,381
    Thank Post
    181
    Thanked 211 Times in 171 Posts
    Rep Power
    65
    Yup, it's now the form design that now has me banging my head. Maybe I should leave it till Monday and hope my brain has defrosted/refrosted by then.

    Each of the goals must be displayed on the form for data entry, along with the note for the associated goal. It seems to have something else completely in mind for me at the moment when it tries to help out. Think I may need to send myself back to Northwind for a bit It would be a single very messy Excel spreadsheet but I'd rather give the staff something with a nice front end for data entry. I suppose I could do the same in Access but it seems to defeat the point when you know what a 'proper' database should look like and hate it when people call something they've knocked up in a spreadsheet a database...
    Last edited by OutToLunch; 12th June 2009 at 03:57 PM.

  8. #6

    bossman's Avatar
    Join Date
    Nov 2005
    Location
    England
    Posts
    3,962
    Thank Post
    1,208
    Thanked 1,074 Times in 765 Posts
    Rep Power
    332
    Use normalisation techniques to take it from 1st to third form using the rules governing normalisation.

    If you google normalisation then you should find something to help you.

    Have a good weekend

  9. Thanks to bossman from:

    OutToLunch (15th June 2009)

SHARE:
+ Post New Thread

Similar Threads

  1. [News] World Financial Meltdown
    By somabc in forum Jokes/Interweb Things
    Replies: 15
    Last Post: 22nd September 2008, 01:58 PM
  2. Database Design
    By Hightower in forum General Chat
    Replies: 6
    Last Post: 16th June 2008, 04:22 PM
  3. What an afternoon!
    By amyr in forum General Chat
    Replies: 37
    Last Post: 2nd February 2007, 06:24 PM
  4. This should kill some time on Friday Afternoon
    By Nij.UK in forum Jokes/Interweb Things
    Replies: 4
    Last Post: 17th November 2006, 08:23 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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