MySQL DB task to create a Design DB model for Guvi Zen class

One to one, one to many, many to many relationships, on delete set null and cascade examples and querying in both Django and Postgresql.

A PostgreSQL relational database for a Physical and Digital Library Management System. Demonstrates schema design, normalization, foreign keys, JOIN queries and SQL aggregation. Designed by Noreen Lewis | DataViz Explorer®

Using PostgreSQL to query an employee database. Creating an ERD to showcase relationships between database tables. Using primary keys and foreign keys.

A app where use of foriegn key is illustrated along with the validation of forms

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.

A challenge that uses PostgreSQL to perform data engineering for the employee database.

SQL laboratory project for demonstrating creation and management of a personnel database with DEPT, JOB, and EMP tables. Includes table creation, foreign key relationships, sample data insertion, and aggregate / analytical queries (Databases II, UNIWA).

A repository with our team's final SQL project in MGMT 582 Management of Organizational Data course at Krannert School of Management, Purdue University.

SQL Server 建立 Foreign Key 限制條件時使用 WITH NOCHECK 的差異範例

A tool to visually represent database table connections. Supports MySQL/MariaDB/Postgres.

This project is a social networking website. The highlights of this project include various design patterns implemented to ensure a robust and maintainable application architecture.

Developed a program that Generates SQL Statements to Check Normalization in One Table and Normalize It If Needed. [Python and PostgreSQL]

Virtual Library is a relational database project built with **MySQL** that models the core functionality of a library system. It manages users, books, writers, and book loans, including loan status, expected return dates, and delayed bookings.

A Hibernate ORM extension that provides a convenient way to define foreign keys through annotations on entity fields.

Web development project built with Django framework (added to my website www.vbbpickaclick.com)

Projet SQL MySQL de géopolitique fictive — modélisation d'un monde alternatif avec création de pays, alliances, guerres et batailles, basé sur la base de données world. Inclut des transactions de redécoupage territorial (Europe, Asie, Amériques).

IMDB design using SQL

Master's degree. Relational databases: Concepts & Techniques

This is a project about creating a Clinic Database from a diagram.