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
![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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F991f4066-e468-4d12-b4a9-5310d2b523e8%2F3636e408-80cb-4d0a-9c7b-cde4b9aeb1c9%2F7qkz04_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
![Computer Networking: A Top-Down Approach (7th Edi…](https://www.bartleby.com/isbn_cover_images/9780133594140/9780133594140_smallCoverImage.gif)
![Computer Organization and Design MIPS Edition, Fi…](https://www.bartleby.com/isbn_cover_images/9780124077263/9780124077263_smallCoverImage.gif)
![Network+ Guide to Networks (MindTap Course List)](https://www.bartleby.com/isbn_cover_images/9781337569330/9781337569330_smallCoverImage.gif)
![Concepts of Database Management](https://www.bartleby.com/isbn_cover_images/9781337093422/9781337093422_smallCoverImage.gif)
![Prelude to Programming](https://www.bartleby.com/isbn_cover_images/9780133750423/9780133750423_smallCoverImage.jpg)
![Sc Business Data Communications and Networking, T…](https://www.bartleby.com/isbn_cover_images/9781119368830/9781119368830_smallCoverImage.gif)