Solved Yearss

Can we see your modified version?

There are still things wrong which need to be resolved.
True. There is a problem with tblTeachers it says "related record in tbl teachers."
Just seeking advice.
What if I create a junction between tblTeachers and tbltermsubjects and also another junction between tblstudents and tblTeachers and tblDormitories.

Please advise.

Thanks in advance.
 
True. There is a problem with tblTeachers it says "related record in tbl teachers."
Just seeking advice.
What if I create a junction between tblTeachers and tbltermsubjects and also another junction between tblstudents and tblTeachers and tblDormitories.

Please advise.

Thanks in advance.
Upload the database so we can see
 
Junction tables are NOT optional. They are used whenever you have a many-many relationship. Can you have multiple teachers teaching the same subject during the same term? Yes, but I didn't see that as a possiblity given your last schema. Students do not have a direct relationship to teachers. Students relate to a class via a junction table and the class relates to a teacher. Students only live in ONE dormitory at a time so again, this is NOT a m-m relationship.

Relationships are not ARBITRARY. They model real life. They are what they are and if you use the wrong schema to represent them, you will not be representing reality.
Thanks @Pat Hartman
 
This is Pats database modified slightly to allow the following:

1. Select a specific Year
2. Select a specific Term
3. Select a specific Grade / Stream
4. Allows the display of a Number of Students for the Grade/Stream selected
5. On selection of a Student be able to specify the Subject and then add all relevant Weeks, Exam Types & Marks.

I would imagine there are errors.
This database works very fine. However, I want to create a main form from tblstudents and subforms being
1. frmStreamStudentssubform.
2. frmTermStreamssubform.
3. frmTermSubjectssubform.
4. frmSubjectExamWeekssubform.

Thanks in advance 🙏🙏🙏🙏🙏
 
Well I think you should be able to work this out from the examples given
 

Users who are viewing this thread

Back
Top Bottom