Home Projects Jobs Clientele Contact


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

Re: Latest DB schema

Things I missed (didn't notice):

1. We should handle multiple options for the solution control type. For
example, solution control "Multiple Choice" may be
 1. Single Answer
 2. Multiple answer
   a) Multiple answer control "All"
   b) Multiple answer control "Any"

2. study_problems_content field spc_text should be "text" type not "int"

3. I don't see prefered_language field in person_list.

Also, what if student submits a problem solution in his prefered
language(if several problem translations available), but teacher's
prefered language is different from student's?

> I have made some changes in the database. All of them are trying to define
> our approach to solutions.
> Now solution structure includes an extra table, solution_signature.
> The solution itself got a new field, ps_grade.

> --
> Alexey Parshin,
> http://www.sptk.net

Authoright © Total Knowledge: 2001-2008