This repository contains SQL queries, database schemas, and practical assignments from the Database Management Systems (DBMS) Lab. It serves as a reference for students and professionals learning SQL and database concepts.
- ✅ SQL queries for basic to advanced operations
- ✅ Database schemas for real-world applications
- ✅ Normalization and ER diagrams
- ✅ Stored procedures, triggers, and functions
- ✅ Transaction management and indexing
- Database: MySQL / PostgreSQL / SQLite
- Languages: SQL, PL/SQL
- Tools: MySQL Workbench, pgAdmin, DBeaver
- Install MySQL or PostgreSQL
- Install DBeaver (optional for GUI support)
# Clone the repository
git clone https://github.com/PunitTak2005/dbms-lab.git
cd dbms-lab
# Open MySQL/PostgreSQL and run SQL scripts
mysql -u root -p < scripts/schema.sql- Fork the project
- Create a new branch (
git checkout -b feature-branch) - Commit changes (
git commit -m 'Add feature') - Push to GitHub (
git push origin feature-branch) - Open a Pull Request
This project is licensed under the MIT License - see the LICENSE file for details.
👤 Punit Tak
📧 Email: punittak2005@gmail.com
🔗 LinkedIn: Punit Tak
📂 GitHub: PunitTak2005