[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
Re: Database schema [was: UU tools]
This is a different issue. I'd split it in two:
1) We need a problem_completion or similar table that shows problems of the student with their state.
2) Completing a problem switches it into read-only mode. I'm not 100% sure that this is unconditional, but it makes sense.
I can think of ether a trigger to achieve 2) upon problem completion, or a procedure "problem completed()" that does it for us. Actually, it may be a proc in both cases, and trigger may just call it..
2006/9/23, Ilya A. Volynets-Evenbakh <ilya@total-knowledge.com>:
There is another way - every time someone "passes" an object (meaning of
"pass" depends
on object type), there is a trail record left. I.E. if student solves a
problem - there is a record
in some table (user_problem_solutions?) that indicates when he solved
it, what his answer was,
what his score was, etc.
If someone passes a course, he also leaves such a trail. He just loses
access permissions once
he is done, and is not signed up any more.
Alexey Parshin wrote:
> Does it mean - we can always connect course and student through an ACL
> _only_? I.e. course_list_acl is the only connection between course and
> student? :
>
> Something like:
>
> SELECT *
> FROM person_list, course_list, course_list_acl
> WHERE
> pl_id = cla_person
> AND
> cl_id = cla_course
>
> (assuming that cla_* are the fields from course_list_acl)
>
--
Ilya A. Volynets-Evenbakh
Total Knowledge. CTO
http://www.total-knowledge.com
--
Alexey Parshin,
http://www.sptk.net