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 M05 Programming Assignment 2. 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 - first_name last_name. 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 -1 to quit):
1. View the rentals for a customer
2. View Customer Information
3. Enter a Rental
Please choose the customer for the rental (enter 0 to go to the next page):
1.1- MARY SMITH
2.2- PATRICIA JOHNSON
Please choose the film you want to rent (enter 0 to go to the next page):
1.1- ACADEMY DINOSAUR
2.1- ACADEMY DINOSAUR
Please choose the staff member logging the transaction:
1.1- Mike Hillyer
2.2- 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!