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 Get the mailserver that powers this list at http://www.coolfusion.com
