I am programming an app that consist in 180 mineral sheets of interest for geology students.

My database have the following fileds:

  • Identifier
  • Name
  • Name 2
  • Type
  • Class
  • Formula
  • System
  • Environment1
  • Environment2
  • Environment3
  • Environment4
  • Environment5
  • Habit
  • Color
  • Diaphaneity
  • Luster
  • Streak
  • Density
  • Hardness
  • Cleavage
  • Fracture

For example the entry for golds look like:

INSERT INTO MINE180 VALUES('1','gold','gold','Non sillicates.','Native Elements.','Au','Cubic.','Hydrothermal: Associated to quartz veins.','Sedimentary: Placers.','Magmatic: IOCG deposits.','','','Octaedrical crystals.','Characteristic yellow.','Opaque.','Metallic.','Characteristic yellow.','19.3','2.5-3','---','Splintered, jagged.');

I am going to generate questions such as:

Wich mineral belongs to inosillicates class?

a) Calcosine

b) Augite

c) Quartz

d) Pirope

I can generate questions from all the fields ot the database but I don't thi