We have to get a good first draft of our DB. Often, you'll have to create one from only a discussion with a client/product and this task is here to reflect this process.
What the project is ?
The project goal is to give an interface for lessons at THP. We have 2 persona:
Teachers: host there lessons and get feedback, either instantly or afterwards.
Students: participate to lessons and give feedback during the class.
We want:
The teacher must be able to create a class once and create a new instance of it each time he gives the same lesson;
A teacher must be able to invite anyone on a lesson;
A class should have a list of steps containing a title and a description (not too long);
A student will be able to tick a step for a lesson as soon as the notion is understood;
A student should be able to add a new question on a lesson;
A student should be able to vote for a question (but not more than once);
There must be only one table of users. A student and a teacher have this role depending on what they do for a particular lesson.
Must have
[ ] A database schema (if you don't have any preference to create it, draw.io work but is probably not optimal)
Why ?
We have to get a good first draft of our DB. Often, you'll have to create one from only a discussion with a client/product and this task is here to reflect this process.
What the project is ?
The project goal is to give an interface for lessons at THP. We have 2 persona:
We want:
Must have