118 reputation
4
bio website
location
age
visits member for 1 year, 11 months
seen May 23 at 16:49

Apr
13
asked Table join inheritance
Nov
9
awarded  Scholar
Nov
9
accepted Save history editable data RDBMS
Nov
6
comment Save history editable data RDBMS
Not really. The history of the data is required to support a petition functionality. Students get the latest versions of tests. Some time after the test has been completed a user might submit a petition to disagree with results, however the test could have been changed a number of times since then.
Nov
6
comment Save history editable data RDBMS
In my shema of db I try to make AnswerNodifLog Table and QuestionModifLog, and when student want to see passed test I get all modifications with this test as delete question, edit answer, and do it in business logic. How do you think it's better idea or you prefer yours?
Nov
6
comment Save history editable data RDBMS
Ok, but it means that after every edit size of tables with tests, questions and answers will increase. And If I decide edit just in one test text of one question 7 times I 'll get 1 duplicate test records (nothing worth), 7*count qestions in this test( for example 7*20=140 after 8th edit 160) And if every question has for example 4 variant of answer count almost duplicate answers in table answer ((count question-1)*(variant of answer)* 7 = 19*4*7.
Nov
6
awarded  Supporter
Nov
5
revised Save history editable data RDBMS
added 393 characters in body
Nov
5
comment Save history editable data RDBMS
Thanks, but I still have a problem. Each test has questions and every question has naswers. Tutors can edit/add/delete any of those components. For example, he or she can modify one of the questsion's text, add several questions to a test and edit one of the answers to the question that has just been modified. Any hints how I can handle all this so that I could retreive a version of the test at the exact time in the past?
Nov
5
awarded  Student
Nov
5
awarded  Editor
Nov
5
revised Save history editable data RDBMS
added 126 characters in body
Nov
5
comment Save history editable data RDBMS
@a_horse_with_no_name I have a choice between mssql and mysql(
Nov
5
asked Save history editable data RDBMS