Question: For this peer feedback discussion, you will create two MySQL database tables and write SQL scripts to insert and retrieve data that will be displayed

For this peer feedback discussion, you will create two MySQL database tables and write SQL scripts to insert and retrieve data that will be displayed with PHP on a webpage. The first database table will contain at least four of your favorite books. The second table will contain the four authors of those books. The third table will be an associative table that describes the relationship between the books and their authors. Books and authors have a many-to-many relationship, meaning a book can have multiple authors and an author can have multiple books.

  • Create a MySQL database with three tables.
  • Populate those tables with the corresponding information.
  • Create a SQL script to retrieve the authors and their books from MySQL that will be displayed on a webpage using PHP.

Once you have completed the assignment, include the following in your post:

  • Explain your strategy for creating the tables and PHP used to retrieve the information.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!