php

Exercise 1 (Database) . Create a new database called 'Library' Create two tables in the database o First table name is 'Books' Second table name is 'Authors' o . o 1 1 The tables should contain the following columns Books table Book ISBN (Primary key) Book Title Book Author id Type (Novel, Science, ...) o Authors table Author Id Author name Author Country 1 1 O Fill table Books with the following data (use ready insert statements in myPhpAdmin) 1, C++ How to Program, 111, Programming 2, Jane Eyre, 222, Novel o 3, Visual C# how to program, 111, Programming 4, The 5 AM Club, 333, Human Development o O Fill table Authors with the following data (use ready insert statements in myPhpAdmin) o 111, Deitel, UK O 222, Charlotte Bronte, UK o 333, Robin Sharma, USA Exercise 2 (Website) Create a web page that displays in the first section, an HTML table that resembles the Database table Books (the same colums). Write a php code to retrieve all data from Books table, and create the html table rows with them. In the second section of the page, add html input elements that allows the user to enter A new Author's data (id, name, country). When pressing submit, the data will be submitted to a php code, and an insert statement is written to enter the new record (this is a bonus question)