66 843
Assignments Done
99,1%
Successfully Done
In October 2018

Answer to Question #3698 in Databases | SQL | Oracle | MS Access for Aashish Patny

Question #3698
I have to validate that these data exist
movie id = 13
member id = 10
payment method = 2

BEGIN
IF mrs_movieid = 13
then
ELSE IF
DBMS_OUTPUT.PUT_LINE('There is no movie with ID: '||movie_id||'Cannot proceed with rental.');
(IF mrs_memberid = 10
then
ELSE IF;
DBMS_OUTPUT.PUT_LINE('There is no member with ID: ||member_id||' Cannot proceed with rental.');
(IF mrs_paymentmethod = 2
then
ELSE IF
DBMS_OUTPUT.PUT_LINE('We don't have '||payment_method||' as a payment method.');
(IF mrs_movieqty => 0
then
ELSE IF
DBMS_OUTPUT.PUT_LINE('We don't have enough copies of said movie.' );
END IF;)
END IF;)
END IF;)
END IF;
i'm pretty sure i need more code but im not sure what to put
Expert's answer
Unfortunately, your question requires a lot of work and cannot be done for free. Submit it with all requirements as an assignment to our control panel and we'll assist you.

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

No comments. Be first!

Leave a comment

Ask Your question

Submit
Privacy policy Terms and Conditions