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)
);

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