03-11-2012, 02:00 PM
AUTOMATIC DATABASE SCHEMA GENERATION
AUTOMATIC DATABASE.docx (Size: 17 KB / Downloads: 94)
The Automatic.doc (Size: 33 KB / Downloads: 79)
Database Management.doc (Size: 44.5 KB / Downloads: 76)
Java web.doc (Size: 64.5 KB / Downloads: 70)
SYSTEM DESIGN.doc (Size: 139 KB / Downloads: 85)
Testing.doc (Size: 37 KB / Downloads: 62)
. The system.doc (Size: 22 KB / Downloads: 61)
ABSTRACT
The Automatic Database Schema Generation is a system, which allows the developers to focus on creating the database using the Graphical User Interface .The user have to fill the requirements in the interface and he can perform the database operations which he wants and can create the database. This project aims at creation of an automatic database schema generation. This project will be accessible to all developers and its facility allows developers to focus on creating the database schema on the basis of JSP while letting the application server define table based on the fields in JSP and relationships between them.
This system provides the following facilities.
This facilitates the user to focus much on application aspects leaving behind the database aspects.
This project allows users to generate database schema without having much knowledge of database Aspects.
Existing System:
There are many Database Management systems available today. The Database designer is familiar with any one of the database Management Systems. Let us consider a condition when a database designer required to design the schema for an application on different DBMS. He required to learn all the DBMS User Interfaces. Where some of them are GUI (Graphic User Interface) based and others are CUI(Character User Interface).
DRAWBACKS OF EXISTING SYSTEM:
Through this approach to alter or to edit a large database schema, It consumes more time for a Database Designer. The operations like altering the table structure, Editing the table, Dropping columns, searching for a column name, searching for a data in the table.. etc., To Design and alter the Database schema there exists different user interfaces for different DBMS.
Proposed System and its features:
The Automatic Database Schema Generation System provides the following features.
1. The Automatic Database Schema Generation System provides a Common User Interface to interact with all the databases.
2. Here the user interface is Graphical User Interface.
3. This application is a Web based Application.
4. Being a web based application it doesn’t require any client side installation.
5. Any number of users can interact with the system simultaneously.
6. Centralized database connectivity.
7. Using Session management the interaction more flexible and secure
REQUIREMENT SPECIFICATION:
The application Automatic Database Schema Generation , which is design to connect different DBMS using common Interface. All the major activities that are carried are used to Design the database schema transparent to the DBMS by using a GUI.