Milestone 2 & final

Overview:

Provide a solution for Books’R’Us to track sales transactions in a SQL database. The database will allow them to monitor sales by region, author and publisher as well as non-book related items.

The benefit is to have a centralized system improving sales and inventory tracking as well.

Justification

This project will allow Tom and Sarah to move away from their Excel worksheet that limits access and usage to a more robust system with the addition of the second store. By having prebuilt queries for reporting, they will be able to track sales by publisher, author and by monthly sales.

If the project is not completed, they will continue to record transactions/inventory information in separate systems and a separate reconciliation for both stores. Using Excel also reduces the access to a single user per location as Excel does not handle relational data.

A complex system in Excel would be required such as the use of Pivot Tables would be required or a custom macro.