10:45 Done Practical Excercise 5 (9... Enter 5 Records to the above table INSERT INTO VEHICLERENT VALUES(1, "Honda', 'City', 'Car',TO_DATE('2018-02- 20','YYYY-MM-DD'), TO DATE(2018-02-23", "YYYY-MM-DD')); Create a stored procedure is named - rentCalculation [456] Replace 456 with your last 3 digits in your student number It has: :!!! LTE INSERT INTO VEHICLERENT VALUES(2, 'Hyundai', 'i20', 'Car',TO_DATE('2018-03- 10', 'YYYY-MM-DD'), TO_DATE(2018-03-13','YYYY-MM-DD')); a an input parameter which has name vehicleld and data type NUMBER. an output parameter which is named rentAmount and NUMBER data type. Assume the rent is 75$ per day Sample Output Execute the Stored Procedure to calculate the rent for a vehicle ( use any vehicle number except 1 or 2) Script Output x
10:45 Done Practical Excercise 5 (9... Enter 5 Records to the above table INSERT INTO VEHICLERENT VALUES(1, "Honda', 'City', 'Car',TO_DATE('2018-02- 20','YYYY-MM-DD'), TO DATE(2018-02-23", "YYYY-MM-DD')); Create a stored procedure is named - rentCalculation [456] Replace 456 with your last 3 digits in your student number It has: :!!! LTE INSERT INTO VEHICLERENT VALUES(2, 'Hyundai', 'i20', 'Car',TO_DATE('2018-03- 10', 'YYYY-MM-DD'), TO_DATE(2018-03-13','YYYY-MM-DD')); a an input parameter which has name vehicleld and data type NUMBER. an output parameter which is named rentAmount and NUMBER data type. Assume the rent is 75$ per day Sample Output Execute the Stored Procedure to calculate the rent for a vehicle ( use any vehicle number except 1 or 2) Script Output x
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
Related questions
Question
![10:45
Done Practical Excercise 5 (9...
A
Enter 5 Records to the above table
INSERT INTO VEHICLERENT VALUES(1, "Honda', 'City', 'Car,TO_DATE('2018-02-
20', 'YYYY-MM-DD'), TO_DATE('2018-02-23','YYYY-MM-DD'));
INSERT INTO VEHICLERENT VALUES(2, 'Hyundai', 'i20', 'Car',TO_DATE('2018-03-
10', 'YYYY-MM-DD'), TO_DATE(2018-03-13', YYYY-MM-DD'));
Create a stored procedure is named - rentCalculation [456]
Replace 456 with your 3 digits in your stud t number
It has:
an input parameter which has name vehicleld and data type NUMBER.
an output parameter which is named rentAmount and NUMBER data type.
Assume the rent is 75$ per day
Execute the Stored Procedure to calculate the rent for a vehicle ( use any
vehicle number except 1 or 2)
Sample Output
Script Output x
83
Task completed in 0.101 seconds
Total Rent for the Vehical Id 1 = 225
PL/SQL procedure successfully completed.
1
2
VEHICLE_ID MANUFACTURER MODELNAME TYPE
1 Bonda
2 Hyundai
RENT_DATERETURN_DATE
Car 20-FEB-18 23-FEB-18
Car 10-MAR-18 13-MAR-18
City
120
LTE
Note:
Paste the clear screenshots with outputs and code
Explain the code block briefly
FILE NAME:
Practical Exercise5YourFirstName (like Practical Exercise5Abu(Doc/Pdf))
:=](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F674600df-ac71-43bc-9fcf-4e9445ad35e7%2F400a1fd0-524e-4ced-b205-ba9dd2938132%2Fe0l2y97_processed.jpeg&w=3840&q=75)
Transcribed Image Text:10:45
Done Practical Excercise 5 (9...
A
Enter 5 Records to the above table
INSERT INTO VEHICLERENT VALUES(1, "Honda', 'City', 'Car,TO_DATE('2018-02-
20', 'YYYY-MM-DD'), TO_DATE('2018-02-23','YYYY-MM-DD'));
INSERT INTO VEHICLERENT VALUES(2, 'Hyundai', 'i20', 'Car',TO_DATE('2018-03-
10', 'YYYY-MM-DD'), TO_DATE(2018-03-13', YYYY-MM-DD'));
Create a stored procedure is named - rentCalculation [456]
Replace 456 with your 3 digits in your stud t number
It has:
an input parameter which has name vehicleld and data type NUMBER.
an output parameter which is named rentAmount and NUMBER data type.
Assume the rent is 75$ per day
Execute the Stored Procedure to calculate the rent for a vehicle ( use any
vehicle number except 1 or 2)
Sample Output
Script Output x
83
Task completed in 0.101 seconds
Total Rent for the Vehical Id 1 = 225
PL/SQL procedure successfully completed.
1
2
VEHICLE_ID MANUFACTURER MODELNAME TYPE
1 Bonda
2 Hyundai
RENT_DATERETURN_DATE
Car 20-FEB-18 23-FEB-18
Car 10-MAR-18 13-MAR-18
City
120
LTE
Note:
Paste the clear screenshots with outputs and code
Explain the code block briefly
FILE NAME:
Practical Exercise5YourFirstName (like Practical Exercise5Abu(Doc/Pdf))
:=
![10:45
Done Practical Excercise 5 (9...
A
CSAM - Database Programming -CSD 4203
Database Programming:
Practical Exercise #5
Term: 2022S
Student Name:
Student Number:
A vehicle is rented on a daily charge basis. Suppose total rent needs to be
calculated based on its rented and return dates using procedure.
Table Structure:
CREATE
VEHICLERE "(
VEHICLE_ID NUMBER(8,0) PRIMARY KEY,
);
MANUFACTURER VARCHAR2(75) NOT NULL,
MODELNAME VARCHAR2(20),
TYPE VARCHAR2(10),
RENT DATE DATE,
RETURN DATE DATE
Enter 5 Records to the above table
Q
INSERT INTO VEHICLERENT VALUES(1, "Honda', 'City', 'Car',TO_DATE('2018-02-
20','YYYY-MM-DD'), TO_DATE('2018-02-23', 'YYYY-MM-DD'));
INSERT INTO VEHICLERENT VALUES(2, 'Hyundai', 'i20', 'Car',TO_DATE('2018-03-
10', 'YYYY-MM-DD'), TO_DATE('2018-03-13','YYYY-MM-DD'));
Create a stored procedure is named - rentCalculation [456]
Replace 456 with your last 3 digits in your student number
It has:
LTE
an input parameter which has name vehicleld and data type NUMBER.
an output parameter which is named rentAmount and NUMBER data type.
Assume the rent is 75$ per day
Execute the Stored Procedure to calculate the rent for a vehicle ( use any
|||](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F674600df-ac71-43bc-9fcf-4e9445ad35e7%2F400a1fd0-524e-4ced-b205-ba9dd2938132%2Fq49otno_processed.jpeg&w=3840&q=75)
Transcribed Image Text:10:45
Done Practical Excercise 5 (9...
A
CSAM - Database Programming -CSD 4203
Database Programming:
Practical Exercise #5
Term: 2022S
Student Name:
Student Number:
A vehicle is rented on a daily charge basis. Suppose total rent needs to be
calculated based on its rented and return dates using procedure.
Table Structure:
CREATE
VEHICLERE "(
VEHICLE_ID NUMBER(8,0) PRIMARY KEY,
);
MANUFACTURER VARCHAR2(75) NOT NULL,
MODELNAME VARCHAR2(20),
TYPE VARCHAR2(10),
RENT DATE DATE,
RETURN DATE DATE
Enter 5 Records to the above table
Q
INSERT INTO VEHICLERENT VALUES(1, "Honda', 'City', 'Car',TO_DATE('2018-02-
20','YYYY-MM-DD'), TO_DATE('2018-02-23', 'YYYY-MM-DD'));
INSERT INTO VEHICLERENT VALUES(2, 'Hyundai', 'i20', 'Car',TO_DATE('2018-03-
10', 'YYYY-MM-DD'), TO_DATE('2018-03-13','YYYY-MM-DD'));
Create a stored procedure is named - rentCalculation [456]
Replace 456 with your last 3 digits in your student number
It has:
LTE
an input parameter which has name vehicleld and data type NUMBER.
an output parameter which is named rentAmount and NUMBER data type.
Assume the rent is 75$ per day
Execute the Stored Procedure to calculate the rent for a vehicle ( use any
|||
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY