Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

I need some help with a database project I am working on

Question

I need some help with a database project I am working on: Write the Add/Change/Delete

Routines

Write the programs that will allow you to add a record, change a record, and delete a record for each of the tables in your database.

Need assignment help for this question?

If you need assistance with writing your essay, we are ready to help you!

OUR PROCESS

Order

Payment

Writing

Delivery

Why Choose Us: Cost-efficiency, Plagiarism free, Money Back Guarantee, On-time Delivery, Total Сonfidentiality, 24/7 Support, 100% originality

Done in MySQL

I have created a database which is a blood donation system. I have three tables which is data of patient, data of donar, and the data of blood banks. I need to write a procedure that will allow for data to be added, changed, or deleted for each table. I am having issues developing a procedure for each table where i can call the procedure and change the data. So i need help with the procedures. Here is my data which is done in MySQL Workbench:

CREATE DATABASE Blood

CREATE TABLE Blood.Patients
(
FirstName VARCHAR(20),
LastName VARCHAR(30),
PatID VARCHAR(10),
PatBloodGroup VARCHAR(2),
PAddress VARCHAR(30),
PPhone VARCHAR(11)
);

INSERT INTO Blood.Patients values (‘John’,’Doe’,’01’,’A’,’1234 E. Regular St.’,’4805551234′);
INSERT INTO Blood.Patients values (‘Jane’,’Doe’,’02’,’B’,’1234 E. Regular St.’,’4805551235′);
INSERT INTO Blood.Patients values (‘Max’,’Powers’,’03’,’AB’,’555 E. Makers St.’,’4805555678′);
INSERT INTO Blood.Patients values (‘Alex’,’Moran’,’04’,’O’,’678 N. Manning Way’,’4805556789′);
INSERT INTO Blood.Patients values (‘Thad’,’Castle’,’05’,’A’,’789 W. Elway Cir.’,’4805553456′);
INSERT INTO Blood.Patients values (‘Justin’,’Smith’,’06’,’B’,’890 S. Gallo St.’,’4805558901′);
INSERT INTO Blood.Patients values (‘Sarah’,’Nicks’,’07’,’AB’,’234 E. Helton Dr.’,’4805552345′);
INSERT INTO Blood.Patients values (‘Dawn’,’Sanders’,’08’,’O’,’345 N. Gonzalez St.’,’4805554567′);
INSERT INTO Blood.Patients values (‘Ed’,’Thomas’,’09’,’A’,’456 E. Nowhere St.’,’4805557890′);
INSERT INTO Blood.Patients values (‘Lindsay’,’Matthers’,’10’,’B’,’567 E. Elm St.’,’4805554739′);


CREATE TABLE Blood.Donors
(
DFirstName VARCHAR(20),
DLastName VARCHAR(30),
DonID VARCHAR(10),
DonBloodGroup VARCHAR(2),
DAddress VARCHAR(30),
DPhone VARCHAR(11)
);


INSERT INTO Blood.Donors values (‘Noah’,’Johnson’,’01’,’A’,’5670 Wilshire Blvd’,’4805551230′);
INSERT INTO Blood.Donors values (‘Liam’,’Brown’,’02’,’B’,’8001 Irvine Center Dr.’,’4805551231′);
INSERT INTO Blood.Donors values (‘Jacob’,’Jones’,’03’,’AB’,’4660 La Jolla Village Dr.’,’4805555672′);
INSERT INTO Blood.Donors values (‘William’,’Miller’,’04’,’O’,’576 Hawthorne Ave.’,’4805556783′);
INSERT INTO Blood.Donors values (‘Michael’,’Garcia’,’05’,’A’,’600 Anton Boulevard’,’4805553454′);
INSERT INTO Blood.Donors values (‘Emma’,’Rodriqeuz’,’06’,’B’,’890 N. LaSalle St.’,’4805558905′);
INSERT INTO Blood.Donors values (‘Olivia’,’Anderson’,’07’,’AB’,’350 N. 10th Ave.’,’4805552346′);
INSERT INTO Blood.Donors values (‘Sophia’,’Moore’,’08’,’O’,’840 N. Gateway Dr.’,’4805554567′);
INSERT INTO Blood.Donors values (‘Isabella’,’Jackson’,’09’,’A’,’411 E. Lafayette St.’,’4805557891′);
INSERT INTO Blood.Donors values (‘Emily’,’Lopez’,’10’,’B’,’201 W. 17th St.’,’4805554738′);


CREATE TABLE Blood.BloodBank
(
BankName VARCHAR(20),
BankAddress VARCHAR(30),
BankPhone VARCHAR(11)
);


INSERT INTO Blood.BloodBank values (‘United BloodServices’,’1989 W. Elliot Rd.’,’8778274376′);
INSERT INTO Blood.BloodBank values (‘Blood Systems’,’1337 S. Gilbert Rd.’,’4806321416′);
INSERT INTO Blood.BloodBank values (‘Biomat USA’,’535 S. Dobson Rd.’,’4808331598′);
INSERT INTO Blood.BloodBank values (‘CSL Plasma’,’711 N. Gilbert Rd.’,’6022185097′);
INSERT INTO Blood.BloodBank values (‘Blood Center’,’123 E. Bonfire Way’,’4805555555′);
INSERT INTO Blood.BloodBank values (‘UBS’,’234 N. Blade Ave.’,’4805551659′);
INSERT INTO Blood.BloodBank values (‘ARC’,’456 S. Vampire St.’,’4805556666′);
INSERT INTO Blood.BloodBank values (‘Blood Alliance’,’789 E. Red Cir.’,’4805551597′);
INSERT INTO Blood.BloodBank values (‘OneBlood’,’234 E. Plasma Dr.’,’4805459261′);
INSERT INTO Blood.BloodBank values (‘LifeSource’,’810 N. Dracula St.’,’4805558971′);

 
"Looking for a Similar Assignment? Order now and Get 10% Discount! Use Code "Newclient"