Step 1: Design the database for both of the problems. Each blog post (and video) will have comments. Please add a “Comments” entity to each of the problems.

Step 2: Populate the database with some sample data and write sample queries for accessing the content and comments of a specific post.

Two small PHP problems

1) Assume that in the blog management system. you have all the information about the Post_ID, Post_Title, and Post_Body in an array (create an array with sample info about four posts). Run a loop on this array and create the content of the “List of the posts” you create in the week one assignment.

2) Assume that in the video management system. you have all the information about the Video_Id, Video_Title and Video_Description, and Video_Link in an array (create an array with sample info about four videos). Run a loop on this array and create the content of the “List of the Videos” you create in the week one assignment.