Take the tour ×  I am planning a flashcards app with the
following schema:  user(id, name, email) flashcard_group(id,
user_id, group_name, group_tag)  flashcard(id, group_id,
question, solution) guess(id, user_id, flashcard_id, is_correct)
Some of the things I would like to ultimately calculate are:
1. The number of times a user guesses a flash card incorrectly
and correctly (or a correctness percentage)   2. All of a user's
flashcards   3. All of the user's flashcard groups   4. Probably
more information about guesses.  Does this seem reasonable? How
else could I go about capturing guesses in a logical fashion?
share|improve this question Is this homework? –  Phil Sep 19 '12
at 17:21 no, it's actually a side project I'm doing to learn
more about database schemas. I dropped out of my databases class
because all we learn about is oracle and relational theory. I
figured I'd learn more out of a real project (albeit a lame
one). –  kishinmanglani Sep 19 '12 at 17:26 add comment  2
Answers    • Flashcards are