At 03:59 PM 11/21/2002 -0500, you wrote: >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.
I suspect this is a many to many relationship. Student Table (studentID, etc.. ) Goal Table (goalID, etc. ) Student_Goal Table (StudentGoalID, StudentID, GoalID ) Unless a goal can only be associated with a single student. >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 would probably do something like this: MarkingPeriod Table Grades ( GradeID, StudentGoalID, MarkingPeriodID, Comment ) >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 This is fine, assuming that a goal is truly unique to a student. -- Jeffry Houser | mailto:[EMAIL PROTECTED] DotComIt, Putting you on the web AIM: Reboog711 | Phone: 1-203-379-0773 -- My CFMX Book: <http://www.amazon.com/exec/obidos/ASIN/0072225564/instantcoldfu-20> My Books: http://www.instantcoldfusion.com My Band: http://www.farcryfly.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
