DBMS_IITM :sparkles:

This repository contains solutions to the weekly assignments (2 & 3) of the Database Management Systems (DBMS) course offered by the Indian Institute of Technology Madras (IITM) as part of the Diploma in Programming program. Additionally, it also contains past OPPE solutions for the course.

Course Overview

The DBMS course covers the fundamental concepts of database management systems, including the relational data model, SQL, transaction management, concurrency control, and database design.

Folder Structure

The repository is structured as follows:

Week 2/
├── Practice.md
└── Graded.md
Week 3/
├── Practice.md
└── Graded.md
Week 7/
├── Ques1.md
├── Ques2.md
├── Ques3.md
├── Ques4.md
├── Ques5.md
└── Ques6.md
OPPE Python-PostgreSQL Questions/
├── Q1.md
└── Q2.md

How to Use this Repository

• Clone the repository

git clone https://github.com/NebulaTris/DBMS_IITM.git

• The Practice.md files contain practice queries for each week, while the Graded.md files contain graded queries.
• The OPPE practice questions for Week 7 are stored in separate files named Ques1.md through Ques6.md.
• The OPPE Python-PostgreSQL questions are stored in separate files named Q1.md and Q2.md.
• To use this repository, navigate to the desired folder and open the relevant markdown file in a text editor or browser.
• Use the solutions as a reference to check your own work and to learn more about the concepts covered in the course.

Notes

• The solutions provided in this repository are meant to be used as a reference only. It is recommended that you try to solve the assignments on your own before referring to the solutions.
• The solutions provided may not be the most optimal or efficient solutions. They are intended to serve as a starting point for your own work.
• This repository is not affiliated with the Indian Institute of Technology Madras or the Diploma in Programming program. The solutions provided are the work of the repository owner and contributors.

Contributing

Contributions to this repository are welcome. If you find any errors or would like to add more queries, feel free to create a pull request. Please ensure that your queries are organized according to the folder structure above.

Meme Time :sunglasses:

License

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