insert into Groups (id, name, admission_year, specialty)
values (1, 'M3439', 2016, '01.03.02');
insert into Persons (id, first_name, last_name, patronymic, mail)
values (1, 'Артем', 'Шалагин', 'Алексеевич', null);
insert into Persons (id, first_name, last_name, patronymic, mail)
values (2, 'Георгий', 'Корнеев', 'Александрович', null);
insert into Students (grants, group_id, person_id)
values (0, 1, 1);
insert into Professors (degree, position, salary, person_id)
values ('кандидат технических наук', 'доцент', 9999999, 2);
insert into Subjects (id, name, is_required)
values (1, 'введение в базы данных', true);
insert into Studying (year, semester, subject_id, student_id)
values (2019, 1, 1, 1);
insert into Teaching (year, semester, subject_id, professor_id)
values (2019, 1, 1, 2);
insert into Grades (value, subject_id, student_id, professor_id)
values ('A', 1, 1, 2);