International Journal of Pure and Applied Mathematics

Running head: DATABASE
DATABASE SYSTEM AND DESIGN
Name of the Student
Name of the University
Author Note

DATABASE1
Table of Contents
Solution 1.1......................................................................................................................................2
Solution 1.2......................................................................................................................................3
Solution 2.1......................................................................................................................................4
Logical Design.............................................................................................................................4
Solution 2.2......................................................................................................................................4
Table Creation.............................................................................................................................4
Solution 2.3......................................................................................................................................5
Index............................................................................................................................................5
Solution 2.4......................................................................................................................................6
Data Population...........................................................................................................................6
Solution 2.5......................................................................................................................................8
SQL Query...................................................................................................................................8
References......................................................................................................................................11

DATABASE2
Solution 1.1
A scenario of a blood donation system: The hospital management decided to develop a
digital system for their blood donation system. The new system mainly performs the following
functionality.
There are two users who are going to use the new system. There are two sides of blood
donation system. They are admin and the volunteers who will donate blood. The system will
maintain the volunteers accounts with their personal details such as name, phone no, email id,
address and obviously their blood group.
After collecting the blood they are packed and sent for testing. Sometime blood samples
have some diseases, infections, viruses. Therefore they are sent for testing. In testing center the
blood samples are tested properly. After that the positive samples are sent to blood bank. The
sample that has some diseases or viruses, they are rejected and not sent to the blood bank.
After the collection of blood the packets of bloods are sent to the blood bank they are
stored according to their blood groups and their characteristics.
As per requirements hospitals requests blood from blood bank with respected blood
group. If possible then the blood bank sent blood packets to the hospitals. After that patients are
provided the blood.

DATABASE3
Solution 1.2
Enhanced Entity Relationship Diagram is the conceptual design of the design. It represents the
tables and their attributes. The relationships among the tables are also discussed. Donor donates
blood after that the blood sample are sent for testing. After positive testing, the blood is sent to
blood bank. Blood bank stores the blood. Hospitals requests blood from blood bank and after that
they are sent to the hospitals.