OBJECTIVE:
The objective is to provide a user-friendly interface to communicate with any database. The application allows a user to query the database and execute any operation on the database.
EXISTING SYSTEM:
Each database system provides its own interface or tool to enable users to interact with the database. A user is required to learn the mechanisms of that tool before querying the database. When the database system is changed, a new tool will be used and user is supposed to learn this tool.
PROPOSED SYSTEM:
The proposed system is an industry-standard application for database development for any software project. Using this application, developers can interact with any database such as Oracle, MSAccess etc. The application can be used to build and test SQL. It can be used to create and modify database objects such as tables, views, constraints, users and others. Database Interface’s SQL Editor provides an easy and efficient way to write and test scripts and queries, and its powerful data grids provide an easy way to view and edit data related to any DBMS/RDBMS tool.
SOFTWARE REQUIREMENTS:
• Web Technologies : HTML, CSS, JS. JSP
• Programming Language : Java
• Database Connectivity : JDBC
• Backend Database : MySQL
• Operating System : Windows 08/10
HARDWARE REQUIREMENTS:
• Pentium processor : Core I3
• RAM Capacity : 2GB
• Hard Disk : 250GB
• Monitor : 15’’ Color Monitor