Hello, maybe somebody can help me, what kind of relationship i need to create so under my Students Classes i will have Grades posted for the Classes ? in other words connection between Student-Classes-Grades
Does every student take every class? If not, then a different relationship would be needed. If they do, just combine the grades into the classes table and record them there.
I tend to have a JOIN table ('registrations') that has relationship to the student and the class. The grade for that particular registration (by date) is in that join table.
STUDENTS::StudentID_pk = registrations::StudentID_fk
registration::ClassID_fk = CLASSES::ClassID_pk
registrations then also may have these fields: RegistrationID_pk, Date, Grade, Term, Location and anything unique about this student in this class at that point in time.
This is a handy table from which to report as well, because of the relationships, you can show the Student Name, Class Name in the report.
No, student take different classes, the only connection i can make to be unique is Student Last/First name and Class event ID/Sub event but i am getting a random Grades for some reason
we've moved from old registration software and we had 3 exports from it Student, Classes and Grade, so i cannot combine them now in excel, ive tried to connect from Student table (First and Last name) and from Classes (Event Id and sub event Id) to Grades, but still doesnt work. is there are a problem in 1-to many relationship that missing? i am pretty new in FM
Perhaps we need to see the column headers for these Excel files (data not needed)? Can you post screenshot or the title rows of each file only?
I've attached the pictures
Beverly is right, you really need a join table that sits between the students and classes. We have a solution that we built for a driving school and with the join table, I can track any number of students and classes, and the join table tracks their selections and their grades. This is what it looks like:
You may need to import different columns into different tables, depending on how it's all organized, I'm uncertain how the event and sub-event IDs might be used. You should have a primary key field on each table that you can link to that can't be changed and sits above (if you will) the data to which the user has access. This way a link can be created that won't change when the user changes the data (e.g. last name). Creating a Last/First key won't work if there are two John Browns in the system. Either use a serial number or UUID for the value. The reason you're seeing random grades is that there is no relationship from the student to the grade. You have a relationship to the course that they took, but nothing links that person to the grade.
Looks like Class has unique id and unique sub ID, class id is for Class but sub id is semester was running, they unique only when are together
ok, i will check if i can export grades with student id, if i will be able to do that, then then from Student or Class i connect student id to Grade?
like on the picture?
I would still put the grades in the middle. Not sure what the data looks like, in particular if the Event/SubEvent is a unique combination. The grades are related to the student, not the class. Again, depending what the actual data is, the same student couldn't take the class twice, or at least you wouldn't be able to show the two grades they earned.
The ability of a student to repeat a class should be allowed for. I'm sure that's why Beverly suggested that the join table (AKA merge, link, or bridge table) should include "Date, Grade, Term, Location and anything unique about this student in this class at that point in time." If you follow this wise advice, you can specify that the join table should be sorted in reverse chronological order (that is, most recent record on top) when viewed from either the "Students" or "Classes" table.
Ditto! The grades in the middle as a JOIN file.
Retrieving data ...