jewellery-designers-database-mods

MySQL database for a jewellery designer's store.

This is a MySQL relational database for a jewellery designer who hand crafts her own designs.

Initially five tables were built with primary and foreign keys.

The queries and data analysis are outlined the file, 'Project Requirements.png'.

Some visual analysis can be seen in the 'G-Tableau' folder.

The initial build and project queries are in the file 'JDornan-silversmithUK-mods.sql'.
This file also doubles as a presentation.

See the 'My EER Diagram.png' for the visual layout of the project.

The mysqldump is 'JewelleryStore_mods.sql' - use this to restore the database.
For macOS machines see the instruction file 'mysqldump-macOS-mods.txt' of how to create a mysqldump.