I need some help with my project proposal and its overview. it needs to include the following:

Title page o Include project title, your name, and date (and other information as you see fit)

Overview o General description of the project and supporting database

Justification o Why would you do this project?

What problem will this database solve?

What happens if you do not do this project?

Requirements o For each major feature:

Describe it

Explain why you need it

Design considerations

In this section, include:

All the tables and their relationships. For each table, include:

Table name

All attributes (field names and their data type)

Keys (primary, foreign, etc.) Note: This should be a diagram depicting the listed items as well As well as a process diagram

\

Scenario: BooksRUs is a local bookstore that started in 1978 in a small New England town. BooksRUs has been able to withstand the challenges of larger bookstore chains, as well as the internet giant Amazon.com, by offering new and used books and other products in a comfortable location that includes a caf with free WiFi. BooksRUs recently purchased another local bookstore called Great Books, USA, from an owner who is retiring. Both businesses use a simple bookkeeping system that includes Microsoft Excel. The owners of BooksRUs, Tom and Sarah Smith, would like a more efficient way to store inventory data and report on the various business essentials. They are also preparing to offer e-commerce on their website. A consulting firm has recommended capturing information in a database and linking access to the database for each store. Tom and Sarah purchased Microsoft SQL Server to do this. The consulting firm has hired you to complete the database for BooksRUs. In addition to creating the database, you will provide a report for your supervisor at the consulting firm; this report should describe the rationale for and proposed development of the database.

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?

Thank you for the help