2eVh3vGD

1            Class.forName("org.sqlite.JDBC");
2            c = DriverManager.getConnection("jdbc:sqlite:school.db");
3            Statement stmt = c.createStatement();
4            String sql = "CREATE TABLE IF NOT EXISTS COURSE" +
5                    "(COURSEID INTEGER PRIMARY KEY NOT NULL," +
6                    " CODE TEXT NOT NULL," +
7                    " NAME TEXT NOT NULL)";
8            stmt.executeUpdate(sql);
9            stmt.close();
10            stmt = c.createStatement();
11            sql = "CREATE TABLE IF NOT EXISTS STUDENT" +
12                    "(STUDENTID INTEGER PRIMARY KEY NOT NULL," +
13                    " NAME TEXT NOT NULL," +
14                    " SURNAME TEXT NOT NULL," +
15                    " FOREIGN KEY(COURSEID) REFERENCES COURSE(COURSEID))";
16            stmt.executeUpdate(sql);
17            stmt.close();