COL362 - Introduction to Database Management Systems

This repository holds my attempts at assignments completed for COL362 at IIT Delhi.

Assignments

1. Assignment-1: SQL DML Queries
2. Assignment-2: SQL DDL Queries, Views, Triggers
3. Assignment-3: B+ Tree Index, Extendible Hash Index, Bitmap Index

Git LFS

Some files in this repository exceed the 100MB file size limit enforced by GitHub. To track such files, Git LFS is used.

How to setup Git LFS?

1. Install Git LFS on your system using -

   sudo apt-get install git-lfs
   

2. Setup Git LFS for your user account using -

   git lfs install
   

3. Add the files you wish to track using Git LFS.

   git lfs track <file-paths>
   

4. [Optional] If these files are not tracked using LFS in your previous commit history on your local machine, you can modify using -

    git lfs migrate import --include="<file-paths>"
   

5. Add .gitattributes file and commit the changes.

   git add .gitattributes
   git commit -m "Finish setup for Git LFS"
   

6. Push the changes to GitHub

   git push
   

Git Subtrees

Git subtrees is a cool feature to manage "nested repositories". It is a cleaner (?) alternative to git submodules. The starter code for assignment-3 was hosted on GitLab. I use this feature here to efficiently manage the two repositories (and learn git subtrees :)).

Check out A3/README.md to read more about git subtrees.