06-01-2011, 12:45 PM
[attachment=7961]
Submitted by:
Neelima Chauhan
Shikha Chawla
Department of Information Technology
Arya Institute of Engineering & Technology,Jaipur
ABSTRACT
Computer programming is an art. It is a way of explaining how a Specific task is to be performed by a given computer driven by speedy development in the underdevelopment of the project.
Engineering is not only a theoretical study but it is a implementation of all we study for creating something new and making things more easy and useful through practical study.
Therefore in VII SEM engineering student of Computer Science branch are required to develop application software in project. It makes us learns that how to work as a team in industry. For us it is very knowledgeable and interesting as well. We have chosen Advanced Java as front end and Microsoft Access as back end.Now about the project, this is Oracle Simulator software which lets the end user to perform their work using GUI’s without having knowkedge about SQL Queries.
OBJECTIVE & SCOPE
Objective & scope-
This project is made to let the user to perform his work using GUI without having knowledge about SQL Commands.This is based on JAVA. It is used as front end tool. I have also used MS Access as back end tool. The project has been completed in sixteen weeks. As we know that today the world is pacing with a great speed and accordingly we are pacing to coordinate. In this situation humans have become so much busy that they don’t want to write Sql Queries, need front-end of Simulator so that they can easily run queries without wasting their time in making queries. This is the reason for developing such an application like Simulator to reduce the burden of user. This project has many features. We can execute following queries:
DDL:We specify a database schema by a set of definitions expressed by a set of definitions expressed by a special language called a Data-Definition-Language.The DDL is also used to specify additional properties of the data.DDL has
• Create
• Alter
• Drop
• DML:It is a language that enables users to access or manipulate data as organized by the appropriate data model
• Select
• Insert
• Delete
• Update.
The project is useful for those users who don’t have knowledge about sql queries and want to execute queries.They can use simulator to execute the queries without wasting their time in making queries.It can execute queries such as one can manipulate the data in database by using the queries such as select the contents of the table or select the tuple of the table,delete the table or delete a particular row,update data in the database,insert data in the database.We can also drop table,alter the data of database,create the table. By this the user can execute queries in a user friendly manner ie using GUI .
Some advantages of this project are:
1. User friendly
2. No need to do extra effort
3. Data of each user is protected
4. Time saving
