What is a good database approach for my Quiz Android app for Android?

Question

I am working on an Android Quiz Application with PHP and MySQL. I know what attributes I need, but when developing relationships, it becomes complicated and confusing when I analyze it. I do not know if this will be a good database design before writing in MySQL and implementing it in my project. See my ERD below:

As in the previous project, I am trying to create a design that will also work to create diagrams with any Android diagram generation library. I am not sure about this design, and I think I can fight to redo my database design. Any suggestions for this? Thanks in advance.

Answer 1

In my experience, this can be better built using NoSQL database JSON documents such as MongoDB, which allows you to do the following:

• The scheme is smaller: MongoDB is a document database in which one collection contains different documents.
• The structure of one object is clean.
• No complicated associations.
• Deep query ability.
• Customization.
• Ease of scale: MongoDB scales easily.

http://www.tutorialspoint.com/mongodb/index.htm

Try mlab as it provides MongoDb-as-a-service and can be easily connected to a web application deployed using Heroku. https://mlab.com/