C++ SQL Database Management System

Name: Min Phone Myat Zaw

SQL Project:

• Developed a SQL Database in C++ from scratch over 16 days.
• Constructed all necessary objects and data structures used in a SQL DBMS.

Features:

• Implemented:

  • Full functionality of a SQL DBMS:
    • Create Table
    • Insert into Table
    • Select from Table with and without conditions
    • Drop Table
    • Batch processing (read commands from "batch.txt")
    • Error handling inspired by PostgreSQL

• Partly Implemented:

  • B+ Tree Remove prepared for DELETE but lacking disk management for DELETE operations.

• Bugs:

  • No known bugs.

Reflections:

• Data Structures and Algorithms were exceedingly interesting.

Output:

CREATE TABLE output:

INSERT INTO output:

SELECT output:

DROP TABLE output:

SHOW TABLES output:

BATCH output:

ERROR HANDLING output: