LightBlog
Contact at mumbai.academics@gmail.com or 8097636691/9323040215
Responsive Ads Here

Friday, 2 February 2018

Corporate Help Desk


Corporate Help Desk


Abstract
OBJECTIVE:
  • The main objective of this application is to access any information from any where through online.
  • This helps the users by saving lot of time and provides the user with the up to date information.
Existing System:
Now days every organization uses sql plus tool to write sql commands in oracle database or in some other databases. As an industry norms database must be under control of database administrator, which means no other user can access the database but some times organization will give permissions to all users in that organization to access the database for some projects and also organization has to give permissions for their clients to access database but sometimes manually it is not possible. To avoid these types of problems UNIFIED DATABASE INTERFACE was introduced.
Proposed system:
UNIFIED DATABASE INTERFACE is an industry-standard tool for application development. Using Database Interface, developers can interact with any back end software (i.e. Oracle, SQL Server, MS-Access, My-SQL etc).  The UNIFIED DATABASE INTERFACE can be used to build, test, and debug PL/SQL packages, procedures and functions. UNIFIED DATABASE INTERFACE users can create and edit database objects such as tables, views, indexes, constraints, and users.  Database Interface's SQL Editor provides an easy and efficient way to write and test scripts and queries, and its powerful data grids provide an easy way to view and edit data related to any DBMS/RDBMS tool.
Project Analysis:
This application consist four modules:
1.    User Module
2.    Database level
3.    Table level
4.    Reports Module
 User Module:
This module tells all about users who are using UNIFIED DATABASE INTERFACE as user interface to interact with any database. While developing applications user need to get the data from the database.
Database level Module:
This module tells about the database, this module is categorized into the following functionalities:
Structure: This module gives the list of all tables which are present in the current/selected user. This module is used to browse and view the structure of an existing database object. It can also be used to design new database objects.
Properties:The properties functionality will gives entire information about database like database product name, product version etc. to the user.
SQL:By using this functionality, we can use and implement different kinds of SQL statements. The result of the SQL statement will be displayed immediately after executing the statement.
Import:By using this functionality any database structure along with data can be imported in this portal.
Export:By using this functionality any database structure along with data can be exported from this portal.
Operations:By using this functionality user can do some operations on tables of any Database like create table, alter table, rename table and drop table.
Search:By using this functionality user can search any keywords which are related to data in database.
Table level Module:
Structure:It gives the list of all columns which are present in the selected table. This module is used to browse and view the structure of an existing database object. It can also be used to design new database objects
Browse:By using Browse functionality user can change the table settings like display settings of information in the portal etc.
SQL:By using this functionality, we can use and implement different kinds of SQL statements. The result of the SQL statement will be displayed immediately after executing the statement.
Insert:By using this functionality user can insert data in to any table directly by giving values from user interface.
Export:By using this functionality any database structure along with data can be exported from this portal.
Operations:By using this functionality user can do some operations on columns of any table like alter column, rename column, drop column and empty column.
Search:By using this functionality user can search any keywords which are related to data in database.
Reports Module:
In this module administrator will get different types of reports regarding all the users who are registered in this portal.
Software Engineering Methodology:
Object Oriented Analysis and Design (OOAD Standards)
Software requirements:
Operating System            : Windows
Technology                        : Java/j2ee (JDBC, Servlets, JSP)
Web Technologies           : Html, JavaScript, CSS
Web Server                      : Tomcat
Database                           : Oracle (any database)
Software’s                       : J2SDK1.5, Tomcat 5.5, Oracle 9i                   
Hardware requirements:
Hardware                      Pentium based systems with a minimum of P4
RAM                             256MB (minimum)
Additional Tools:
HTML Designing                 : Dream weaver Tool
Development Tool kit          : My Eclipse

No comments:

Post a Comment