This repository contains files related to the conversion of data from CSV to a MySQL database. The primary focus is on ensuring security, standardization, and data integrity throughout the process.
- size_codes
- qcew_Maine_all_areas
- ownership_codes
- industry_lookup
- fips_lookup
- agg_level_codes
The CSV files were manually analyzed, and based on the fields and data types found in the CSV files, corresponding tables were created. Subsequently, the data from the CSV files were imported into the MySQL database.
- Source of CSV files: https://data.world/darrenfishell/covid-economy
To enhance security, UUIDs (Universally Unique Identifiers) were used instead of sequential numbers as primary keys in the tables.
All table and column names adhere to a consistent naming convention:
- Tables:
TAB_table - Columns:
tab_column
Ensuring data integrity is a top priority. Foreign keys have been employed to establish proper relationships between different tables, creating a robust and interconnected database structure.