Create 'Video Store' database in MySQL.

Create a table called "movies" with below information:

Create a table called "customers" with below information:

Create a table called "rentals" that connects the two tables above with the following information:

Create a database model for the video store.

Use Foreign Keys to link between the "rental" table, "customer" table and "movie" table.

a. the rental table will need to link to the video that is checked out and the customer. Each customer should have a video checked out.

b. The rental table must indicate whether is has been checked out so another customer can't rent it.

c. The rental table needs an event that can generate a query of customers who are past due on rentals.

Create a localhost.php folder named VideoStore containing Web pages for your video store.

a. Create an index to the web pages

b. Create a simple input and search page for customers

c. Create a simple input and search page for the videos

d. Create a simple page for rental checkouts, including indication of overdue rentals.

Submit at least two backup files created by a schedule.