vtu-dbms-lab
============

This repository contains solutions to VTU DBMS lab queries.

To run queries


i) Create a database

```
mysql> CREATE DATABASE Test;
mysql> USE Test;

```

ii) Create tables. (Please use absolute path to file)

```
mysql> SOURCE ../vtu-cse-labs/vtu-dbms-lab/problem2/table_creation.sql

```

iii) Fill tables. (Please use absolute path to file)

```
mysql> SOURCE ../vtu-cse-labs/vtu-dbms-lab/problem2/fill_tables.sql

```

iv) Run queries. (Please use absolute path to file)

```
mysql> SOURCE ../vtu-cse-labs/vtu-dbms-lab/problem2/query2.sql

```

Update usage details for dbms lab
Update usage details for dbms lab
