README.md

A menu driven database

1. description: A simple menu driven database written in C++ 11. It support general database functionalities like create and drop tables, insert and delete records, and display records in a table.

2. A quick demo:
   

3. how to run:

   • compile library.cpp and library_main.cpp
   • run the compiled executable

4. desgin structure:

   1. library.cpp and library.h are a library class contains all the functionalities for this database
   2. library_main.cpp is the main file that runs the database
   3. DBtables folder structure:
   

5. interface:

   • main interface:
     
     
   • show all schema:
     
     
   • create table:
     
     
   • insert records to table:
     
     
   • delete records:
     
     
   • drop table:
     
     
   • display records:
     
     

6. functionalities:

   • column length constraint
   • error and exception handling: e.g. column length must be an integer; column variable cannot contain space or punctuation except underscore _
   • optimization: insert and delete are stored in a vector, will operate(write to table or delete from table) only once