DBMS Tasks – SQL

This repository contains my DBMS lab work, including SQL practicals, assignments, ER diagrams, and normalization examples.

📁 Folder Structure

DBMS-Lab/
│
├── Practicals/
│   ├── Practical_01/
│   │   ├── problem.pdf
│   │   └── solution.sql
│   │
│   ├── Practical_02/
│   │   └── queries.sql
│
├── Assignments/
│   ├── Assignment_1.sql
│   └── Assignment_2.sql
│
├── ER-Diagrams/
│   ├── library_system.png
│   └── hospital_system.png
│
├── Normalization/
│   └── normalization_examples.md
│
└── README.md

🧠 Topics Covered

• SQL Queries (DDL, DML, DCL, TCL)
• Joins & Subqueries
• ER Diagrams
• Database Normalization (1NF, 2NF, 3NF)

🛠 Tools & Technologies

• MySQL
• SQL
• draw.io (ER Diagrams)

🎓 Purpose

This repository is created for:

• DBMS lab practicals
• College assignments
• Viva & interview preparation

👤 Author

Ram Sanap
BTech AIML Student