Based on the Bookstore database design created in Assignment 5 (you can use the ERD we constructed in class). Use the appropriate SQL commands to:)…

Based on the Bookstore database design created in Assignment 5 (you can use the ERD we constructed in class). Use the appropriate SQL commands to:1.) Create the database2.) Create the tables including appropriate data types3.) Create appropriate foreign key constraints4.) Add data including at least 5 authors, 5 books, 5 customers, and 5 transactions. Make sure at least two books have multiple authors.5.) Create the following queries:•a query that joins the tables and displays all authors and books.•a query that joins the tables and extracts all information you would need to create an invoice.•create two additional queries of your choice that displays the data in a way that could be useful.6.) Create a mysqldump of your database and upload it to the assignment. Also, submit a hard copy of your four queries and the results they produce.