Introducing 

Prezi AI.

Your new presentation assistant.

Refine, enhance, and tailor your content, source relevant images, and edit visuals quicker than ever before.

Loading…
Transcript

Blood Bank Database Management System

Database Tables

Blood_Bank (Bank_id, Bank_Name, Admin_Name, Admin_Surname, Address, Pin, City, State, Contact, Email, Password)

Blood (Bank_id, apove, aneve, bpove, bneve, opove, oneve, abpove, abneve)

Events (Event_id, Bank_id, date, address, city, state, contact, description, organized_by)

User_registration (ID, Event_ID, First_name, last_name, email, birth_date, contact, sex)

DB Queries

E-R Diagram

Class Diagram

User Stories

var StringQuery = "insert into blood_bank (bank_name, admin_name, admin_surname,password, email, address, pin, city, state, contact) values( \'"+bankName+"\',\'"+AdminName+"\',\'"+AdminSurname+"\',\'"+encpassword+"\',\'"+email+"\',\'"+Address+"\',\'"+zipcode+"\',\'"+city+"\',\'"+state+"\',"+phone+")";

var StringQuery = "select bank_id from blood_bank where email=\'"+email+"\'";

var StringQuery = "insert into blood (bank_id) values ("+bankId+")";

General User

Blood bank Admin

Blood Bank Database Management System

Functionality

Architecture

Search for Blood

CMPE 226 - Team 12

Update Blood Quantity

Organize Events

Register For an Event

Technologies

Database Screenshots

Learnings & Future Scope

We learned to use open source technologies

Our Website

Mobile Application with Notifications for Events

Distributed databases

Learn more about creating dynamic, engaging presentations with Prezi