normalization-database

An Awesome Repository Containing All The Theory Lecture Slides and Lab Sessions With Code Files Taught At An Undergraduate Level At My University. Course Code: BTIT03105

Designed and implemented database schema for hotel reservation system. Identified key business metrics for the system and constructed complex SQL queries to retrieve desired information. Documented the entire system by developing comprehensive UML diagrams.

Simple Python program used to find potential functional dependencies from instances of a relation in a MySQL database

A website that displays all the information a fan might want, be it ball by ball statistics, batting statistics, interesting facts and much more!

Database operations developed with Java and MySQL for a DB course.

The code extracts the tables according to some configuration automatically, selects tables, filters, normalizes it, aggregates in different ways, imputes missing data and runs advanced descriptive methods. The methods used are the biplot, a method similar to PCA that allows to create an optimal representation of both the rows and columns to see the main patterns in the data.

This repository contains the two-part advanced SQL programming and database design capstone project made for the DTU Data Science course 02170: Database Systems

SQL Database for the customer care service of a Banking System

In this project, we are designing the database for the Graphics Design School named ‘Nexus’. A proper methodology of database systems has been followed starting with designing an ER Diagram for the database till the normalization of the schema till 3NF.

Foi criado um banco de dados simulando de forma mais simples, o banco de dados do Spotify

Online Railway Reservation System DBMS(project)

Manage a vast database of hospitals and clinic in a city and use it to find a hospital which caters all the needs of a user

In this exercise, I design a database to satisfy the third normal form (3NF) using SQL Workbench.

Eine Expressbasierte Lernanwendung für Normalformen in Datenbanken

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.