VIRTUAL DATABASE DESIGNING

[attachment=16459]

Proposed System

Proposed system i.e. VIRTUAL DATABASE DESIGNING simplifies the all cumbersome operations of original system. It simplifies all operations like DDL, DCL, DML, and TCL. It provides virtual interface to the user. Due to easy GUI user can perform the operations like creating tables, dropping table, creating views, applying constraints, renaming table names, inserting, updating, deleting etc in easy manner. This takes very less time to market, also no need to have thou rally knowledge of the Oracle, no need to learn Structured Query Language for accessing the Oracle. So isn’t it a short process? Really a gain over the older system!



Functional Requirement :

Login to System :

1) Accept username & password from user
2) Accept host-string if any from user
3) Pass these values to oracle database
4) Validate the user
5) Display the Menu form if the user is valid

DDL Operations:

Create :
1) Accept table name from user
2) Check whether it is already present
3) Accept column name, datatype , constraint from user
4) Make query string & pass it to oracle
5) Show message if table successfully created

Alter :
1) Accept table name from user
2) Accept parameter which user want to change in the table
3) Make query string & pass it oracle
4) Show message if structure of table successfully changed