📊 Database Management System I (MSSQL)

A complete repository of SQL solutions for **DBMS-I Lab Exercises** with a focus on relational database management using Microsoft SQL Server (MSSQL). Perfect for students and professionals aiming to master SQL and database design.

---

📚 Table of Contents

1. Introduction
2. Features
3. Technologies Used
4. File Structure
5. Getting Started
   • Prerequisites
   • Setup Instructions
6. Usage
7. Contributing
8. License
9. Contact

---

🚀 Introduction

Welcome to the DBMS-I Lab Repository! This project contains practical SQL query solutions to various lab exercises designed to strengthen your knowledge of relational databases using Microsoft SQL Server (MSSQL).

---

✨ Features

• 📚 Comprehensive Lab Exercises: Includes detailed solutions to SQL problems.
• 🔍 Wide Coverage of Concepts: From basic queries to advanced joins, subqueries, and aggregate functions.
• 🎓 Student-Friendly: Tailored for academic labs and assignments.
• 📈 Real-World Scenarios: Designed to help you apply SQL to practical use cases.
• 💡 MSSQL-Specific Syntax: Queries optimized for Microsoft SQL Server.

---

🛠️ Technologies Used

This repository utilizes the following:

• Microsoft SQL Server (MSSQL): For database creation and query execution.
• SQL Server Management Studio (SSMS): As the primary interface for writing and executing SQL scripts.

---

🗂️ File Structure

Here's how the repository is organized:

DBMS-I/
├── README.md                  # Project Documentation
├── SQLQuery Lab 1.sql         # Lab 1 solutions
├── SQLQuery Lab 2.sql         # Lab 2 solutions
├── SQLQuery Lab 3.sql         # Lab 3 solutions
├── SQLQuery Lab 4.sql         # Lab 4 solutions
├── SQLQuery Lab 5.sql         # Lab 5 solutions
├── SQLQuery Lab 7.sql         # Lab 7 solutions
├── SQLQuery Lab 8.sql         # Lab 8 solutions
├── SQLQuery Lab 9.sql         # Lab 9 solutions
├── SQLQuery Lab 10.sql        # Lab 10 solutions
├── SQLQuery Lab 11.sql        # Lab 11 solutions
├── SQLQuery Lab 12.sql        # Lab 12 solutions
└── try.sql                    # Experimental queries

---

💻 Getting Started

🔧 Prerequisites

Before you begin, ensure you have:

1. Microsoft SQL Server (2019 or later) installed and running.
2. SQL Server Management Studio (SSMS) installed for executing SQL scripts.
3. Basic knowledge of SQL to understand and execute the scripts.

---

📥 Setup Instructions

1. 🔄 Clone the Repository:

   git clone https://github.com/jaypatel342005/Database-Management-System---I.git

2. 📂 Navigate to the Project Directory:

   cd DBMS-I

3. 💻 Open SQL Files: Open .sql files (e.g., SQLQuery Lab 1.sql) using SQL Server Management Studio.

---

🎯 Usage

🛠️ Setting Up and Running the Queries

1. 🗃️ Create a Database: Use the following SQL command to create a database:

   CREATE DATABASE DBMS_Labs;
   GO

2. 📂 Switch to the Database:

   USE DBMS_Labs;
   GO

3. 📥 Execute SQL Files:

   • Open a .sql file in SSMS.
   • Execute the script to create tables, insert data, and run the queries.

4. 🔎 Modify and Experiment:

   • Test new queries.
   • Customize table designs or modify existing queries for better understanding.

---

💡 Contributing

Contributions are welcome to make this project even better! Here's how you can contribute:

1. 🍴 Fork the Repository:

   • Click on the "Fork" button on the top-right corner of this repository.

2. 🌿 Create a Branch:

   git checkout -b feature/YourFeature

3. ✏️ Make Your Changes and Commit:

   git commit -m "Add YourFeature"

4. 🔼 Push to the Branch:

   git push origin feature/YourFeature

5. 🔄 Open a Pull Request:

   • Go to your forked repository.
   • Click on "Compare & Pull Request".

---

📄 License

This repository is licensed under the MIT License. See the LICENSE file for details.

---

📞 Contact

For queries or feedback:

• Jay Patel - GitHub | Email

---

Made with ❤️ by Jay Patel

---

📝 Improvements

• Better Structure: Ensured a clean and readable hierarchy.
• Error-Free Commands: Fixed SQL syntax and adjusted for clarity.
• Clear Usage Instructions: Added steps for easier understanding.
• Consistency: Maintained uniformity in formatting and styles.