Home Projects Jobs Clientele Contact


[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:
> FROM person_list, course_list, course_list_acl
>    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

Alexey Parshin,

Authoright © Total Knowledge: 2001-2008