Bash Shell Script Database Management System (DBMS)

Main Menu:

Create Database: Allowed the user to create a new database, which was stored as a directory.

List Databases: Displayed a list of all databases (directories) stored in the current script directory.

Connect to Database: Enabled the user to connect to a specific database. Once connected, the user managed tables within that database.

Drop Database: Deleted a specified database and all its contents (the entire directory was removed)

.

Database Menu (Upon Connecting to a Database):

Create Table: Prompted the user to define the table name, columns, and their data types. The table was stored as a file within the connected database directory. The user specified a primary key, which was enforced during data entry.

List Tables: Displayed a list of all tables (files) within the connected database.

Drop Table: Deleted a specified table (file) from the connected database.

Insert into Table: Prompted the user to enter data for each column in the table, ensuring that data types matched the specified column types and that the primary key was unique.

Select From Table: Allowed the user to retrieve and display data from a table, which was displayed in a neatly formatted manner within the terminal.

Delete From Table: Removed specific rows from a table based on user-defined conditions.

Update Table: Enabled the user to modify existing data within a table, ensuring that updates complied with column data types and did not violate primary key constraints.