I am in the process of building an app so a driving instructor can record students, lessons booked, transactions and student progress but also so the student can see their progress, details, transaction and lesson history. The problem is I am struggling to connect all the collections up together to work correctly.
The instructor needs to be able to create a student and be able to book in lessons for individual students. Also be able to log income and expenses and update student progress.
The student needs to be able to see their current progress, lessons due and history, transaction history and reflective logs.
An instructor can have unlimited students but a student can only have one instructor.
Here is a flowchart I quickly put together.
Any help is much appreciated.