No it's individual students with individual goals. Thanks- I figured it was the best way, but it's getting cold and rainy here and I think my brain is starting to hibernate for the winter... j
-----Original Message----- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 21, 2002 4:10 PM To: CF-Talk Subject: Re: OT: Database design question Janine Jakim wrote: > 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 Will students be cooperating on these goals and be graded together? If so, you actually have a many-to-many relationship. If not, your model is OK. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.