That's pretty clearly set out and very interesting.
I could be interested but unfortunately the budget doesn't even cover the server costs for the requirements as described, let alone the costs of building the system, training, updates, hosting or management.
I shall monitor this thread to be aware of any updates that you may post.
"The day you stop learning is the day you become obsolete"! - my late Dad.
Why do some people say "I don't know for sure"? If they don't know for sure then, they don't know!
Useful MySQL resource
Useful MySQL link