Relationships

[hithere]

I'm not sure where to put this so I'll try here

I'm having trouble defining my database or relationships. I have a grade book that tracks students, their courses and grades. One student can enroll in a course and receive several grades once they are enrolled in that class. I'm not quite sure what to do or how to set this up. I've attached what I hae thus far for analysis. Any suggestions would be great.

[ssanfu]

Take a look at this Microsoft A2003 template. It has an ugly interface (IMO), but you should look at the tables/relationships.

http://office.microsoft.com/en-us/templates/CT001143944.aspx?av=zac#ai:TC001018407|