Class7-Database-Module-Week8/PyCoders.sql at main · Rumeysa-Y/Class7-Database-Module-Week8 · 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
26
BEGIN;


CREATE TABLE IF NOT EXISTS public.students
(
    student_id integer,
    student_name text,
    PRIMARY KEY (student_id)
);

CREATE TABLE IF NOT EXISTS public.teachers
(
    teacher_id integer,
    teacher_name text,
    PRIMARY KEY (teacher_id)
);

INSERT INTO students (student_id, student_name) VALUES(1, 'Rumeysa');
INSERT INTO students (student_id, student_name) VALUES(2, 'Rama');
INSERT INTO students (student_id, student_name) VALUES(3, 'Zehra');

INSERT INTO teachers (teacher_id, teacher_name) VALUES(1, 'Semih');
INSERT INTO teachers (teacher_id, teacher_name) VALUES(2, 'Irfan');
INSERT INTO teachers (teacher_id, teacher_name) VALUES(3, 'Ceren');

END;