databasedesign

The Student Management System is a Java and MySQL project that serves as an introductory exploration into database management. This project focuses on implementing fundamental database operations using Java programming language and MySQL. It includes features like simple connection pool, configuration loading, and basic database interactions.

This project demonstrates the creation of a Data Warehouse using SQL Server 2022. It includes the design of dimension and fact tables, ETL processes for data integration, Python scripts for synthetic data generation, and SQL queries for KPI analysis to support business decision-making.

This is a project for the database design course at Amirkabir University of Technology

Database Design and Implementation in MYSQL Workbench : College-Selection-Platform

A containerized automated ETL pipeline built with Python, PySpark, Spark SQL, PostgreSQL, and Docker.

Arquitetura de banco de dados para Fintech no SQL Server. Projeto completo com modelagem relacional, constraints rigorosas de integridade financeira, procedimentos armazenados transacionais e testes automatizados de regras de negócio.

A full-stack coffee shop management platform built with microservices architecture. Features include user authentication, menu management, order processing, real-time updates via WebSocket, admin dashboard with analytics, and Docker containerization. Built with React, Node.js, gRPC microservices, MongoDB, and deployed with CI/CD pipelines.

The project employed Oracle PL/SQL Developer; an RDBMS was engineered for streamlined university course enrolment. It commenced with precise ERD and DFD design using Lucidchart, enforcing data integrity via constraints, triggers, and sequences. Graphical reports showcased student performance and faculty acclaim, revolutionizing enrolment procedures

All About Backend - Mastery

Custom form support designed by user with unknown number and type of fields. SQL.

Database design for course app

This repository contains work related to SQL and Database Modeling and Design.

The goal of this project is to provide a service through which users can subscribe to tweets they can trust.

🚀 Exciting Quiz App 🧠✨ | Empower admins with Next.JS & Express brilliance! Create/manage quizzes effortlessly, elevate quiz-taking with dynamic questions. 🌐✨ User authentication, role-based access, sleek UI with Next.js & Redux. 🛠️ Seamless PostgreSQL & Prisma integration. 🏆 Flawless error handling! 🌟 #FullStackMagic #QuizMastermind 🚀🔥

🚀 Automate ETL processes with PySpark to transform and load transactional data into PostgreSQL for efficient analytics.

As part of my Database Systems course, I developed a fullfeatured e-commerce platform similar to Amazon. The website utilized a Node.js backend with Express framework and MySQL database, implementing secure user authentication, transaction management, and dynamic product catalog functionality.

In this repository, i have put an ER schema design for an University .

The database is built for a cloud computing platform that allows users to rent virtual computers to run their own computer applications.