Design two stored procedures as the following (4 marks) Create a PARAMETER based SELECT QUERY stored procedure which return records based on parameters? > Create an UPDATE query based stored procedure
plz quickly ??????????????
/*Inserting into patient table*/
INSERT INTO patient
VALUES ('1234','Kim Minji','06-05-1994','0557375017');
INSERT INTO patient
VALUES ('1334','Han Sohee','06-07-1996','0567374017');
INSERT INTO patient
VALUES ('1434','Jeon soyeon','07-10-1998','0537372017');
INSERT INTO patient
VALUES ('1646','Lee Taemin','18-06-1993','0501346257');
INSERT INTO patient
VALUES ('1645','Yu jimin','11-09-2000','0501846257');
select*from patient;
/*Inserting into Doctor table*/
INSERT INTO DOCTOR VALUES(2000432, 'khaled' , '05-12-1994' , 0556677880,
'Dermatologists');
INSERT INTO DOCTOR VALUES(2000509, 'Ali' , '09-01-2000' , 0559918100, 'Dentistry');
INSERT INTO DOCTOR VALUES(2000389, 'Lewis' ,'21-01-1996' , 0559910000,
'Family Physicians');
INSERT INTO DOCTOR VALUES(2000504, 'Saleh' ,'16-06-1998' , 055611500,
'Family Physicians');
INSERT INTO DOCTOR VALUES(2000235, 'sara' ,'22-06-1998', 0557745500,
'Orthopedics');
select *from doctor;
/*Inserting into appointment table*/
INSERT INTO appointment VALUES (1, '12-08-21', '04:40',2000432,1234);
INSERT INTO appointment VALUES (2, '11-08-21', '06:00',2000509,1334);
INSERT INTO appointment VALUES (3, '04-09-21', '07:00',2000389,1434);
INSERT INTO appointment VALUES (4, '10-09-21', '01:46',2000504,1646);
INSERT INTO appointment VALUES (5, '17-10-21', '12:00',2000235,1645);
select *from appointment;
/*Inserting into drug table*/
insert into drug values(101,'Crocin',50);
insert into drug values(102,'Telmikind',130);
insert into drug values(104,'Combiflam',70);
insert into drug values(108,'Paracetamol',80);
insert into drug values(105,'Zocon',120);
select *from drug;
/*Prescription table*/
INSERT INTO prescription (pre_no,pre_date,pre_amount)
VALUES (10, '12-08-21', 100);
INSERT INTO prescription (pre_no,pre_date,pre_amount)
VALUES (11, '20-08-21', 150);
INSERT INTO prescription (pre_no,pre_date,pre_amount)
VALUES (12, '03-09-21', 200);
INSERT INTO prescription (pre_no,pre_date,pre_amount)
VALUES (15, '1-10-21', 250);
INSERT INTO prescription (pre_no,pre_date,pre_amount)
VALUES (16, '05-11-21', 350);
select *from prescription;
/*Receipt table*/
INSERT INTO receipt (r_no,r_date,r_time,pre_no,p_id)
VALUES (1, '12-08-21' ,'05:10' , 12, 1234);
INSERT INTO receipt (r_no,r_date,r_time,pre_no,p_id)
VALUES (4, '11-08-21', '06:30', 10, 1334);
INSERT INTO receipt (r_no,r_date,r_time,pre_no,p_id)
VALUES (5, '04-09-21', '07:30', 11, 1434);
INSERT INTO receipt (r_no,r_date,r_time,pre_no,p_id)
VALUES (9, '10-09-21 ', '02:06' , 15, 1646);
INSERT INTO receipt (r_no,r_date,r_time,pre_no,p_id)
VALUES (19, '17-10-21', '12:30', 16, 1645);
select *from receipt;
/*Prescription_drug table*/
INSERT INTO prescription_drug (drug_no,pre_no)
VALUES (101, 10);
INSERT INTO prescription_drug (drug_no,pre_no)
VALUES (102, 11);
INSERT INTO prescription_drug (drug_no,pre_no)
VALUES (104, 12);
INSERT INTO prescription_drug (drug_no,pre_no)
VALUES (108, 15);
INSERT INTO prescription_drug (drug_no,pre_no)
VALUES (105, 16);
select *from prescription_drug
Step by step
Solved in 2 steps
