mot-garage-database

This was built for my Data Modelling and Database Design Module (QAC020C123A).

Description

This is meant to represent that database model that a MOT garage might have.

This a dummy database, with dummy tables and dummy data.

Prerequisites

• sqlite3

Steps

1. Check sqlite3 version

Note

If this errors, you need to install sqlite3.

sqlite3 -version

2. Clone this repo

git clone https://github.com/gabrielg2020/mot-garage-database.git && cd mot-garage-database

Caution

Before running this command please make sure that you are in the correct directory.

find . -type f -name "*.sh" -exec chmod +x {} \;

3. Create database file

touch database/mot_garage_db.sqlite

4. Run rebuilding script

./rebuild_database.sh

Helper scripts

Display Tables

./display_table.sh <table_name>

List Tables

List all tables

./list_tables.sh <table_name>

Find a specific table

./list_tables.sh -f <table_name>

Run Query

./run_query.sh <1|2|3|4|5>