We’re students and we’re in the middle of design stage to develop native android app (no web-based) with MySQL database.
Major Features:
Inventory - can the app be able to update the inventory in real time?this is for the sale and restock transactions. Will there be an issue in speed? Can I generate reports for customer’s billing in real time?
Of course. Computers would be pretty useless if they couldn’t update data in real-time.
Highly unlikely. Unless you’re going to be dealing with millions of data rows, you probably won’t have any issues with speed. If you are going to be dealing with millions of data rows, as long as you have appropriate indexes on your database, it should still be pretty quick.
That’s hard to say without potentially doing your assignment for you. Have you been given any guidance on what tools/libraries/etc. you’ll be using for your assignment?
Without any context… I would say you should learn Android development (obviously), but also learn Java build tools, like Maven or Gradle. Also maybe unit tests, like JUnit.