Example Tables and fields :
---Table question_group ---
1. id (Number PK)
2. group_name (String)
--- Table questions ---
1. id (Number PK)
2. Question (String)
3. Choice 1 (String)
4. Choice 2 (String)
5. Choice 3 (String)
6. Choice 4 (String)
7. Answer (Number 1 digit : 1,2,3,4)
8. Group_ID (Number relations id table question_group)
Flow of create Question:
1. Create Question Group
2. Create question and select group_id
I have adobe Flash Quiz application. It can work with XML file and I want to use SilverStrip framework for backend management this module (create,edit,delete ) and return xml to Flash Application.
Example XML FIle :
<Quiz>
<question>
<quiz>What is it?</quiz>
<choice_1>Cat</choice_1>
<choice_2>Cat</choice_1>
<choice_3>Cat</choice_1>
<choice_4>Cat</choice_1>
<answer>2</answer>
</question>
<question>
........Bla Bla Bla ....
</question>
</Quiz>
Help me or guide me please.
Thank you.