Table Relationship problem, urgent Help needed!

[BillyDropscone]

I am currently trying to put together a school register database and am confused on my Relationships, I feel like it has become too messy and cumbersome, could anyone look at what I have so far and point me in the right direction. I would be eternally grateful!relationships.zip

[orange]

Do you have a list of requirements and/or business rules that you used to construct your tables and relationships?
It is the business rules that you represent with relationships among/between tables. Without business rules or requirements, one can only guess at whether or not your model represents the business adequately.

[ranman256]

you basically ONLY need relationships on Parent & child tables.
like parent t.Student
child: t.ClassesEntrolled

reference tables dont really need it.

[mike60smart]

None of your Relationships are correct.
You should Enforce Referential Integrity between related tables.

[orange]

Here is a student roster data model from Barry Williams' site (no longer online). It may give you some insight on tables and relationships. The model identifies entities/attributes and relationships in a typical :StudentClassesTeachersAttendance scenario.
It should give a good starting point and can be appended to, edited... as your needs dictate.