Nora Ambrosius

HR & Information Management Professional

Nora Ambrosius

nora.e.ambrosius@gmail.com

Database Prototype

Below is a MySQL database for a shoe store.

Click on an image to view the database and accompanying SQL queries.

Database Structure
SQL statement retrieving total sales by staff member.
SQL statement retrieving total sales by store location.
SQL statement to retrieve inventory details including the product name, ID, model, price, category and gross sales.