So i've come a long way in this database but I still have things I can't figure out. I'm attaching a copy of the offending database here.
Question 1) I need the _fkAssignmentID to populate in the StudentAssignments table when a new record is created but I can't figure out how to do it. As it is when I enter an assignment, I have to go in and manually add the correct ID.
2) I want to be able to chart AVG, MIN, MAX, STD, etc for specific course assignments.
3) The database does, at least at a base level, what I absolutely need at this point. But I want it to be a little more flexible for data analysis. Also, ideally I want to be able to run reports based on a specific class, specific student, or specific assignment.
Any help would be greatly appreciated.