Home Projects Jobs Clientele Contact


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: UU database: problem tables

Alexey Parshin wrote:
> Actually,
> I expected that single problem may be  offered to many students, and
> every student may have personal solution with personal access and
> personal status.
That is correct. However, status is not part of ACL entry. That is why
they have to be separate
tables. Basically status may stay (i.e. for scoring purposes) even after
student loses any access
to the problem.
> Also, I suspect that status may be a part of many other ACL entries.
> In any given case, what entities need ACL but still not covered with
> ACL yet?
> 2006/9/26, Ilya A. Volynets-Evenbakh <ilya@total-knowledge.com
> <mailto:ilya@total-knowledge.com>>:
>     Looking at latest database diagram.
>     Wouldn't it make sense to combine topic_problems and problem_solutions
>     tables?
>     One problem - one solution after all...
>     Another thing (which sort of derives from this): there is no real
>     person_solution_ACL.
>     It's just person_problem_solutions in this case, and it contains
>     info on
>     how the person
>     solved the problem, not on their access to it (there still will be
>     person_problem_acl, that
>     shows access of given person to given problem).
>     --
>     Ilya A. Volynets-Evenbakh
>     Total Knowledge. CTO
>     http://www.total-knowledge.com
> -- 
> Alexey Parshin,
> http://www.sptk.net 

Ilya A. Volynets-Evenbakh
Total Knowledge. CTO

Authoright © Total Knowledge: 2001-2008