Category: Oracle Database Projects

This category consists of Oracle Database Projects Database Projects for CSE final year students,Oracle database projects free download with source code and PPT.

Posted on

Forest Department E-Timber Application SQL project

  •  Project Title              :    Forest Department E-Timber Application SQL project
  •  Software Requirements      :   SQL, PL/SQL, TOAD, ORACLE DB 10G

Project Description: The main aim of this Forest Department E-Timber Application project is to provide timber merchant information located in forest, the output of the project defines the navigation between the functions and specifies the actions available to the user of the application. The e-Timber application is specifically designed for the users handling Timber sales at Government Timber Depots of Forest areas. It keeps a track of the forest produce, which is put up for sale at the Depots and also provides information on revenue generated from application is designed for the Karnataka Forest Department. This project was developed with SQL server, Oracle database server.

Developer Responsibilities:

  • Understand the client requirements.
  • Involved in creating different tables like Circle, Division, Depot, Range, Depot_ Auction, and Auction_Purchaser and so on…
  • Involved in creating different stored procedures for binding the data from database.
  • Using Triggers, functions and procedures manage the transactions.
  •  Deploying requirement based on approved design.
  • Develop software for recording all events and transactions relating to transporting goods to designated depots, Classification in the depots, sales and realization of revenue.
Posted on

Attorney General VB.Net Project

  • Project Title   :  Attorney General VB.Net Project
  • Technologies  :  Vb.Net and Oracle 8.0

Project Description    :  “Attorney General” is a web based VB.Net application tool for advocates to maintain their office records. This final year B Tech project is very easy to operate and light on system to maintain details about clients and organize the client cases. This software application is developed with oracle database and VB.net.

Posted on

Bank Store Informatica Project

  • Project Title                          : Bank Store Informatica Project
  • Tools              : Informatica
  • Back End Server              : Oracle10G.

Project Description:

The main objective of this Bank Store Informatica Project is all about a customer information store. Solution is required to provide a suitable enterprise-wide information environment capable of meeting our future platform for information collation from various source systems, performing complex calculations. This Final year engineering project provides different reports and support & adhoc queries for making intelligent banking decision based on data available in various branches across the location connected over a period.

Developer Responsibilities:

  • Involved in Database Programming
  • Analyzed, designed and developed packages, procedures and functions using PL/SQL.
  • Optimization of the different SQL queries to ensure faster response time.
  • Create Tables, Indexes, and Views etc.
  • Modifying & Creating PL/SQL Procedures, Functions, Packages, Triggers,  And SQL Queries for Reports.

Project Environment:      

         PL/SQL, Oracle 10g, Windows 2000, Windows NT, Windows XP, Unix, Informatica

Posted on

Result Processing system VB.Net project

Result Processing system VB.Net project is a Database support and enhancement project, which involves receiving data from different source systems (like SQL db, excel sheet, Access Db). Then here we are taking the data and processing the Results with the help of different tables.

 Ex: Student information table, Subject master table Course(UG,PG,MCA,MBA etc.) wise marks table, Year(I,II and III year) wise result tables. After that mismatch, the data with other data base team. 

                After this process the databases uploading into the online, then involve in the testing for the monitoring accuracy. The reports are taking from this data, like subject wise, course wise student count for pass or fail.

 

Posted on

CRM Airlines Project

Project Title: CRM Airlines Project

Project Description: The main aim and objective of this CRM AIRLINES project are to apply the Customer relationship management concepts to domestic & international Airline companies and to satisfy the customer and take feedback through online web services system.

The below technical & software specifications used to develop this CRM Airlines system project:

  • Used HTML, DHTML, and Java Script to develop the web contents as FRONT-END Technology like create a login page, new user registration form, feed back page, etc.
  • Implemented Oracle database system as BACK-END Technology to create database tables and store all user database details.

CRM Airlines Project documentation, seminar topics & reference documents

Posted on

Asynchronous Messaging Service

The main aim is Asynchronous Messaging Service provides the policy facility with in short period of time for the employers in an organization or in small scale industry. This Java based application can be initializes to automatic debit premium amount and claim policy amount automatic credit in our bank account. This final year oracle project can be used to reduce the resources, saves money and time.

Software Technologies Used: Front End: JAVA; Back End: ORACLE.

This project has done at CMC limited Hyderabad.

Posted on

Attendance Monitoring System

Project title: Attendance Monitoring System                 

Developer Role: Designing the user interface and development. Can be involved in this implementation

Project Description: Project Design, development and implementation of attendance monitoring system.

Attendance Monitoring System enables the certifying officers to certify the attendance of their subordinates accumulates the leaves after specified days of physical attendance, certification of leaves and generates reports for payroll processing. 

The main aim of this project to maintain attendance records, this project has done at Bharath Dynamic Limited, Hyderabad.

Hardware Requirements: H/W: Pentium-IV, RAM: 1GB, HD: 160GB.

Software Environments: O/S: Windows XP   S/W: oracle 9i and developer2000.

Posted on

Library Management System

Project Title:   Library Management System

Environment:   Windows Vista, Oracle 10g, Java

Developer Role:   Analyst, Programmer& Tester,

Project Description:  This Library Management System software give information about the available books & authors of the library efficiently handles the issue and Return of the books; conclude the fine over books, different Access privileges etc. 

This Library Management System software application was developed in Windows Vista environment using Java & Oracle Software requirements.

Posted on

Customer Contact Management

Project Title: Customer Contact Management

Front End tools: Java, J2EE, HTML, Java Script

Back End Server: Oracle 10g

Project Description: Customer Contact Management is final year computer science student six-semester project that can have the total customer contact details includes customer name, customer father name, customer date of birth, customer mobile number, customer, unique ID number, customer address, etc. 

This java application main aim to find & track his information in multi level shopping mall or small scale industry.

In this Customer Contact Management Java Final Year Project all customer contact details can be stored in the database by using Oracle 10g.

Posted on

Online Booking For Railways And Enquiry On Reserved Tickets

This Online Booking For Railways And Enquiry On Reserved Tickets project is aimed at developing online web portal which helps online railway reservation system.

The constraints of the project can be available with two modules the user module and the admin module. This java project uses Jdbc connectivity, Servlets, and Java server pages for the front end and Oracle database server for the back end.

Railway Reservation online web portal which allows users to book the railway tickets through online/internet. 

This feature shows booking status contains which berth number is allotted to which passenger and it can provide the waiting List. Users can check the berth status by using PNR number.

This Java Final Year project implements the idea of maintains the oracle Data Base Reports where the user can interact with the database server.

This project does most of the Designing work of checking for the details. We hope that this package would prove to be an excellent tool for Railway Reservation Management.

We whole-heartedly welcome any suggestion on the improvement of this Online Booking For Railways And Enquiry On Reserved Tickets project.