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

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

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

SQL Database for the customer care service of a Banking System

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

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

The Veterinary PostgreSQL Database Management System is a system designed to manage the data and records of a veterinary clinic. The system is designed to store and manage data related to animals, their owners, appointments, treatments, and medical histories

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 …

College Database Management System (Mini Project for DBMS subject)

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.

We have implemented Different types of normalizations techniques min-max normalization, Z-scale normalization, and decimal scaling normalization using menu- driven approach. We have used a user-input method for taking inputs from the user and perform normalization on the data value.

O componente curricular aborda conceitos básicos da teoria de banco de dados, arquitetura, organização, projeto e modelagem com ênfase no modelo entidade-relacionamento e modelo relacional, adotando uma linguagem para definição e manipulação de dados.

IPL Data Management is a relational database system which helps to store and retrieve Indian Premier League (Twenty20 cricket league that is annually held in India) data. Normalization techniques are applied on this relational database model to minimize the redundancy in the database tables.

O desafio simula um banco de dados similar ao do Spotify, no qual foi necessário lidar com dados brutos e não estruturados, aplicando técnicas de modelagem para estruturar o banco de dados de forma eficiente.

This is a Database Management System to manage complex data of Indian Premiere League (A cricket league).

Relational database for a hotel chain with multiple branches. Enables centralized management of users, rooms, and bookings, and includes decision-support queries on availability, occupancy, promotions, and customer behavior.