Small-Scale Relational Database Management System

Abstract

In the proposed system, an implementation of a small-scale relational database management system (DBMS) has been presented. In this system, database is defined as a group of relations or tables and their corresponding schemas. A relational database maintains data in relations, which the user sees as tables. The proposed model has been developed using Java programming language and it stores data in the form of serializable files. JavaCC has been used as the parser generator. Each relation consists of tuples or records, and attributes or fields. Beginners find it difficult to learn and install commercial database management systems. The proposed system is easy to use and does not require an active internet connection. This system supports several SQL commands such as CREATE, SELECT, INSERT INTO, DELETE FROM, UPDATE, etc. This system also ensures preservation of data and referential integrity.