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

Question

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

Answer 1

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.