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 ...
12th June 2009, 04:21 PM #1
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!
IDG Tech News
12th June 2009, 04:36 PM #2
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 ID, Goal ID, Score, Notes
Last edited by elsiegee40; 12th June 2009 at 04:42 PM.
Thanks to elsiegee40 from:
OutToLunch (12th June 2009)
12th June 2009, 04:44 PM #3
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...
Originally Posted by elsiegee40
Ended up with Student ID, Goal ID, Score1, Notes1, Score2, Notes2. Think that should still be the 'proper' way of doing it?
12th June 2009, 04:47 PM #4
The above would provide for the most extendable dataset but the frontend could be trickier because of it.
GoalID - Linked to GoalID in goals
StudentID - Linked to ID in Students
Set (1 or 2)
StudentID - linked
GoalID - linked
Last edited by SYNACK; 12th June 2009 at 04:49 PM.
Thanks to SYNACK from:
OutToLunch (12th June 2009)
12th June 2009, 04:51 PM #5
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 04:57 PM.
12th June 2009, 04:58 PM #6
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
Thanks to bossman from:
OutToLunch (15th June 2009)
By somabc in forum Jokes/Interweb Things
Last Post: 22nd September 2008, 02:58 PM
By Hightower in forum General Chat
Last Post: 16th June 2008, 05:22 PM
By amyr in forum General Chat
Last Post: 2nd February 2007, 07:24 PM
By Nij.UK in forum Jokes/Interweb Things
Last Post: 17th November 2006, 09:23 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)