Базы данных SQL-DDL и SQL-DML. Изучение транзакций. Программирование на языке SQL. Консольное приложение (Цикл лабораторных работ). Вариант № 1, страница 10

INSERT INTO ADDRESS_LINK (PERSON_ID, ADDRESS_ID, ADDRESS_TYPE) VALUES (48, 96, 2);

INSERT INTO ADDRESS_LINK (PERSON_ID, ADDRESS_ID, ADDRESS_TYPE) VALUES (49, 97, 1);

INSERT INTO ADDRESS_LINK (PERSON_ID, ADDRESS_ID, ADDRESS_TYPE) VALUES (49, 98, 2);

INSERT INTO ADDRESS_LINK (PERSON_ID, ADDRESS_ID, ADDRESS_TYPE) VALUES (50, 99, 1);

INSERT INTO ADDRESS_LINK (PERSON_ID, ADDRESS_ID, ADDRESS_TYPE) VALUES (50, 100, 2);

COMMIT WORK;

INSERT INTO REASON (REASON, ID) VALUES ('Болен', 2);

INSERT INTO REASON (REASON, ID) VALUES ('Университет', 1);

COMMIT WORK;

INSERT INTO DELAYS (ID, PERSON_ID, DT_TO, REASON_ID) VALUES (1, 2, '2013-07-01 00:00:00', 1);

INSERT INTO DELAYS (ID, PERSON_ID, DT_TO, REASON_ID) VALUES (2, 4, '2013-07-01 00:00:00', 1);

INSERT INTO DELAYS (ID, PERSON_ID, DT_TO, REASON_ID) VALUES (3, 6, '2013-07-01 00:00:00', 1);

INSERT INTO DELAYS (ID, PERSON_ID, DT_TO, REASON_ID) VALUES (4, 8, '2013-07-01 00:00:00', 1);

INSERT INTO DELAYS (ID, PERSON_ID, DT_TO, REASON_ID) VALUES (5, 10, '2013-07-01 00:00:00', 1);

INSERT INTO DELAYS (ID, PERSON_ID, DT_TO, REASON_ID) VALUES (6, 12, '2013-07-01 00:00:00', 1);

INSERT INTO DELAYS (ID, PERSON_ID, DT_TO, REASON_ID) VALUES (7, 14, '2013-07-01 00:00:00', 1);

INSERT INTO DELAYS (ID, PERSON_ID, DT_TO, REASON_ID) VALUES (8, 16, '2013-07-01 00:00:00', 1);

INSERT INTO DELAYS (ID, PERSON_ID, DT_TO, REASON_ID) VALUES (9, 18, '2013-07-01 00:00:00', 1);

INSERT INTO DELAYS (ID, PERSON_ID, DT_TO, REASON_ID) VALUES (10, 20, '2013-07-01 00:00:00', 1);

INSERT INTO DELAYS (ID, PERSON_ID, DT_TO, REASON_ID) VALUES (11, 22, '2013-07-01 00:00:00', 1);

INSERT INTO DELAYS (ID, PERSON_ID, DT_TO, REASON_ID) VALUES (12, 24, '2013-07-01 00:00:00', 1);

INSERT INTO DELAYS (ID, PERSON_ID, DT_TO, REASON_ID) VALUES (13, 26, '2013-07-01 00:00:00', 1);

INSERT INTO DELAYS (ID, PERSON_ID, DT_TO, REASON_ID) VALUES (14, 28, '2013-07-01 00:00:00', 1);

INSERT INTO DELAYS (ID, PERSON_ID, DT_TO, REASON_ID) VALUES (15, 30, '2013-07-01 00:00:00', 1);

INSERT INTO DELAYS (ID, PERSON_ID, DT_TO, REASON_ID) VALUES (16, 32, '2013-07-01 00:00:00', 1);

INSERT INTO DELAYS (ID, PERSON_ID, DT_TO, REASON_ID) VALUES (17, 34, '2013-07-01 00:00:00', 1);

INSERT INTO DELAYS (ID, PERSON_ID, DT_TO, REASON_ID) VALUES (18, 36, '2013-07-01 00:00:00', 1);

INSERT INTO DELAYS (ID, PERSON_ID, DT_TO, REASON_ID) VALUES (19, 38, '2013-07-01 00:00:00', 1);

INSERT INTO DELAYS (ID, PERSON_ID, DT_TO, REASON_ID) VALUES (20, 40, '2013-07-01 00:00:00', 1);

INSERT INTO DELAYS (ID, PERSON_ID, DT_TO, REASON_ID) VALUES (21, 42, '2013-07-01 00:00:00', 1);

INSERT INTO DELAYS (ID, PERSON_ID, DT_TO, REASON_ID) VALUES (22, 44, '2013-07-01 00:00:00', 1);

INSERT INTO DELAYS (ID, PERSON_ID, DT_TO, REASON_ID) VALUES (23, 46, '2013-07-01 00:00:00', 1);

INSERT INTO DELAYS (ID, PERSON_ID, DT_TO, REASON_ID) VALUES (24, 48, '2013-07-01 00:00:00', 1);

INSERT INTO DELAYS (ID, PERSON_ID, DT_TO, REASON_ID) VALUES (25, 50, '2013-07-01 00:00:00', 1);

INSERT INTO DELAYS (ID, PERSON_ID, DT_TO, REASON_ID) VALUES (26, 1, '2012-01-01 00:00:00', 2);

COMMIT WORK;

INSERT INTO PROFESSIONS (ID, DESCRIPTION) VALUES (1, 'Офтальмолог');

INSERT INTO PROFESSIONS (ID, DESCRIPTION) VALUES (2, 'Хирург');

INSERT INTO PROFESSIONS (ID, DESCRIPTION) VALUES (3, 'Дерматолог');

INSERT INTO PROFESSIONS (ID, DESCRIPTION) VALUES (4, 'Отоларинголог');

INSERT INTO PROFESSIONS (ID, DESCRIPTION) VALUES (5, 'Невропатолог');

INSERT INTO PROFESSIONS (ID, DESCRIPTION) VALUES (6, 'Главврач');

COMMIT WORK;

INSERT INTO MEDICS (ID, NAME, PROFESSION_ID) VALUES (1, 'Козюльский А.Н.', 1);

INSERT INTO MEDICS (ID, NAME, PROFESSION_ID) VALUES (2, 'Воровской Ж.З.', 2);