Blood Bank Management database systems .pptx

A presentation that shows how a database for a blood bank management system is made and is beneficial to them

1. Blood Bank Management System Group Members: Muhammad Rehan-232028 Muhammad Rehan Azhar-2320 Abdul Ahad-2320 Database Project

2. Project Introducution Project Objective:- To develop an automated and efficient blood bank management system that improves data accuracy, enhances accessibility, reduces manual efforts, and supports decision-making through comprehensive data analysis. Key features:- Automated Data Management Robust Data Validation Inventory Tracking Secure Data Storage Integration with Hospitals Development apps:- Oracle Sql plus-pl/ sql Sql Developer

3. Scope of Project 01 Inventory Management 03 02 03 04 05 07 06 System Integration User Roles & Access Control Reporting & Analytics Request & Distribution Management Collection & Testing Donor Management

4. ERD of Database

5. Information of Entities DiseaseFinder : (Attributes - dfind_ID , dfind_name , dfind_PhNo ) 2 3 Hospital_Info : (Attributes – hosp_ID , hosp_name , hosp_needed_Bgrp , hosp_needed_Bqnty ) City: (Attributes- city_ID , city_ name) 6 4 5 8 7 1 Blood_Donor : (Attributes – bd_ID , bd_name , bd_sex , bd_age , bd_Bgroup , bd_reg_date , bd_phNo ) BB_Manager : (Attributes – m_ID , m_Name , m_phNo ) Recording_Staff : (Attributes – reco_ID , reco_Name , reco_phNo ) Recipient: (Attributes – reci_ID , reci_name , reci_age , reci_Bgrp , reci_Bqnty , reci_sex , reci_reg_date , reci_phNo ) BloodSpecimen : (Attributes – specimen_number , b_group , status)

6. Relational Schema

7. Relationship between Entities BB_Manager & Blood Specimen: 1 to many 2 3 Hospital_Info & BB_Manager : 1 to many Recording_Staff & Recipient: 1 to many 6 4 5 8 7 1 City & Hospital_Info : 1 to many City & Recipient: 1 to many Recording_Staff & Donor: 1 to many City & Blood_Donor : 1 to many Recipient & BB_Manager : 1 to many 9 Disease_finder & Blood Specimen: 1 to many

8. A fter N ormalization

9. 01 Recording_staff ( reco_name , reco_ID , reco_phNo ) 03 02 03 04 07 08 06 Blood Specimen ( b_group , specimen_no , status, dfind_id , m_id ) Blood_recipient ( reci_Id , reci_sex , reci_phNo , reci_age , reci_date , reci_name , reci_Bqnty , reci_Bgrp , reco_id , city_id , m_id ) Disease_finder ( dfind_id , dfind_name , dfind_PhNo ) BB_manager ( M_id , m_name , m_phNo ) City ( city_id , city_name ) Blood_Donor ( bd_Id , bd_name , bd_phNo bd_sex , bd_age , bd_reg_date , bd_Bgroup , reco_ID , City_ID ) 05 Hospital_Info ( hosp_Id , hosp_Name , hosp_phNo , hosp_needed_Bgrp , hosp_needed_qty , city_id , m_id )

10. Insert Blood Donor Procedure

11. Output

12. Insert City Trigger Output

13. Blood_Donor & BloodSpecimen View

14. Conclusion of Project Studied recent research to identify inefficiencies in existing blood bank systems Developed a centralized repository to integrate blood banks, hospitals, patients, and donors Designed an ERD, identified necessary entities, and created a normalized relational model. Created SQL tables, inserted sample data, and tested database performance

15. Future Work 1 2 3 4 Designed for future scalability with cloud technology. Plans for SMS integration to send alerts and notifications Enables easy transformation into a cloud server for blood banks Enhances user experience with mobile updates.

16. THANKS! Does anyone have any questions?