Built an API using Express with Node that connects to an SQL database. It allows for
stock management, providing routes to add, edit, delete and retrieve product data
as well as manage customer orders.
The relational database allowed us to use a
table which joins customers and their orders, minimising the need for repeated data. The API will
add new customer data to the database but will re-use customer data for returning customers when
adding an order. It will also automatically update current stock quantity when orders are made,
giving reliable feedback on what stock is currently left to be sold.
When a new product is entered a unique SKU is generated which the product can be identified by.