SQLite database structure in android application

Question

Android

Hello. I am creating an Android app. The application should carry out some functions of the school journal, namely: marking, attendance control.
The application should be able to mark the entire class (group) with the fixing of the date of the mark. How can a database be organized? What tables and what columns are needed?
Perhaps I did not formulate the question very well, if something is not clear, I will clarify.

Answer 1

Score table - fields of user ID, rating, date of setting
Attendance table - fields of user ID, date of visit (or date of absenteeism)
But in general the question is a captain, any sql textbook is full of similar examples