normalization-database

Desktop application: This project can be analyzed for Interviewers to see my way to build solutions using express version of MSSQL (Triggers, Store procedures, Functions, Querys and Recursive queries using CTE) embedded inside C# application, EntityFramework + Layer Pattern, Linq and WindowsForms with .NET Framework 4.6.2 in Visual Studio 2017

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

Utilization of some basic algorithms for the recogniton of one of the Iris plants among the three existing (Setosa, Versicolor, Virginica) using Java Object Oriented.

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 …

Final Assignment for DBS201(Summer 17)

Normalization of country names in most languages

A tool migration tooling has regenerated database

A database Normalisation and Scheduling Platform

CSCI 585 - Database System

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

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

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.

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.

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.

SQL Project of Database Management System for a Dentists Polyclinic

Created a database for people buying movie tickets in a theater

Takes Database and Functional dependencies as Input and checks Normalization form and converts up to BCNF.

A driver program to decompose a relation with violating functional dependencies into BCNF

Academic success measured against budgets.

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