Simple Python program used to find potential functional dependencies from instances of a relation in a MySQL database
-
Updated
Jan 23, 2019 - Python
Simple Python program used to find potential functional dependencies from instances of a relation in a MySQL database
Database application from scratch. The project starts by selecting the application, then designing the database, obtaining and loading data into a real DBMS (MySQL), and writing SQL queries and Python client program with embedded SQL queries.
Normalization of country names in most languages
This project is centered around the organization and in-depth analysis of sales transaction data. The dataset includes key information such as customer details (name, address, city, country, region), product specifics (name, category, description, unit price), and sales metrics (quantity ordered, order date).
Python scripts for data preprocessing, SQL integration, and a normalized database schema, enabling efficient query handling and analysis of crime data.
Add a description, image, and links to the normalization-database topic page so that developers can more easily learn about it.
To associate your repository with the normalization-database topic, visit your repo's landing page and select "manage topics."