- •Содержание
- •Введение
- •Реферат
- •Р еферат
- •Постановка задачи и анализ предметной области
- •1.1 Цель создания системы бд.
- •1.2 Функциональный анализ предметной области.
- •1.3 Пользовательские представления о предметной области.
- •Проектирование базы данных
- •2.1 Концептуальная модель
- •2.1.1 Типы сущностей
- •2.1.2 Типы связей
- •2.1.3 Атрибуты и их домены
- •2.1.4 Локальные концептуальные модели пользователей
- •2.1.5 Диаграмма глобальной концептуальной модели
- •2.2 Логическая модель
- •2.2.1 Отношения
- •2.2.2 Ограничения целостности
- •2.2.3 Представления
- •2.3 Физическая модель
- •2.3.1 Анализ транзакций
- •2.3.2 Файловая структура отношений
- •2.3.3 Индексы
- •2.3.4 Средства защиты
- •3. Проектирование пользовательского интерфейса
- •3.1 Архитектура пользовательского интерфейса
- •3.2 Формы ввода/вывода
- •3.3 Запросы и отчеты
- •Проектирование програмного обеспечения
- •4.1. Структура приложения и его основных частей.
- •4.2. Входные и выходные потоки данных.
- •4.3. Описание взаимодействия серверной и клиентской части программного комплекса
- •4.4. Инструментальная среда разработки и язык(и) программирования
- •4.5. Организация доступа к данным
- •Список использованнных источников
2.2.2 Ограничения целостности
Целостность базы данных — соответствие имеющейся в базе данных информации её внутренней логике, структуре и всем явно заданным правилам. Каждое правило, налагающее некоторое ограничение на возможное состояние базы данных это ограничением целостности. В разрабатываемой базе данных были разработаны такие ограничения, они представлены в таблице 2.33.
Таблица 2.33 – Ограничения целостности
Таблица |
Поле |
Ограничение |
personnel |
Id_personnel |
CONSTRAINT personnel_pkey PRIMARY KEY (id_personnel) |
Id_post |
CONSTRAINT fk_post FOREIGN KEY (id_post) REFERENCES Post (id_post) MATCH SIMPLE ON UPDATE CASCADE ON DELETE RESTRICT |
|
Id_list |
CONSTRAINT fk_list FOREIGN KEY (id_list) REFERENCES Obedient_list (id_list) MATCH SIMPLE ON UPDATE CASCADE ON DELETE RESTRICT |
|
Id_qualification |
CONSTRAINT fk_qual FOREIGN KEY (id_qualification) REFERENCES Qualification (id_qualification) MATCH SIMPLE ON UPDATE CASCADE ON DELETE RESTRICT |
|
Id_chamber |
CONSTRAINT fk_chamber FOREIGN KEY (id_chamber) REFERENCES Chamber (id_chamber) MATCH SIMPLE ON UPDATE CASCADE ON DELETE RESTRICT |
|
Pol |
Check(“pol”= ‘м’ or “pol”= ‘ж’) |
|
Post |
Id_post |
CONSTRAINT post_pkey PRIMARY KEY (id_post) |
Obedient_list |
Id_list |
CONSTRAINT list_pkey PRIMARY KEY (id_list) |
Qualification |
Id_qualification |
CONSTRAINT qual_pkey PRIMARY KEY (id_qualification) |
Chamber |
Id_chamber |
CONSTRAINT chamber_pkey PRIMARY KEY (id_chamber) |
Contract |
Id_contract |
CONSTRAINT contract_pkey PRIMARY KEY (id_contract) |
Id_personnel |
CONSTRAINT fk_personnel FOREIGN KEY (id_personnel) REFERENCES Personnel (id_personnel) MATCH SIMPLE ON UPDATE CASCADE ON DELETE RESTRICT |
|
Suppliers |
Id_supplier |
CONSTRAINT supplier_pkey PRIMARY KEY (id_supplier) |
Warehouse_ materials |
Id_materials |
CONSTRAINT materials_pkey PRIMARY KEY (id_materials) |
Id_supplier |
CONSTRAINT fk_supplierl FOREIGN KEY (id_supplier) REFERENCES Supplier (id_supplier) MATCH SIMPLE ON UPDATE CASCADE ON DELETE RESTRICT |
|
Warehouse_ preparations |
Id_preparations |
CONSTRAINT preparations_pkey PRIMARY KEY (id_preparations) |
Id_supplier |
CONSTRAINT fk_supplierl FOREIGN KEY (id_supplier) REFERENCES Supplier (id_supplier) MATCH SIMPLE ON UPDATE CASCADE ON DELETE RESTRICT |
|
Demand |
Id_demand |
CONSTRAINT demand_pkey PRIMARY KEY (id_demand) |
Id_personnel |
CONSTRAINT fk_personnel FOREIGN KEY (id_personnel) REFERENCES Personnel (id_personnel) MATCH SIMPLE ON UPDATE CASCADE ON DELETE RESTRICT |
|
Id_chamber |
CONSTRAINT fk_chamber FOREIGN KEY (id_chamber) REFERENCES Chamber (id_chamber) MATCH SIMPLE ON UPDATE CASCADE ON DELETE RESTRICT |
|
Id_materials |
CONSTRAINT fk_materials FOREIGN KEY (id_materials) REFERENCES Warehouse_materials(id_materials) MATCH SIMPLE ON UPDATE CASCADE ON DELETE RESTRICT |
|
Id_preparations |
CONSTRAINT fk_preparations FOREIGN KEY (id_preparations) REFERENCES Warehouse_preparations (id_preparations) MATCH SIMPLE ON UPDATE CASCADE ON DELETE RESTRICT |
|
Local_doctor |
Id_doctor |
CONSTRAINT doc_pkey PRIMARY KEY (id_doc) |
Purpose |
Id_purpose |
CONSTRAINT purpose_pkey PRIMARY KEY (id_purpose) |
Id_personnel |
CONSTRAINT fk_personnel FOREIGN KEY (id_personnel) REFERENCES Personnel (id_personnel) MATCH SIMPLE ON UPDATE CASCADE ON DELETE RESTRICT |
|
Relative |
Id_relative |
CONSTRAINT relative_pkey PRIMARY KEY (id_relative) |
Patient |
Id_patient |
CONSTRAINT patient_pkey PRIMARY KEY (id_patient) |
Id_purpose |
CONSTRAINT fk_purpose FOREIGN KEY (id_purpose) REFERENCES Purpose (id_purpose) MATCH SIMPLE ON UPDATE CASCADE ON DELETE RESTRICT |
|
Id_doctor |
CONSTRAINT fk_doctor FOREIGN KEY (id_doctor) REFERENCES Local_doctor (id_doctor) MATCH SIMPLE ON UPDATE CASCADE ON DELETE RESTRICT |
|
Pol |
Check(“pol”= ‘м’ or “pol”= ‘ж’) |
|
Id_relative |
CONSTRAINT fk_relative FOREIGN KEY (id_ relative) REFERENCES Relative (id_ relative) MATCH SIMPLE ON UPDATE CASCADE ON DELETE RESTRICT |
|
Registration |
Id_registration |
CONSTRAINT registration_pkey PRIMARY KEY (id_registration) |
Id_patient |
CONSTRAINT fk_patient FOREIGN KEY (id_patient) REFERENCES Patient (id_patient) MATCH SIMPLE ON UPDATE CASCADE ON DELETE RESTRICT |
|
Id_chamber |
CONSTRAINT fk_chamber FOREIGN KEY (id_chamber) REFERENCES Chamber (id_chamber) MATCH SIMPLE ON UPDATE CASCADE ON DELETE RESTRICT |
|
Ambulat_ patient |
Id_ambula_ patient |
CONSTRAINT ambula_pkey PRIMARY KEY (Id_ambula_patient) |
|
Id_relative |
CONSTRAINT fk_relative FOREIGN KEY (id_ relative) REFERENCES Relative (id_ relative) MATCH SIMPLE ON UPDATE CASCADE ON DELETE RESTRICT |
|
Pol |
Check(“pol”= ‘м’ or “pol”= ‘ж’) |