IJSRD - International Journal for Scientific Research & Development| Vol. 2, Issue 01, 2014 | ISSN (online): 2321-0613 All rights reserved by www.ijsrd.com 242 Design and Implementation of Graphical User Interface for Relational Database Management System and Data Switching From Database Amruta Pimple 1 Tanvi Raut 2 Bhagyashri Redekar 3 Mrs. Sumitra Sadhukhan 4 1,2,3,4 Department of Computer Engineering 1,2,3,4 RGIT-Mumbai City Abstract— this paper will explain the concept of creating a Graphical User Interface for Relational Database Management Systems and switching through different database servers. There exists many database management systems with GUI, but they are exclusive to only one database. Also they do not facilitate switching between different databases. These limitations of the existing system are conquered by our system. This Software helps a user to do all database operations through a GUI provided with minimal knowledge of the database. Here user can do all database activities like Creating Table, Inserting Data, Joining two tables etc without knowledge of queries. Moreover, the queries can be executed very easily, since the user needs not to type any queries, but can simply select the appropriate options according to their requirements. The user can access the same database through different database servers by switching. Switching between the databases reduces the work of rewriting the queries for each of the database thus saving time. Also a Training mode is provided where user can learn a query for a particular database activity while performing it. Also user can listen to the query through a speak mode. I. INTRODUCTION DBMS consists of a collection of interrelated data and a set of programs to access those data. This collection of data is referred to as a database. A collection of conceptual tools for describing data, data relationships, data semantics and consistency constraints is called a data model. There are different data models, among which Relational Database Management System (RDBMS) is the most popular choice for large scale application. The RDBMS uses a collection of tables to represent both data and the relationships among those data. Each table has multiple columns and each column has unique name and fixed data type. Each table in the database has a unique name assigned to it. RDBMS is now being used in numerous applications outside the domain of traditional data processing. To interact with the database and work with the tables in it, one need to use Structured Query Language (SQL) which includes features on defining structure of the data, for modifying data in the database and for specifying security constraints. The project entitled ‘Graphical user interface for RDBMS is aimed at providing a user friendly and single interface for working with Oracle. Querying through GUI to execute complex as well as simple queries has proved to be an efficient system to people who do not have much knowledge about databases. Switching between the databases reduces the work of rewriting the queries for each of the database thus saving time. The Graphical User Interface generates the queries using Oracle as the database. Similarly other databases can also be used in order to execute the queries using databases such as MySQL, Sqlserver, MS access, etc with the GUI. This use of databases to generate the queries can be successfully implemented so that the work of writing full queries can be reduced and a non-technical user can also use it without having any knowledge of databases. II. EXISTING SYSYTEM We have many database management systems available in the market, many of them with friendly Graphical User Interfaces, using which the users can execute queries and handle tables and other objects. However, the GUIs provided by each database server are exclusive to its own database. Moreover, a person with little technical knowledge will find it difficult to use one. Also our system provides the facility of switching from one database to another. This facility is also not provided by any GUI based database server. Limitations of the Existing System 1) GUIs provided by most of the database is exclusive to its own database 2) Working with different databases through a single friendly interface is impossible 3) A GUI that provides a friendly environment to a user with little knowledge of SQL in such a way that he can work with more than one type of databases is hard to find. 4) Also the existing system does not provide the facility of switching the data from one database to other without making any changes to the data and in an easier way. III. PROPOSED SYSTEM The product entitled GUI for RDBMS is developed with the keen intention of creating a Graphical User Interface for commonly used Relational Database Management System like My SQL, Oracle. This is a general-level GUI, which can be connected to more than one database residing on the system. As a result, any database manipulation can be performed using a single product. Moreover, the queries can be executed very easily, since the user need not type any queries, but can simply select the appropriate options according to their requirements. Also helps in switching