Course: COL362(Fall'18): Database Management Systems

Assignment 2: SQL Queries on IPL Database

Creators: NAVREET KAUR(2015TT10917), SIDDHARTH KHERA(2015MT60567)

This assignment deals with the Indian Premier League dataset. It contains information about 568 cricket matches played in the duration from 2008-2016. The datasets are available in the 'data' directory.

Files:

1. schemas.sql: Defines and creates Schemas of the tables in the database
2. load_data.sql: Loads the data into the schemas created by schemas.sql
3. queries.sql: SQL queries corresponding to the Natural Language Queries in NLQuery.txt

Instructions:

Run the files in this order: 1 > 2 > 3