08-17-2017, 12:13 AM
Graphical user interfaces are so called because we use mouse to point at graphical objects such as windows, menus, icons, buttons and other tools on the screen these graphical tools all represent different types of commands the GUI enables us to issue commands to the computer by using visual objects instead of typing commands this is one of the key advantage of the Graphical User Interface it frees us from memorizing and typing text commands
SCOPE OF THE PROJECT
The scope of the project lies in creating an interface in JAVA for a GUI tool and main objective of the project is to develop a GUI tool for Oracle installation
We use three concepts of Java they are SWINGS, JDBC, AWT s and also an interface Oracle (SQL PLUS).
A GUI tool would be the best thing to implement as it is more users friendly and must to people who have used a computer have used a GUI in some form or other wise most will not have used a command line interface.
EXISTING SYSTEM
In this we use SQL PLUS as a tool provided by the Oracle for data base installation
Since it provides the user full access to the database ,it is a command line interface
Using SQL PLUS tool we can access through a terminal window on a unix / linux machine or a telnet window on a PC with in the organization.
So people who are not having any computer knowledge it is a difficult task to learn and use it
PROPOSED SYSTEM
In this we provide a GUI tool for Oracle installation
This GUI tool is more user friendly compared to SQL PLUS
Using this GUI tool the user can easily access the tables with in their data base and create, edit or delete data or tables themselves with in their own database
So it is easier to adapt GUI tool for accessing the database rather than command line interface.
MODULE DESCRIPTION
There is only one module in this application Administrator and user.
The user is prompted for a username and password. Once these are entered the user is able to access the tables within their database, and create, edit or delete data or tables themselves with in their database.
The Administrator do not allow the users to access the other databases or to any of the functions used to administer the database it self.
USERS
1. USER
2. ADMINISTRATOR
PRODUCT FEATURES
SQL PLUS tool can be accessed through a telnet window on a PC within the organization. The method of connecting is a command typed in by the user and then prompted for a username and password. Once these are entered the user is able to access the tables within their database and can create, edit , or delete data or tables themselves, with in their own database. The permissions for users to access the database are provided by Administrator who checks the database, modifies etc.
HARDWARE REQUIREMENTS
System:
P II 500 Mz or above
125 MB RAM
100 MB Free Hard Disk space
STD Color monitor
SOFTWARE REQUIREMENTS
Operating System used:
Window XP : In this we have features like digital media support, advanced Networking and communications, advanced mobile computing added with efficient security.
Frond End : JAVA Technology ie both a programming language and a platform
Back End : DBMS is a soft ware tool that enables us to add, view and work with the data in a database.