Student-Grade-Management-System/students.sqlite.sql at main · LazarosPan/Student-Grade-Management-System · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
BEGIN TRANSACTION;
CREATE TABLE "student" (
	`id`	TEXT,
	`name`	TEXT,
	`surname`	TEXT,
	PRIMARY KEY(`id`)
);
CREATE TABLE "exam_score" (
	`student_id`	TEXT,
	`exam_id`	TEXT,
	`score`	REAL,
	PRIMARY KEY(`student_id`,`exam_id`)
);
CREATE TABLE "exam" (
	`exam_id`	TEXT,
	`exam_name`	TEXT,
	PRIMARY KEY(`exam_id`)
);
CREATE INDEX `student_index` ON `student` (`id` )


;
COMMIT;