How it works

Creating the database was fairly simple - all I needed to do was to simulate supply and demand. To achieve my goal, I added tables for locations, resources, supply and demand, as well as prices. The prices table had a 'buy' and 'sell' price (as well as location) which was the price you purchased the resource for, and the price you sold it for. 

The database contains information on the products, including their IDs, names, prices, and supply and demand values. The supply and demand values were randomly generated to simulate real-world fluctuations in supply and demand for products. The purpose of this database is to provide a means for tracking the inventory of products and determining the most profitable products to sell based on their supply and demand values.

The last step was to construct a query to retrieve the products with a supply greater than their demand, ordered by their greatest profit margin (buy price minus sell price). This query is important for the function of the project because it provides a way to identify the products that are in surplus and have the potential to generate the highest profits. By ordering the results by the greatest profit margin, the business can make data-driven decisions on which products to prioritize and adjust their pricing strategies accordingly. This query can be run periodically to ensure that the business is always selling the most profitable products and optimizing their inventory management.