I'm working on a site upgrade for a client. The site is already on Statamic, however, there is some additional functionality that the client wants on the site. My initial thoughts were that I'd add it directly into the current site, but I'm beginning to wonder how possible it even is.
The client is an elementary school, and they want an online grade book of sorts for the teachers & students to access. So far, I know that I can give each student & teacher an account, they can log in and see assignments (stored in a collection), and all is well. But how do I store the student's grades? Is there an easy way to do this that I'm missing? Basically, each assignment will have many students attached (one grade per student per attempt), and each student will have many assignments attached to them. This is a many-to-many relationship, and I can't think of a way to do this in Statamic.
Will I need to put together a traditional database after all, or is there a way to build this within Statamic?