We'll develop these types of sample Android App using SQLite database. There are multiple sample project in this repository. Check below list:
hasancse91/Android-SQLite-Tutorial
This is a simple project of Android SQLite Relational Database. You can check my Bengali Blog Post on this topic
Java