Thank you and help. I need help to create a SQL database that has the following especially the SQL statements:

A. Tables: Create at least four tables that will display the data that is important to the store owners. Identify the primary and foreign keys that are necessary to relate the tables. Include screenshots that show the tables you created.

B. Import Data: Use SQL statements to import the data into the tables you just created. You will come up with each of your data sets yourself. You should have at least five records for each table. Include screenshots that show the populated tables annotated with the SQL statements that you used.

C. Queries: After you have populated the tables, write queries to extract the data to answer the owners questions. Include screenshots that show each query and the corresponding query results.

Imagine that you have interviewed the store owners, Tom and Sarah Smith, and these are the questions with which they are most concerned: 1. How many books are sold each month by the publisher? This is important because quantity discounts are available from the publisher.

2. Which authors are the biggest sellers of books in our stores? This is important because the publisher offers discounts for certain authors each month.

3. What books are associated with each publisher?

4. What are the most popular products besides books that are sold in each store? In addition to books, the stores sell magazines, caf-specific products like coffee and pastries, and various gift products.

5. From what region(s) (by ZIP code) do customers visit our stores? This is important because it will assist with future marketing efforts.

6. What customer data must be stored for the e-commerce portion of the website?