Skip to content

Latest commit

 

History

History
16 lines (12 loc) · 1014 Bytes

README.md

File metadata and controls

16 lines (12 loc) · 1014 Bytes

SQL Sales Database Design & Evolution

📌 Project Overview

This repository demonstrates a complete workflow for designing and evolving a relational database. It moves beyond basic table creation to show how a database schema can be modified and improved over time to meet changing business requirements.

🛠️ Advanced DDL Skills Demonstrated

  • Schema Architecture: Designing normalized tables with strict data types for a Retail Sales ecosystem.
  • Database Evolution (ALTER): Utilizing ALTER TABLE statements to modify existing structures, add columns, and refine constraints without data loss.
  • Data Integrity & Defaults: * Implementing Default Constraints to ensure consistent data entry.
    • Enforcing Primary & Foreign Keys for robust relational mapping.
    • Applying NOT NULL and UNIQUE constraints to maintain high data quality.

Related Projects