Education: GUI for entering data in small DB, and generating flash cards based on content

I want to create a light app for sports training (traditional jujitsu) for my Kindle HDX In order to get my black belt I need to a) Document a series of techniques in my own words (about 200-300 Techniques) b) Demonstrate a series of randomly chosen techniques. This means I need to be familiar with *all* the techniques I have documented So, app has two main components a) An interface to help me document the techniques above b) Create a user profile Create User/Technique Combination Means to create a TrainingProgram for the user to address gaps Please excuse formatting, see attached word doc for clearer version Documentation Each technique will have a number of attributes 1. Technique ID (Integer. PK) 2. Native Language Name (Text) 3. Technique Family ID (FK) 4. Order within family (Integer) 5. Attack Desc (Text) 6. English Translation (Text) 7. Final Description (Text) 8. Work In Progress Description (Text) 9. Notes (Text) 10. GapFlag (Text (Y/N)) 11. Complexity (Integer) 12. One or more Links (hyperlink) 13. One or more video clips (blob) I have some of these fields populated, and can provide in a SQLite DB I’d like to be able to 1. Search through techniques a. By Name b. Drill down through family 2. List all techniques and a. Filter by GapFlag b. Sort by Order Within Family (Asc/Desc) 3. View a technique’s attributes 4. Create a new technique (blank record) 5. Edit a technique a. Edit text, including cut/ copy/paste, support for carriage return b. Play a video clip stored in a blob, with pause, reverse etc c. When editing a technique choose to record video clip and have it automatically added to the technique (I’m not sure how much support the kindle provides for this, but at a minimum I’d like to be able to find a clip in the device storage and insert it as a blob 6. Copy an existing record to be used as the basis for a new technique 7. Delete links or video clips TrainingProgram I need to be able to create a User Profile, and be able to identify the user’s confidence with each technique a) UserName b) UserID For user/ technique combination a) UserId (FK) b) TechniqueID (FK c) Confidence (integer, default 0) d) LastTrained (date) e) AgedConfidence (integer) f) Notes (Text) The goal is for the user to be able to go through the techniques randomly/ or those that they have lower confidence, allowing them to enter their revised confidence after they are done, and storing the last time trained As lack of practice means that confidence should decline over time, confidence is aged based on the difference between current date and last time trained, so confidence is multiplied by an aging factor to give aged confidence The agingfactor should be stored in a table, and should support different factors by different users Starting example AgingFactor Day since last Trained 1 0 .9 7 .8 14 .7 21 .6 28 .5 35 .4 42 .3 49 .2 56 Training program consists of flash cards. A flash card consists of a) Showing native name b) Buttons to tap to show a. Mnemonic b. Translation c. Video clip d. Full Attributes as in Documentation c) Slider to update final confidence Confidence (0 to 100) For a Trainingprogram, one can choose methods of getting flash cards a) In order among family (asc or desc) b) Random among full set c) Random within family d) Ascending order of AgedConfidence e) Ascending order of AgedConfidence within family f) Randomly with AgedConfidence under selected value g) Randomly with AgedConfidence under selected value I should be able to 1 Specify number of techniques to cover give above 2 Hide or see full list of techniques in the program 3 Have multiple programs (have a default name , which I can name, rename) 4 To stop within a particular program and return to it later (and see progress). 5 Delete a program