jewellery-designers-database

CFG Project: MySQL database for a jewellery designer's store.

This is a MySQL relational database for a jewellery designer who hand crafts her own designs. This was built for the Code First Girls 'Data & SQL' course June 2021.

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 '_Tableau' folder.

The initial build and project queries are in folder 'Build plus Core and Adv Queries'.

See the 'EER diagram.png' for the visual layout of the project.

The mysqldump is 'JewelleryStore.sql' - use this to restore the database. For macOS machines see the instruction file 'mysqldump on Apple mac.rtfd'