Can someone please assist with the attached VideoStore assignment?
Microsoft Word - At-Home Final Exam Project Requirements Completed At‐Home Project Requirements CIS276DA–MySQLDatabase Video Store At-Home Final Exam Project Summary Your database must contain records for at least 20 videos with pertinent information that might be useful to your customers, such as the title, production date, starring actors, producer, director, etc. Think about what you might look for when choosing a movie and use that information to help you with the database design. Since you have customers, you will need to support at least 10 customers’ data (using fictitious information). You will need information such as customer name, address, phone, email address, etc. Think about what information you might need as the owner of the store to contact your customers and track their patronage. Finally, your database will need a table that can keep track of rentals – a link between the customer and video tables that might contain the rental fee and keys for the customer, plus the key for the video that was rented. It will also need to track the date a movie was checked out and a due date. It might also track late check-ins and produce a query that can notify you of any late rentals. Here is a summary of the basic requirements. The details are provided below. 1. Use the cumulative document that you started in Lesson 4 and finished in Lesson 10 to help you with creating your video store database. 2. Create a database model for the video store. 3. Use the model to create the MySQL database and its tables. a. Incorporate the variables and data types that you listed in Lesson 4. b. Add any that were suggested by your instructor and others that you might have discovered later. 4. Use foreign keys to link between the rental table and the customer and video tables. a. The rental table will need to link to the video that is checked out. b. The rental table will also need to link to the customer who checked out the video. c. The video must indicate whether it has been checked out so that another customer can’t rent it. d. The rental table needs an event that can generate a query of customers who are past due on rentals. 5. Load the database with example customers and videos. a. Incorporate the video collection that you gathered in Lesson 5. b. Load a list of customers that uses fictitious names, addresses, etc. c. Include your own information for one of the customer records. 6. Create a localhost .php folder containing Web pages for your video store. a. Create an index to the Web pages. b. Create a simple input and search page for the 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. 7. Test and prove the functionality of the database and localhost access. 8. Document a backup and recovery strategy and implement it. a. Create a backup schedule. b. Submit at least two backup files created by the schedule. Create a final project folder for the course requirement documents. Even though some of these files may have been created in Lesson 10, recreate them for the At-Home Final Exam Project even if you don’t need to change the database definition. After your video store database and localhost user interface are working, create the minimum files required to support the above steps: 1. Save your cumulative document and add any revisions that you discovered while working on the final database project. Create a new VideoStoreModel.png if your tables changed between Lesson 10 and theAt-Home Final Exam Project. Save the revised document in your final project folder with the following filename: VideoStore_Final.docx 2. Use the following process to document your database model: a. Using the “File -> Save Model As…,” save your model to the final project folder with the following name: VideoStoreModel_Final.mwb b. Using the “Export -> Forward Engineer SQL Create Script…,” save your create command script to the final project folder with the following name: VideoStoreCreate_Final.sql c. Using the “Export -> Export as Single Page PDF…,” save your create commands to the final project folder with the following name: VideoStoreModel_Final.pdf d. Additionally, using the “Export -> Export as PNG…,” save your create commands to the final project folder with the following name: VideoStore_Final.png 3. The files you create in Step 2 will document database creation. 4. The files you create in Step 2 will document this table creation. 5. Query your video database by using a SELECT * for each table. To review the results of running the SELECT commands, create script files and run them, plus verify your results. If you need help with exporting the results, review the instructions from the Lesson 1 video Submitting Scripts and Query Results Demo. Name your SQL script files, run them, and export the .csv files, naming the files as follows, respectively: a. SELECT * FROM videos; Exported filename: results_videos.csv b. SELECT * FROM customers; Exported filename: results_customers.csv c. SELECT * FROM rentals; Exported filename: results_rentals.csv 6. Copy your entire .php folder with your video store index.php and other .php files used by the video store interface to the final project folder. (At a minimum, you will have video, customer, and rental .php files.) Be sure to include your name and MEID in each of your .php pages. 7. No files are needed for this step. All of the above files will allow the instructor to validate your database and localhost functionality. 8. Copy the .bat file that was used to schedule a backup to your final project folder. Copy at least two of the backed up files that you created with the scheduled backups to the final project folder. Make sure to include all of the tables, views, triggers, and events in the backups that you create. *** For d in section 4: "The rental table needs an event that can generate a query of customers who are past due on rentals.", ==> Please create a query of customers who are past due on rentals with the due dates of the rented videos. *** For in b and c of section 6: b: Create a simple input and search page for the customers. c: Create a simple input and search page for the videos. ==> These are an option. If you want to learn more about PHP, you can try them. Otherwise, you can skip them. *** If you can't get the WAMP server to run, you can just submit the php files for the web page requirement. The followings are the php files you have to submit only for the web page requirement. index.php customer_list.php video_list.php rental_list.php overdue_list.php videostore_pdo.php You don't have to create those php files from the scratch. You can modify the php files you did for the lesson 6 project. *** Good luck with your Video Store project!!!