ITI-DBMS_project

Bash Shell Script Database Management System (DBMS):

The Project aim to develop DBMS, that will enable users to store and retrieve the data from Hard-disk.

The Project Features:

The Application will be CLI Menu based app, that will provide to user this Menu items:

Main Menu:

• Create Database
• List Databases
• Connect To Databases
• Drop Database

Upon user Connect to Specific Database, there will be new Screen with this Menu:

• Create Table
• List Tables
• Drop Table
• Insert into Table
• Select From Table
• Delete From Table
• Update Table

Hints:

• The Database will store as Directory on Current Script File
• The Select of Rows displayed in screen/terminal in an Accepted/Good Format
• Ask about columns datatypes in create table and check on them in both insert and update -Ask about primary key in create table and check for it in the insert into table

steps for running the script

Enter in your terminal :

export PATH=$PATH:$(pwd)

project.sh

or simply :

. /project.sh

Demo

project demo