Database Web Interface
Question Description
Part 1) Database design
This week you are going to design the database for the problems in Week One Assignment.
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.
Blog Management System
—————————————————-
Post
|
Post_Id |
Post_Title |
Post_Body |
|
1 |
Title 1 |
Body 1 |
|
2 |
Title 2 |
Body 2 |
|
3 |
Title 3 |
Body 3 |
|
4 |
Title 4 |
Body 4 |
Comment
|
Comment_Id |
Comment_Body |
Post_Id |
|
1 |
Title 1 |
Body 1 |
|
2 |
Title 2 |
Body 2 |
|
3 |
Title 3 |
Body 3 |
|
4 |
Title 4 |
Body 4 |
Video Management System
—————————————————-
Video
|
Video_Id |
Video_Title |
Video_Description |
Video_Link |
|
1 |
Title 1 |
Description 1 |
Link_1.mp4 |
|
2 |
Title 2 |
Description 2 |
Link_1.mp4 |
|
3 |
Title 3 |
Description 3 |
Link_1.mp4 |
|
4 |
Title 4 |
Description 4 |
Link_1.mp4 |
Comment
|
Comment_Id |
Comment_Body |
Video_Id |
|
1 |
Title 1 |
Body 1 |
|
2 |
Title 2 |
Body 2 |
|
3 |
Title 3 |
Body 3 |
|
4 |
Title 4 |
Body 4 |
Part 2) 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.
Note: For part 2, you do not need to access the database created in part 1. These two parts are independent (for now). Next week we will talk about combining these two parts.
Part 3) One more problem will be added
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."
