Data cleaning normalization using SQL
-
Updated
Oct 17, 2021
Data cleaning normalization using SQL
SQL scripts for commonly needed dimension tables.
Project focused on relational database structuring techniques, such as normalization, utilizing Oracle SQL and a PHP interface
A full-stack web application that provides searching and recommending for movies and TV series, built with ReactJS, NodeJS, and ExpressJS.
In this Full-Stack Group Project, I worked on RDBMS aspects such as ER design, db population, DDL, DML, and Flask
A comprehensive implementation of the Life Insurance Co. BYOD system. Includes ERD, MySQL scripts for database creation and population, detailed data definitions, normalization documentation, and SQL queries for IT management analytics. Demonstrates best practices in database design and management.
Takes Database and Functional dependencies as Input and checks Normalization form and converts up to BCNF.
It contains DataBase-MongoDB Installation and Introduction and Basic Methods with Examples
This repository contains the design and implementation of the AirMan System for managing airport operations at London Biggin Hill Airport. It includes an ERD diagram, MySQL scripts for database creation, data insertion, and queries, as well as detailed data definitions and system requirements documentation.
Revision for KCL Database winter exams. Includes SQL queries, database normalisation and data warehouse design.
A web-app hosted on AWS using a MySQL back-end database queried using dynamically generated, user-defined, complex SQL queries. Front-end user-interface designed using BootStrap.
This project is a combination of two project from Trybe on the start of my studies in MySQL queries. There are two databases and a bunch of different queries to practice MySQL queries.
This Event Management Software is designed to help employees like Event Managers /Event Organizers, Staff managers, etc in an event planning company to manage their work related to events efficiently.
Sample APIs for practice.
This Node JS command line application inputs a sample set of sales data and restructures it according to a normalized database design.
Database Systems course project, completed in two parts: designing an arbitrary relational database and implementing it by creating, loading and querying data to meet specified criteria. Each query was accompanied by detailed explanations. Developed during the spring of 2020.
Database for various events being held in the university
College assignments from Bryan University over creating relational databases (e.g. using MySQL or PostgreSQL) in connection with Express servers using both direct SQL statements and Object Relational Mapping approaches.
Deliverables relating to the Introduction to Databases and Information Systems University Unit
Add a description, image, and links to the database-normalization topic page so that developers can more easily learn about it.
To associate your repository with the database-normalization topic, visit your repo's landing page and select "manage topics."