англ. - М.: ТОВ В«І.Д. Вільямс В», 2011. - 544 с. p align="justify"> Кевін Луни, Боб Брила та експерти TUSC - Oracle Datadase 10g. Настільна книга адміністратора баз даних, вид. В«ЛоріВ», 2008. - 377с. p align="justify"> Т. Конноллі, К.Бегг - Бази даних. Проектування, реалізація і супровід. Теорія і практика, 3-е вид.: Пер.с англ. - М.: ТОВ В«І.Д. Вільямс В», 2003. - 1440с. br/>
Додаток А. SQL - скрипти створення таблиць
CREATE TABLE AIDS_patients (Stage VARCHAR2 (10), InsurNum VARCHAR2 (12) NOT NULL) TABLE AIDS_patients CONSTRAINT "PK_AIDS_patients" PRIMARY KEY (InsurNum); TABLE Analysis
(Result VARCHAR2 (15), _An DATE NOT NULL, _An VARCHAR2 (15) NOT NULL, VARCHAR2 (12) NOT NULL); TABLE Analysis CONSTRAINT "Analysis_PK" PRIMARY KEY (Date_An, ID_An, InsurNum); TABLE Clients
(FIO VARCHAR2 (60), VARCHAR2 (12) NOT NULL, DATE, VARCHAR2 (50), VARCHAR2 (14)); TABLE Clients CONSTRAINT "Clients_PK" PRIMARY KEY (InsurNum); TABLE Department
(ID_Depart NUMBER (6) NOT NULL, VARCHAR2 (50)); TABLE Department CONSTRAINT "Department_PK" PRIMARY KEY (ID_Depart); TABLE Donors
(BloodGr VARCHAR2 (15), DATE, NUMBER (3), VARCHAR2 (12) NOT NULL); TABLE Donors CONSTRAINT PK_Donors PRIMARY KEY (InsurNum); TABLE Hospital
(ContractNum NUMBER (6) NOT NULL, VARCHAR2 (60), DATE, DATE, NUMBER (3) NOT NULL, _worker NUMBER (6) NOT NULL, VARCHAR2 (12) NOT NULL); TABLE Hospital CONSTRAINT "Hospital_PK" PRIMARY KEY (ContractNum); TABLE Houses
(HouseNum NUMBER (3) NOT NULL, NUMBER (2), _Depart NUMBER (6) NOT NULL); TABLE Houses CONSTRAINT "Houses_PK" PRIMARY KEY (HouseNum); TABLE Med_Dev
(SerNum NUMBER (6) NOT NULL, VARCHAR2 (30), DATE, NUMBER (3) NOT NULL); TABLE Med_Dev CONSTRAINT "Med_Dev_PK" PRIMARY KEY (SerNum); TABLE Money
(Post VARCHAR2 (35) NOT NULL, NUMBER (5)); TABLE Money CONSTRAINT "Money_PK" PRIMARY KEY (Post); TABLE Pers_Data
(FIO VARCHAR2 (60), DATE, VARCHAR2 (50), VARCHAR2 (14), _worker NUMBER (6) NOT NULL); TABLE Pers_Data CONSTRAINT "Pers_Data_PK" PRIMARY KEY (ID_worker); TABLE Rooms
(RoomNum NUMBER (3) NOT NULL, _Depart NUMBER (6) NOT NULL); TABLE Rooms CONSTRAINT "Rooms_PK" PRIMARY KEY (RoomNum); TABLE Talons
(ID_talon NUMBER (6) NOT NULL, _T DATE, _T VARCHAR (6), _worker NUMBER (6) NOT NULL, VARCHAR2 (12) NULL); TABLE Talons CONSTRAINT "Talons_PK" PRIMARY KEY (ID_talon); TABLE Type_An
(ID_An VARCHAR2 (15) NOT NULL, VARCHAR2 (60), VARCHAR2 (30)); TABLE Type_An CONSTRAINT "Type_An_PK" PRIMARY KEY (ID_An); TABLE Work_Data
(ID_Manager NUMBER (6), VARCHAR2 (20), _worker NUMBER (6) NOT NULL, VARCHAR2 (35) NOT NULL, NUMBER (3) NOT NULL); TABLE Work_Data CONSTRAINT "Wo...
