Lesson plan
I'm doing a database to write what I teach in my lessons. I made a main table, with class / date and activities, connected with other tables, for example the theory table, which lists all the chapters. So I can see easily in the theory table what I already made, when, and in which class. The problem is: what should I do if in one lesson I will do more than one chapter?
8 replies
-
Because 1 lesson = 1 record
-
Hi
You've maybe got to have a 'Lesson Chapters' Table allowing you to have a many to many chapters per lesson?
Julian
-
Hello Micrologus. Have a look at this model:
https://www.dropbox.com/s/7ee9c4wov4dty5m/Lezioni.ninox?dl=0
Fabio
-
Thank You Fabio for your model! It's very interesting your solution.
My problem is that I would prefer to have only one record for each lesson, because I have different activities in my lessons: ear training, theory, singing etc. But perhaps it is not possible to have just one record for each lesson and a sort of "multi-field" for theory, singing (more songs) etc. This is my actual model (how I write it daily on paper): the advantage is that I can see "vertically" what I already made in each activity. But it were interesting if I could check in the Theory chapter list what I already made and with which class. But perhaps it's not possible :-)
-
Sorry for my english!
-
Hello. See if this gets closer to your needs :)
https://www.dropbox.com/s/mfotvoulr8zcgf2/Lezioni%20v2.ninox?dl=0
Fabio
-
Thank You Fabio! It's exactly what I need.
Now I have to understand how you did the relations between the tables, I will study your project carefully.
Best Regards and thanks again!
Matteo
-
You're welcome Matteo. I used a N:M relationship between tables ;). Have a look here:
https://ninoxdb.de/en/manual/tables/table-references-and-relations
Fabio
Content aside
- 5 yrs agoLast active
- 8Replies
- 1944Views