4DKbYTh2

1dBmanager.createTable(database,
2                    "CREATE TABLE IF NOT EXISTS Skole (\n"
3                            + "name text PRIMARY KEY\n"
4                            + ");"
5            );
6
7            dBmanager.createTable(database,
8                    "CREATE TABLE IF NOT EXISTS Kull (\n"
9                            + "kode text PRIMARY KEY,\n"
10                            + "skole text NOT NULL,\n"
11                            + "FOREIGN KEY(skole) REFERENCES Skole(navn)\n"
12                            + ");"
13            );
14
15            dBmanager.createTable(database,
16                    "CREATE TABLE IF NOT EXISTS Student (\n"
17                            + "nr text PRIMARY KEY,\n"
18                            + "navn text NOT NULL,\n"
19                            + "kull text NOT NULL,\n"
20                            + "FOREIGN KEY (kull) REFERENCES Kull(kode)\n"
21                            + ");"
22            );
23
24            dBmanager.createTable(database,
25                    "CREATE TABLE IF NOT EXISTS Karakter (\n"
26                            + "id integer PRIMARY KEY,\n"
27                            + "karakter text NOT NULL,\n"
28                            + "ar integer NOT NULL,\n"
29                            + "student text NOT NULL,\n"
30                            + "FOREIGN KEY (student) REFERENCES Student(nr)\n"
31                            + ");"
32            );
33
34            dBmanager.createTable(database,
35                    "CREATE TABLE IF NOT EXISTS Kurs (\n"
36                            + "kode text PRIMARY KEY,\n"
37                            + "navn text NOT NULL,\n"
38                            + "skole text NOT NULL,\n"
39                            + "FOREIGN KEY (skole) REFERENCES Skole(navn),\n"
40                            + "karakter integer NOT NULL,\n"
41                            + "FOREIGN KEY (karakter) REFERENCES Karakter(id)\n"
42                            + ");"
43
44            );