Blood Donation Record Database for American Red Cross
Blood Donation Record Database for
American Red Cross
B R I A N
H E N D E R S O N
Table of Contents
Table of
Contents......................... 2 Executive Summary..................... 3 E/R
Diagram................................. 4 Create Table
Statements
People
Table............................. 5 Donor
Table.............................. 6 Patient
Table............................. 7 Nurse
Table............................... 8 Pre
Exam
Table......................... 9 Donation
Table......................... 10 Donation Types
Table.............. 11 Transfusion Table..................... 12 Blood
Bags
Table...................... 13 Locations
Table........................ 14 Location Codes
Table............. 15 Global
Inventory
Table............ 16 Requests
Table......................... 17 Donation
Records
Table.......... 18 Transfusion
Records
Table...... 19
Stored
Procedures
get_persons_donation_records...... 20
get_blood_type_inventory_per...... 21
update_inventory_status................. 22
TBA
23
Triggers
update_inventory_status_trigger... 24
TBA
25
Views
AvailableBloodBags........................... 26
LocationInventories........................... 27
Reports/Interesting Queries
1........................................................... 28
2........................................................... 29
Security.................................................... 30
Implementation Notes......................... 31
Known
Problems................................... 31
Future
Enchancements......................... 31
2
Executive Summary
This document outlines the design of a database to hold all the data for the American Red Cross in regards to their blood donation division. The American Red Cross is the leading blood donation organization in the world. Distributing to about 2,600 hospitals and healthcare facilities in the United States alone, the American Red Cross collects and processes roughly 40% of the nation's blood supply. The design of this database is to show the framework for the amount of data that the American Red Cross comes across, as well as to serve as a historical reference. This database holds all the information required for each donation/transfusion, including the required pre-exam, a global inventory to show the inventory stocks across all locations, which can also be queried to narrow down to the specific location. The data implemented into this database is fictional, with some exceptions. All persons, pre-exams, records, and some locations are fictional. This database is designed to hold large scale data. The ultimate objective is to design a database that is not only fully functional, but also fully normalized in third normal form that can help serve the American Red Cross for their blood donation records.
3
E/R DIAGRAM
4
Persons Table
The people table contains all the people and their common attributes. There are three subtypes for the people table: patient, donor, and nurse.
CREATE TABLE persons (
pid
char(8)
first_name text
last_name text
age
integer
primary key(pid)
);
Functional Dependencies Pid ? first_name, last_name, age
not null unique, not null, not null, not null,
Sample Data
5
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- to bloodblood
- massive and emergent transfusions shan yuan md
- frequently asked questions about blood types
- blood typing 101 ceconnection
- blood donation record database for american red cross
- medicare coverage of diabetes supplies services and
- blood type testing lab report nattanit trakullapphan
- why do i need a type and screen blood test when do i need
Related searches
- american red cross employee portal
- american red cross employee
- american red cross retirement benefits
- american red cross discounts
- american red cross class discount
- american red cross employee website
- coupon codes for american red cross classes
- american red cross coupon for cpr class
- american red cross blood donation
- american red cross blood typing
- american red cross blood drive
- american red cross blood hub