String term = "CREATE TABLE Term (id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE," +
        "name TEXT NOT NULL);";

    String group = "CREATE TABLE _Group (id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE," +
        "idTerm INTEGER NOT NULL," +
        "name TEXT NOT NULL," +
        "FOREIGN KEY(idTerm) REFERENCES Term(id));";

id | name
---------
1  | "1 семестр"
2  | "2 семестр"

INSERT INTO _Group (idTerm, name) VALUES (10, 'КНТ-001');

PRAGMA foreign_keys = ON;