Dear Monks,

I have just been given a rather large project and could use some of your direction. I need to design an online testing center for my company. It would be maintained on the company intranet. The tests and results would be stored in our oracle database. There are:

8 departments
5 tests/dept
100 questions/test(approx.)
1/2/4 answers/question

The questions include Multiple Choice, T/F, Matching, and short answer. The short answer will have to be graded manually.
I have been working on the table layout for the db and have come up with the following ideas:

Table 1 - User Record
User Id
Test Type - aka. Department
Test Level - 1 thru 5
Test Score - null(Can't take test), 0 thru 99(Take/Retake test), 100(Test Complete
?'s Missed - Question Numbers from Test Table

Table 2 - Test Record
Test Type - aka Department
Question # - 1 thru 100
Question -
Answer 1 -The Correct answer will have leading special characters(## or || or ~~)
Answer 2 -
Answer 3 -
Answer 4 -

All of this will be done in Perl and I am kinda lost as to where to start looking. If you guys could point me in the direction of some good weekend reading, I would appreciate it. If this is not enough information please reply and I will try and provide further info. Sorry if the question is vague, but I don't have code at this time, just thoughts about implementation. I can implement as I see fit, for the most part, and I am looking for ideas.

As always, thanks for you help in advance.

Prince99
Too Much is never enough...

In reply to Online Testing Center Project by Prince99

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.