I need some help regarding the relationships, as I am badly stuck with them. As you can see in the attached picture, I am using composite keys to create the Relationship table, "REGISTERED_COURSES". From this table, I would like to create a relationship to another table, "ACADEMIC_RECS". I have added all three fields from the primary table to keep the one-to-one relationship between the two(which is actually what is required). But on the other hand, things have become ugly. As with the table, "ATTENDANCE", I only need the two fields, "CourseID" and "TraineeID", but not the "RegDate", as it is not related to the attendance table. If I do not add all three fields, the relationship between "REGISTERED_COURSES" and "ATTENDANCE" will become "Indeterminate". How can I resolve this issue(without adding surrogate keys). You can ask me for more information regarding my DB requirements if you need.
Thanks a million!
Hunain