This project demonstrates the design of a normalized relational database schema for managing inventory, suppliers, orders, and customers.
The schema is designed for data integrity, low redundancy, and efficient queries. It includes SQL scripts for table creation, constraints, and example queries.
📂 dbms-sql-schema ├── schema.sql # Core database schema (tables, keys, constraints) ├── seed.sql # Sample data for testing (optional) ├── queries.sql # Example queries for analysis and reporting └── README.md
### 🚀 How to Use
1. Create a new database in **MySQL, PostgreSQL, or SQLite**.
2. Run `schema.sql` to build the database structure.
3. (Optional) Run `seed.sql` to insert sample data.
4. Test functionality with queries from `queries.sql`.
---
## 🛠️ Tech Stack
- SQL (DDL + DML)
- Relational Database Design
- ER Modeling