Learning by Example: A Student Grade Database

Let’s work through a student “Grades” database to show standard SQL commands to create and work with a database. Although you can create this database using the sqlite3 command line, we suggest using the Android application to create the empty Grades database, so that it is created in a standard “Android” way.

The setup: The purpose of the database is to keep track of each student’s test results for a specific class. In this example, each student’s grade is calculated from their individual performance on

• Four quizzes (each weighted as 10 percent of overall grade)

• One midterm (weighted as 25 percent of overall grade)

• One final (weighted as 35 percent of overall grade)

All tests are graded on a scale of 0–100.