Create video store database in mysql create a table called

Question

Create 'Video Store' database in MySQL.

Create a table called "movies" with below information:

movie_id	movie_name	movie_date	movie_length	movie_director	genre
1	The Shawshank Redemption	1994	122	Frank Dirabont	Crime
2	The Godfather	1972	175	Francis Cappola	Crime
3	The Godfather Part 2	1974	222	Francis Cappola	Crime
4	The Dark Knight	2008	152	Christopher Nolan	Action
5	Schindler's List	1993	195	Steven Spielberg	Drama
6	12 Angry Men	1957	96	Sidney Lumet	Crime
7	Pulp Fiction	1994	154	Quentin Tarantino	Crime
8	The Lord of the Rings	2003	201	Peter Jackson	Action
9	The Good, the Bad and the Ugly	1966	161	Sergio Leone	Western
10	Fight Club	1999	139	David Fincher	Drama
11	Forrest Gump	1994	144	Robert Zemeckis	Drama
12	Inception	2010	148	Christopher Nolan	Action
13	Goodfellas	1990	146	Martin Scorsese	Drama
14	The Matrix	1999	136	Lana Wachowski	Action
15	City of God	2002	130	Fernando Meirelles	Crime
16	It's a Wonderful Life	1946	130	Frank Capra	Drama
17	The Usual Suspects	1995	106	Bryan Singer	Crime
18	Spirited Away	2001	125	Hayao Miyazaki	Adventure
19	Saving Private Ryan	1998	169	Steven Spielberg	Action
20	City Lights	1931	87	Charles Chaplin	Comedy

Create a table called "customers" with below information:

cust_id	cust_name	cust_address	cust_city	cust_state	cust_phone
1	John Wilkins	456 Alberta Ave	Topeka	KS	4629349456
2	Albert Fonso	657 Sifter Road	Phoenix	AZ	4238593512
3	Susie Cue	987 Mull Ave	San Jose	CA	9874639554
4	Rosie Sims	987 Tiffany St	Tucson	AZ	4657389253
5	Tommy Jones	7654 Ribbit Circle	New York	NY	4485693045
6	Matt Smith	124 Lowe Tide Rd	San Francisco	CA	7594123465
7	Stephen Storch	345 Loft Ave	Sacramento	CA	9874561234
8	Lucy Mills	1756 Guadalupe Ave	San Jose	CA	2233473056
9	Jenny Tims	923 Ifter Circl	Miami	FL	7750982354
10	Susan Quats	1752 Ross Rd	Phoenix	AZ	8546034455

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

movie_id

date_checked_out

date_to_return

chkout_charge

customer_id

customer_name

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.