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.
SQL Database for the customer care service of a Banking System
Database operations developed with Java and MySQL for a DB course.
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!
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 ...
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.
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.
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.
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.
This is a Database Management System to manage complex data of Indian Premiere League (A cricket league).
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."