I'm trying to create an app for teachers in my college from which a teacher just can select students which are present from list and once the list is submitted every app should be updated with the attendance list how can i create this kind of database for my app?
Simplest way is using php server files with android app.As in your scenario you can create two modules teachers and students module. For teachers As far as selection is concerned you can use dynamic check box and and a status(present/absent) field in your table such that if checkbox is selected then status is present or absent and maintain one count variable to count the attendance based on date field. For students module retrieve the status field and display it based on dates.