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!


No comments. Be first!

Leave a comment

Ask Your question

New on Blog