This repository focuses on developing and optimizing an e-commerce database. It includes comprehensive database design, advanced query techniques, and performance optimization strategies.

Репозиторий для курса "Базы Данных и Сетевые Технологии" - факультет ПМ-ПУ, СПбГУ

Large scale Database Design for an e-commerce website, featuring ERD, DB Scripts and optimizations applied while working with a large dataset of approximately 10 Million rows.

Проектирование баз данных, 7 семестр

A MySQL relational cyclone database including all NOAA recorded cyclones originating from the Pacific and Atlantic Oceans in 2014 designed and built complete with views and queries for predictive analysis purposes.

🗄️ SQL repository for the Databases course of the 1st year of the Web Development degree. It contains SQL scripts 📜 to create databases, queries 🗃️, entity-relationship diagrams 🧩, user and permission management queries 👥, and views 📊 of the databases.

This repository contains the semester project from the Database Systems (BI-DBS) course at CTU FIT, along with Oracle Academy certifications.

Designed a Database for an e-commerce website, including views and sample data and queries performed on it.

PostgreSQL database schema for mobile banking applications with PlantUML diagrams, banking standards compliance, and PayNow integration.

SQL data analysis & Database Manage,PostgreSQL,Oracle,MySQL,SQLServer

project of database course

A complete, production-ready database schema for an AirBnB. Features a fully normalized (3NF) PostgreSQL design with UUID primary keys, comprehensive constraints, sample data, and detailed documentation. Includes tables for users, properties, bookings, payments, reviews, and etc. with proper foreign key relationships and business rule enforcement.

Postgresql-based library database design and management system.

Arquitetura e composição do banco de dados do time de vendas da empresa DF paper company; objeto de estudo para a segunda avaliação da disciplina de Administração de Banco de Dados, ministrada pelo docente Diego Cardoso Borda Castro no Centro Federal de Educação Tecnológica da Celso Suckow da Fonseca durante o primeiro semestre de 2024.

This project develops a university course management database, handling student enrollments, course information, and program data. It features SQL views, functions, and constraints to rank students by course performance, enforce prerequisites, and maintain integrity through foreign keys and validation checks for consistent data management.

This repo contains the resources for my College course , Database Systems Design. This involves creating and structuring an entire Databse system for the school of engineering sciences in the University of Ghana as part of a group project 3.

👩‍🔧Freelancers Collective, Database laboratory, University of Tehran

A Database for building developers, operators, or managers!

PostgreSQL database for managing accounts, customers, transactions and loan payments with Docker deployment

Analyzing, modelling, scripting, administrating. All the data related work done in over a year excluding the actual applications.