How to display a directory in an android application from a SQLite database?

Question

Android

Hello, I have a few questions!
1) Offline site application. There is a sqlite base with several tables, there are categories, subcategories and objects. So you need to display this data with categories and subcategories in the application ... well, that is. a person selects a category, then a subcategory... and selects the desired object in it and reads the information that is in it... help with an example on the Internet for something similar... thanks...
2) This sqlite database will be converted from the Mysql database site on the Internet. How to do it on the server so that it is automatically converted every 5 days and put into a certain place on the server?
3) When downloading and installing this application, the database creation time was compared ... if the SQLite database in the application is older than 5 days of the Sqlite database on the server, then load the converted (new) Sqlite database from the server into this application.
Thank you all ... I'm not a very advanced programmer yet ... I'll be glad for links to examples or
something like that)

Answer 1

developer.android.com/guide/index.html
well, tutorials from habr on writing android applications
For the base here:
stackoverflow.com/search?q=Convert+MySQL+to+SQlite