Blood Donation System Case Study 2022

Running head: BLOOD DONATION SYSTEM
BLOOD DONATION SYSTEM
Name of the Student
Name of the University
Author Note

BLOOD DONATION SYSTEM
1
Table of Contents
Stage 1: Scenario and Conceptual Database Design..................................................................2
Task 1.1: Case Study:.............................................................................................................2
Task 1.2: Conceptual database design:..................................................................................2
Stage 2: Logical Database Design and SQL Querying..............................................................3
Task 2.1: Logical Database Design:.......................................................................................3
Task 2.2: Creating tables using Oracle DBMS......................................................................3
Task 2.3: Creating the four most useful indexes....................................................................8
Task 2.4: SQL Query writing.................................................................................................9
Bibliography:............................................................................................................................11

BLOOD DONATION SYSTEM
2
Stage 1: Scenario and Conceptual Database Design
Task 1.1: Case Study:
The National Blood bank wants to build its database for Blood donation. The old
system is not capable enough to hold a vast amount of information. New Blood donation
system is able to store every detail and it will help a blood seeker and management as well.
The new database is able to store every information of blood. Every blood bag can be
identified by their unique id number. Blood bag can be stored in blood banks and blood donor
can donate blood in the hospital. Every blood bank has its id. Only one manager is assigned
to a blood bank. Managers observe the workflow in blood banks. In the hospital, every donor
can donate blood and a blood seeker can find blood. Hospital stocks every blood bag. Many
employees can work under the hospital. The manager of the Blood bank is also an employee
of a national blood bank.
Task 1.2: Conceptual database design:
Figure1: Conceptual database design of National Blood Bank
(Source: Created by author)

BLOOD DONATION SYSTEM
3
Stage 2: Logical Database Design and SQL Querying
Task 2.1: Logical Database Design:
Figure 2: Logical Database design of National Blood Bank
(Source: Created by author)
Task 2.2: Creating tables using Oracle DBMS
Creating P2556926Doner Table:
CREATE TABLE P2556926Doner (
donerid int NOT NULL PRIMARY KEY,
name VARCHAR2(20),
age int NOT NULL,