Welcome to my Database Projects repository! This collection includes various SQL-based projects focused on database design, schema creation, data manipulation, and real-world use cases involving students, colleges, and skills. These projects are built using MySQL and designed to help students understand the fundamentals of relational databases.
- Database Schema Design
- Normalization (1NF, 2NF, 3NF)
- Relationships (1-to-1, 1-to-many, many-to-many)
- Primary and Foreign Keys
- SQL Queries (SELECT, JOIN, INSERT, UPDATE, DELETE)
- Real-world Modeling: Student ↔ College ↔ Skills and many more
| id | name | age | college_id |
|---|---|---|---|
| 1 | Alex John | 20 | 101 |
| id | name | location |
|---|---|---|
| 101 | Sikkim University | Gangtok |
| id | student_id | skill |
|---|---|---|
| 1 | 1 | Flutter Dev |