To refine a bit... STUDENT(student_id [PK], student_name, ...) GOAL(goal_id [PK], student_id [FK], goal_name, ...) GRADE(grade_id [PK], goal_id [FK], grading_period, grade)
This reflects the one-to-many relationships--- ** One student has many goals ** One goal has many grades ~Dina ----- Original Message ----- From: Bruce, Rodney S HQISEC/Veridian IT Services To: CF-Talk Sent: Thursday, November 21, 2002 3:34 PM Subject: RE: Database design question Janine one question: would the goals be the same for all the students? I would go with 3 tables 1. Student info 2. Goal info 3. link table with fk from student/goal tables and comments(grades) something like Table1 Studentid StudentName .... Table2 Goalid GoalName .... Table3 Studentid goalid period(date) Comments(grades) just my .02 -----Original Message----- From: Janine Jakim [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 21, 2002 1:59 PM To: CF-Talk Subject: OT: Database design question hmmm- I am very into keepting my database relational, but am wondering what the best route for thi particular issue is... Heres' the scoop 1. One student can be working on many goals so I have 1 one to many relationships. 2. Each goal needs graded every marking period (up to 6 times a year)- these are not traditioanl grades but a long comments piece) So goals have a one to many relationship with the grades. I'm thinking the best way to handle it is to break it into 3 tables table one student info table 2 all the goals for the students hooked to students with the studentid table 3 all the grades for the goals hooked to goals by goalID My other option is to have 2 tables table one student info table two goals + 6 grading periods comment sections Thanks in advance for any input. j ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
