network profile
| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 7 months |
| seen | Mar 9 at 18:11 | |
| stats | profile views | 8 |
|
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 |
