Question: Using the sakila databse. Answer in c + + . This program will modify the program you created for M 0 5 Programming Assignment 2
Using the sakila databse. Answer in c This program will modify the program you created for M Programming Assignment Take the program and add a menu option for adding a rental. This should call a function that sets up to run a transaction that will insert everything needed for the rental. You should start by asking which customer the rental is for by using a printed menu. The menu should allow the user to choose from a list of customers, displayed as id firstname lastname. Next, you will need to find out which movie is being rented, and which staff member is entering the rental. You should again use printed menus to gather this information. Once the user has entered all the information, you will need to insert the rental record and payment record using a transaction sent to the database. Sample Output
Welcome to Sakila
Please choose an option enter to quit:
View the rentals for a customer
View Customer Information
Enter a Rental
Please choose the customer for the rental enter to go to the next page:
MARY SMITH
PATRICIA JOHNSON
Please choose the film you want to rent enter to go to the next page:
ACADEMY DINOSAUR
ACADEMY DINOSAUR
Please choose the staff member logging the transaction:
Mike Hillyer
Jon Stephens
Rental and Payment entered successfully. Rental Id: Payment Id:
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
