I've both problems and methods to over two decades of physics PhD being approved exams that I must make more accessible, searchable, and helpful.

The issues around the Quals are organized into a number of different groups. The very first category is Undergraduate or Graduate problems. (The very first day from the exam is Undergraduate, the 2nd day is Graduate). Within individuals groups you will find several subjects which are examined: Mechanics, Electricity &lifier Magnetism, Record Mechanics, Quantum Mechanics, Mathematical Techniques, and Miscellaneous. Other determining features: Year, Season, and Problem number.

I am particularly thinking about creating an internet-based database system that may keep problem and solution and all sorts of the determining bits of information in some manner to ensure that the next kinds of actions might be done.

  • Search and return all Electricity &lifier Magnetism problems.
  • Search and return all graduate Record Mechanics problems.
  • Produce a random being approved exam — meaning a brand new 20 question test at random picking 2 Undergrad mechanics problems, 2 Undergrade E&M problems, etc. from past being approved exams (over some restricted time frame).
  • Have the choice to cover or display the solutions on results.

Any suggestions or comments how best to get this done project could be greatly appreciated!

I have explained more particulars here if you are interested.

Are "Electricity &lifier Magnetism" and "Record Mechanics" mutually exclusive categoriztions, across the same dimension? Exist multiple dimensions in groups you need to look for?

If the reply is yes to both, then I recommend you consider multidimensional data modeling. Like a physicist, there is a leg on many people if this involves evaluating the amount of dimensions towards the problem. Examining reality inside a multidimensional way is among the things physicists do.

Sometimes acquiring and learning an MDDB tool is overkill. Once you have investigated multidimensional modeling, you might decide you want the modeling concept, however, you still wish to implement using relational databases which use the SQL interface.

For the reason that situation, the following factor to consider is star schema design. Star schema is not the same as normalization like a design principle, also it does not provide the same advantages and restrictions. But it is worthwhile to learn within the situation where the issue is a real multidimensional one.

For the situation, it appears that it's more essential part to implement the interface compared to data storage. To keep the information, use a database table or tags. Each record within the database (or tag) must have the next qualities:

  1. Year
  2. Season
  3. Undergradure or Graduate
  4. Subject: Centimetres, EM, QM, SM, Mathematical Techniques, and Miscellaneous
  5. Problem number (could it be neccesary?)
  6. Question
  7. Answer

  • Search and return all Electricity &lifier Magnetism problems.

Directly query the database and you'll have an array, then display some or all queries.

  • Produce a random being approved exam — meaning a brand new 20 question test at random picking 2 Undergrad mechanics problems, 2 Undergrade E&M problems, etc. from past being approved exams (over some restricted time frame).

To develop a random exam, you need to first outline the amount of questions for every category and also the years it attracted from. For instance, if you would like 2 UG EM question. Query the database for those UG EM questions after which execute a random shuffling around the question array. Finally, choose the very first a couple of them and display this to student. Follow the other groups and you'll obtain a complete random exam paper.

  • Have the choice to cover or display the solutions on results.

It's your job to find out whether you would like the scholars to determine answer. It ought to be controlled by just one variable.