Tax and Deduction System Project

This report serves two main objectives. One is for the organization and other is for the student. The first objective of this report is to provide for better understanding and easy maintenance of the system for the organization on the departure of the student after the project work. Secondly, this report will suffice the requirements of the BCA course for the students. It will provide the ground for the evaluators to appraise the student’s efforts over the period of a year.

Entity relationship diagram for production department

This project report consists of different sections like system specification, system study, system design, detail design and front-end design etc. that will hence prove to be a sincere helper the user trying to gain knowledge on the above-mentioned system.

Introduction to system

Tax and deduction system 

This system is developed to compensate the needs of company currently running.

It will calculate the yearly depreciation and at last will produce final bill which includes all the transactions that are carried out around the year. Daily updating of transaction books of account, long mathematical calculation, yearly depreciation, company tax, government tax etc are covered under this system.

A special help is provided regarding the use of software.Technical terms used in this system are also explained in brief.

Existing system 

The existing system continues on manual entry of daily transactions in the book of account. The daily totaling of overall payments done and payments remaining are done at the end of day daily. Monthly calculation and preparing bill using soft wares like Ms Excel is done.

Problems with existing system

  • For daily updating of books a person has to remain present in company everyday. A single day absence causes a large work to be completed next day.
  • Since updating like deletion and insertion causes wastage of time and doing the entry again and again until data are correctly updated.
  • The calculations are done manually which may result in the wrong figuring of amount at the end. Due to this during monthly updating and totaling the transactions of from 1st to 30 th have to be checked for errors.
  • The next point is regarding the software used. The usage of Ms Excel is not that much reliable as that of today’s oracle, visual basic, java etc.
  • The current software provides no high security and data storage.
  • A layman cannot work with the current system. For this a special knowledge regarding  software is required.
  • The software currently used does not have certain in build functions, which supports the automatic updating and calculations.

Causes of disagreement

  • Omission of posting in one account
  • Double posting in one account
  • Posting on wrong side of an account
  • Wrong totaling of subsidiary book
  • Omitting to post the total of subsidiary book
  • Wrong totaling or balancing of an account
  • Wrong totaling of trial balance which is the final book of account

Proposed system

  • The problem with current system is taken in to consideration and a new system “Tax and Deduction” is build to fulfill all sort of requirements that a company has to face regarding the maintenance of book of account.
  • Since the new soft wares are quiet highly rated in comparison with the currently used Ms Excel the system is developed using Visual Basic as front-end tool and Oracle as the back-end tool.
  • The system has got a login name and password, which gives an unauthorized access to any person. This is one of the important point that is considered.
  • The form entries are easy to enter as the name suggests the entries has to be made and a user friendly buttons are created which allows the user to access entered data and clear, insert and delete  new data to be entered.
  • All mathematical calculation regarding company tax, government tax and the profit at each month and around the year is calculated which shows the accuracy.
  • Creating tables in oracle for different external entities do data storage. Using Visual Basic forms are designed for better usage of system and preparation of final bill for each company.
  • At last a special help is provided regarding the technical terms used in system. A feedback form is provide for user problem and can have direct contact with H.O.D of company. 

Objective 

To overcome the daily updating of the books of account. We have decided to computerize this project using high-level language. 

THE NEW TAX AND DEDUCTION CALCULATING PROJECT WILL: 

  • able to make task easy for accountant
  • easy dealing with the companies and their account
  • maintenance cost will be economical
  • storing of data ,high level security and accurate results

These new system developed will provide a good data storage and access of data will be easily possible under high security and high consistency.

Benefits of system

  • Verification :

Verifies that all opening balances have been correctly entered in various tables Compares the current year’s depreciation with previous year. Any variation can be successfully checked

  • Faster and Accurate processing :

Implementation of the application system with good communication mechanism will facilitate accurate and timely production of result and reports.

  • Reduce Manual O-operations :

The integrated computerized application system will reduce manual operation like marinating registers and paper works in office.

  • Ensures Data Security :

The system will provide security of the result data.

  • Ensures Data Integrity :

The system will also ensure integrity of the data.

  • Save time :

This system will facilitate faster retrieval of data or information, which saves time.

  • Supports quick review of History Data :

It supports the quick retrieval of the existing data or other information.

Project profile

Project Title                  :   Tax and Deduction System

Front End                      :   Visual Basic

Back End                       :  Oracle

Inteligent Bussines Process Manager

About the project:

BPO (Business Process Outsourcing) is an outsource partner take responsibility for providing back office support for a client organization. The main benefits of BPO for any organization are:

  1. Reducing Costs
  2. Improving Service
  3. Transferring Risk

Processing Services: BPO’s system design based on our wide knowledge of hardware and software, supported by an efficient domain and Process oriented staff ensures document processing capability with:

  1. Efficient data capture
  2. High accuracy levels
  3. On schedule delivery

This project entitled “Intelligent Business Process Manager” is a client server based administrative software utility to manager and automates various processes taking place in a business processing and outsourcing company mainly focused on data conversion.  It consists of three software components, Server Manager, Client Assistant, QC Assistant. Each component can operate independently and can communicate with each other using TCP/IP Protocol. The three components of the IBPM operate accordingly to coordinate the various process-taking places in a BPO firm.

Inteligent Bussines Process Manager

Server Manager 

The Server Manger is the core components of the IBPM.

The Server Manager starts listening the remote client’s request to establish a connection.

After checking the security privileges of the user, the server Manager establishes a dedicated connection to the requested client using TCP/IP Protocol and creates a separate system thread to manage the newly established connection.

The administrator can deploy works and reworks to the remote users through this Server Manager.

The Server Manager also allows the administrator to create backup of the deployed work in the server at various stages of its progress.

If a failure occurs I any one of the remote user’s computer the Server Manager can re-deploy the work from the server’s backup to that particular user.

Data Flow Diagram of Server Manager

Client Assistant 

Client Assistant is a software component for those users who are actually in the data conversion process.

A separate copy of the Client assistant software is required on each user’s system.

Users are logged in to the Server Manager through the Client Assistant.

The Client Assistant use TCP/IP protocol to establish a connection to the Server Manager component running in the remote server.

When a user is successfully logged into the Server Manager the administrator can schedule and deploy the wok to that specific user.

When a user completes his work, he can upload it the server through the Client Assistant.

Data Flow Diagram of Client Manager

Quality Controller 

QC Assistant is a software component for Quality Controllers, who verifies the quality of the finished work submitted by the users to the Server Manager.

A separate copy of the QC Assistant is required for each Quality Controller System.

QC-Users are logged into the Server Manager through the QC Assistant.

The QC Assistant use TCP/IP protocol to establish a connection to the Server Manager Component running in the remote server.

When a QC-User is successfully logged in to the Server Manager, the administrator can schedule and deploy the finished work from different users to the Quality Controller for quality checking. 

SYSTEM ANALYSIS AND DESIGN 

Analysis of the system 

The system is for simplifying the communication difficulties between different of an organization.

What does our organization want to share between its branches?

Declaring any information regarding business to its branch managers.

Sharing details about their products and discussing about services.

Declaring any instructions to its staff working at different branches.

Interfacing Human resources and administration.

These functions are divided into three categories they are:

  1. Server Manager
  2. Client Assistant
  3. Quality Controller

Server Manager

The server Manager starts listening the remote the client’s request to establish a connection. After checking the security privileges of the user, the Server Manager establishes a dedicated connection to the requested client using TCP/IP Protocol and creates a separate system thread to manage the newly established connection.

Client Assistant

Client Assistant is a software component for those users who are actually in the data conversion process.  A separate copy of the Client Assistant software is required on each user’s system. Users are logged into the Server Manager through the Client Assistant.  The Client Assistant use TCP/IP protocol to establish a connection to the server manager component running in the remote server.

Quality Controller

Who verifies the quality of the finished work submitted by the users to the server manager? A separate copy of the QC Assistant is required for each Quality Controller’s system. QC-Users are logged into the Server Manager through the QC Assistant.  The QC Assistant use TCP/IP protocol to establish a connection to the Server Manager Component running in the remote server. 

DATABASE DESIGN 

Database is a collection of information related to a particular subject or purpose. This design provides the detailed structure of the table layout.

Database design consists of the following tables: 

1. Table Name             :           Login

Primary Key                :           userid

Field Name Type Description
User Name Varchar (20) Login User Name
Password Varchar (10) Login Password

2. Table Name             :           Registration

Primary Key                :           E-Mail id

Field Name Type Description
Name Varchar (15) User Name
Gender Char (7) Gender
Id Varchar (10) E-Mail Id
Pass Varchar (7) Password
RePass Varchar (7) Retype Password
Dob Varchar (10) Date Of Birth
State Char (7) State
City Char (8) City
PhNo Varchar (10) Phone No
Occu Char (12) Occupation

3. Table Name             :           Compliant

Primary Key                :           Compliant id

Field Name Type Description
Compl_ID Varchar (10) Complaint ID
Cust_ID Varchar (10) Id of customer
Cust_ Name Char (20) Name of customer
Compl_Date Date (7) Complaint Date
Compl_ Time Time (7) Complaint Time
Compl_ Type Char (15) Type Of Complaint
Desc_Compl Char (10) Description of complaint

4. Table Name             :           Compliant Transfer

Primary Key                :           Compliant Transfer id

Field Name Type Description
Compl_ Transfer ID Varchar (10) Transfer id of Complaint
Compl_ ID Varchar (15) Id of Complaint
Compl_ Date Date (10) Complaint Date
Compl_ Time Time (10) Complaint Time
CA_ ID Varchar (15) Client Assistant ID
Status Flag Boolean (15) Transfers Status

5. Table Name             :           Pending Complaint

Primary Key                :           Compliant id

Field Name Type Description
Complaint ID Varchar (15) Complaint ID
Client Name Char (20) Name of Client
Client ID Varchar (15) ID of Client
Complaint Date Date (10) Complaint Date
Complaint Time Time (10) Complaint Time
Solution Char (15) Solution

6. Table Name             :           Client Assistant

Primary Key                :           Client Assistant id

Field Name Type Description
CA_ID Varchar (15) ID of Client Assistant
CA_Name Char (20) Name of Client Assistant
CA_Address Varchar (25) Address of Client Assistant
CA_System ID Varchar (10) System ID of Client
CA_Specialization Char (15) Specialization of Client Assistant

7. Table Name             :           Quality Controller

Primary Key                :           Quality Controller id

Field Name Type Description
QC_ID Varchar (15) ID of Quality Controller
QC_Name Char (20) Name of Quality Controller
QC_Address Varchar (20) Address of Quality Controller
QC_Phone No Number Phone No of Quality Controller
E-Mail Varchar E-Mail Id of Quality Controller

8. Table Name             :           Solution

Primary Key                :           Solution id

Filed Name Type Description
Solution ID Varchar (15) ID of Solution
Solution Char (15) Solution
Complaint Transfer ID Varchar (9) Complaint Transfer ID
Solution Date Date (10) Solution Date
Solution Time Time (10) Solution Time

9. Table Name             :           Feedback

Primary Key                :           Client id

Field Name Type Description
Client Id Varchar (10) ID of Client
Client Name Char (20) Name of Client
Client Phone No Number (15) Phone No of Client
Client Address Varchar (20) Address of Client
Client E-Mail Varchar (20) E-Mail id of Client
Feedback Varchar (15) Description of feedback

CONCLUSION: 

The project ‘Network Packet Sniffer’ is meant for providing security to a system by forwarding the validated packet details to the firewall. The system is developed in VC++ as front-end tool and Oracle 8i as backend tool.

The Remote Monitoring System project can be thus found to be useful in various applications in both home use as well as office use to detect unnoticed malpractices in our system. Thus it makes the user to be careful about the improper usage of his system thus enabling him to take appropriate actions to stop them. Hence he can have a control over his system even in his absence. Hence it provides a level of security to the administrator’s PC. Remote Monitoring System is a powerful monitoring and surveillance tool that is useful on all platforms. This project helps us in a networking environment to monitor and spy all the system in the network connection without knowing the user.

Material Management and Stores accounting system

MATERIAL MANAGEMENT

ABSTRACT:

To develop software for Material Management and Stores accounting system to resolve the problems faced by the material managers in the organisation as a solution.

Objectives:

1. To develop the software for transparent procurement of materials/ items and accounting of all the inward goods transactions/items.

2. To improve the material management inventory system by providing quality of service to the stores department to production departments at various levels.

Scope:

It is required to develop a computer-oriented method for MM Department to Stores department activities, right from the purchase request to goods inspection. The decisions, which are taken by the material managers, demands more quality information from the indenter with respective to quantity and time of the items required to meet the organisational production goals.

Solution:

To meet the organisation goal in procurement of items a strong supporting system, by means of stock levels and cost effective. Thus a more flexible, simple user friendly software which can assist all the authorised persons at various levels in making decisions regarding stock of various materials, effective channelling of resources, maintaining important validation data and reduction in the reaction time. Computerization saves a lot of time regarding the maintenance and retrieval of data at crucial time, making the work easier and efficient.

This system covers all the activities of MM right from the raising of Purchase Request (PR) to receipt of materials (inward goods) from the supplier and also issue of materials for production to store credit of finished goods.

System Specifications:

Software Requirements:

• Operating system           :   Windows XP or Windows 7, Windows 8.

• Coding Language            :   Java – AWT, Swings

• Data Base              :   My SQL/ Oracle.

• Documentation               :   MS Office

• Development Kit             :   JDK 1.7

Hardware Requirements:

System                      :   Intel core Pentium IV

Hard Disk                  :   40 GB.

Floppy Drive                        :   1.44 Mb.

Monitor                    :   14’ Colour Monitor.

Mouse                       :   Optical Mouse.

Ram                            :   1 GB. 

System Flow:

 Material Management and Stores accounting system

Java Mini & Major Projects

Java Mini Projects developed especially for BCA, BTech and MCA students for their academic mini and Major project development under Java, MS Access, Oracle, SQL Server & MySQL. These are below are selected projects.

Java Web Applications Project List – 2025

Sr.No Project Title
1 Booking Photographer
2 City Life
3 E-Magazine
4 E-Tuitions
5 Magazine College
6 Event File Automation
7 Learning Portal
8 Nirman  website
9 Ship Management System
10 Placement Cell
11 Cancer Project
12 E-Procurement
13  Project Management System
14 knowledge-based community sharing system
15 Offer-Bazar
16 Online-E-Gas
17 Income-Tax-Return-Processing
18 Online Staff Leave Management
19 Employee-Expense-Management-system
20 Exam Seating Arrangement System
21 Color Hunt Gaming project
22 Online Form Request
23 Electronic-Veg-Market
24 Puyo Puyo (game project)
25 Magic Bounce Ball  (game project)
26 Satvara Matrimony
27 Query Handler
28 Grade Processing System
29 AES–Photo Encryption
30 Image Enhancement
31 Paradarshia Corruption Free Economy
32 Implementation Of Floyd’s Algorithm
33 Atm Location Search
34 E-Farming
35 Time Table Management System
36 Admin Mall
37 Bulls-Eye-Quiz
38 Smarter Work Management System
39 Online Grievance Redressal System
40 Real Estate Magicbricks
41 Apartment Management System
42 Medical shop Management System
43 Security Mail Communicator
44 Feedback Analysis Of interviews
45 Intelligent Hospital System
46 Tender Management System TMS
47 Virtual Learning Environment (VLE)
48 Online Loan Application
49 Retail Purchase & Tracking System
50 Opinion Mining For Social Networking Sites
51 Project Information System
52 Student Friendly College Management System
53 Online Book Store
54 Sentimental Analysis For Mobile Networks
55 Report Generation System
56 Feedback Information System
57 Health Prediction Management System
58 Online Book Review Management System
59 Suspicious Email Detection System
60 Student Monitoring System
61 Online College magazine
62 Sports Event Management System
 63 Restaurant Management System
64 Online House Rental Management
65 Online Food Ordering & Service
66 Online Course Management System
67  Online Cab Booking System
68  Online College Voting System
69  Cluster Analysis and Disease Mapping
70  College Feedback System
71 Result Analysis System
72 E Plastic System
73 E-Banking System
74 Assignments and Materials System
75 Vehicle Management System
76 Recipe Management System
77 Online Event Attendance
78 Online Parking System
79 E-Auction
80 Telecom Services
81 Airline Reservation System
82 E-Waste Application
83 Exam Invigilation System
84 Library Management System
85 Patient Follow Up
86 Event Management System
87 Career Information System
88 E-Gas Sewa Application
89  Student Attendance Management System
90  Office Level Student Information System
91  Online Pharmacy System
92  Online Recruitment System
93  Credit Card Fraud Detection
94  Smart General Library
95  Venue Booking System
96  A Secure Two-Factor Authentication Scheme
97  Selection of Effective Clouds for Data Hosting Services
98 Career Analysis System
99 Student Performance with graph & Academic Project work Reporting System
100 Wedding Event Planner
101 Travel Rating and Exploring System
102 Performance Evaluation System Adoption of Opinion Mining Information
103 Online Marketplace
104 Uni Watch – Web
105 Training & Placement Cell
106 File Security System
107 Social Networking Site
108 Campus Recruitment System (Training & Placement)
109 Farmers Buddy
110 Event Organization System
111 Online Doctor Appointment
112 Online Survey System
113 Secure Web Application for Managing Auction System
114 Identification of Diabetes
115 College Placements & Assistance
116 Online College Bus Record Supervising System
117 Online E-Ticket System
118 Online E-Voting System
119 Student & Faculty Interaction Outside the Classroom
120 Automated Retail Management System
121 Dynamic Media Management
122 Electronic Highway for Singers
123 College Election System
124 E Police Application
125 Student Performance Forecasting
126 College Bus Tracking System
127 Performance Monitoring in Virtual Organizations
128 Review-Based Rating Prediction
129 Automation of Exam Invigilation System
130 Fast Detection of Transformed Data Leaks
131  Employee Tracking System
132 College Sentimental Analysis
133 Personality Prediction System Through CV Analysis
134 Analysis of Users Behaviour in Structured E-Commerce Websites
135 Image Encryption and Decryption using BlowFish
136 Resource Maintenance and Management
137 Watermarking
138 Monitoring Fake Product Reviews
139 College Bus Facility System
140 Software Piracy Prevention
141 Tour Guide
142 Local Vendor Review System
143 Multi-Level Marketing
144 Secure File Sharing
145 Water Distribution and Management System
146 Citizen Card System
147 Collaborative Online Tutorial System
148 Online Entertainment Portal
149 Secure Web Portal for Real Estate & Property Management
150 Agile Management System
151 Book Repository Management System
152 Frame It
153 Voice to Text Converter Java Project
154 Purchasing Management System
155 Telangana Public Services
156 Analysis of Persuasive Text Passwords
157 Project Review Automation
158 Easy Search Guide (Malls)
159 Food Wastage Management System
160 Food Ordering System
161 Stack Management
162 Courier Service System
163 Campus Recruitment System
164 Vehicle Rental Management System
165 Automation of Timetable Generation System
166 Online Gas Management System
167 Obsessive Compulsive Disorder
168 Online Leave Management System
169 Image Steganography using LSB
170 File Tracking System
171 Electronic Voting System
172 Dynamic Analysis vulnerability to Provide Security In Clouds
173 Health Care Logistics
174 Car Store
175 E-Fuel – Online Fuel Booking
176 Hour Wise Lecturers Tracking
177 Multi-Hospital System – Online Doctor Appointment
178 E – Voters Application
179 Repository Application
180 Student Information Chatbot System
181 Student Help Desk
182 Online Student Mentoring System
183 Placement Information System
184 Hostel Management System
185 News Report
186 Dance Studio
187 Passenger Vehicle Management System
188 Automatic Question paper Framer
189 Development of Learning Management System
190 Online Bouquet Store
191 E Approval System
192 Online University Voting System
193 Automatic Exam Seating Arrangement System
194 Advanced Query Management System
195 Urban Spoon
196 Development of Online College Yearbook
197 Predicting user behavior through sessions using the web Mining
198 Digital WaterMarking Techniques
199 Age Group Classification in Social Networks using Deep Learning
200 Securing data in Image & Audio Files using Steganography Technique
201 Computerized Examination Management System
202 Scalable Architecture for Multi-User Encrypted SQL Operations
203 Mental Disorder Detection on Social Networks
204 Resource-aware hybrid scheduling algorithm in the heterogeneous distributed computing
205 Secure File Storage on Cloud using Hybrid Cryptography ( AES, DES, RSA)
206 Data Mining for Sales Prediction in Tourism Industry
207 A Secure Approach For Data Hiding Using Visual Cryptography (Image Split, Encryption and Decryption)
208 Classification and Detection of Abusive and Insulting Content in Social Media
209 Data Security In Cloud Computing Using Two Way Handshake Method Based On Token Management
210 Web Application For Conducting University Examination
211 Student Performance Prediction via Online Learning Behaviour Analytics
212 Faculty Management System
213 Online Medicine Donation System Portal
214 Indian Wildlife Java Project
215 Employee Attendance Monitoring System
216 House tax Billing System
217 Online Meeting With Clients
218 Online Voting System
219 Construction Management System
   
 JAVA Projects (Non-IEEE, Web Based, Window Based) – 2018
   
S.No Project Name
1 Ad Express Management System
2 Finance Management System
3 Credit Card Approval System
4 Computer Telephony Integration System
5 Computer to Computer Learning System
6 Conversation Portal
7  Logic Gates Java Project
8 Crime File Management
9 Hotel Management System
10 Automotive price Aggregator
11 Blood Donors Symbiosis
12 College Fest Organizer
13 College Management Information System
14 Communication System
15 Computerization of Bluebook/ Online Quiz
16 Computerized Mobile Store Management System
17 Digital Signature
18 Hotel Management System
19 Multi Banking System
20 Digital Tunes
21 Optimal service pricing for a cloud cache
22 Library Management System
23 Crime Records Management System
24 Insurance Management System
25 Friends Meeting Point
26 Student Management System
27 Travel & Tourism Management System
28 E-Compiler for Java with Security Editor
29 Stock Analyzer
30 E-Shopping
31 E-Voting System
32 Enterprise Scheme Planner and Monitoring System
33 E School
34 E Wheelz
35 Congestion Control Using Network Based Protocol
36  Car Pooling System Java Project
37 Country Cargo and Express Couriers
38 E-Classifieds
39 Distributed Account Management for Prepaid Mobile Services
40 Car Collection for Sale
41 Bug and Component System
42 Bug Tracker System
43 Coach Management System
44 Auto Spare parts Java Project
45 College Library Record Application
46 Consignment Tracking Services
47 Activity Management System
48 Audio Stenography
49 CRM for Airline Industry
50 Error Tracking System
51 Exam Suite System
52 File Security System
53 Fetch Hard – Component Retrieval System of a PC
54 Bug Tracking for Improving Software Reliability
55 Cyber Cafe Management
56  RSS Feed Reader
57 Ezee Mail System
58 Gateway to Gateway Protocol
59 Database Manager
60 Human Resource Management System
61 Image Enhancement Technology
62 Image Steganography
63 Increasing Efficiency in Wireless Network
64 Image Transport Protocol ITP
65 Instant Messenger
66 Interest Calculation
67 Intra Communication System
68 Inventory Analyzer
69 Inventory Management System
70 Issue Tracking System
71 JChat
72 Job Miller
73 Defect Tracking System
74 Audio Cryptography System
75 Product Service Management System
76 Auto Mobile Store and Service
77 Ambulance Service Provide
78 Automatic Database Schema Generation
79 An Intelligent Network Backup
80 Digital Image Processing System
81 Knowledge Storm
82 Emergent Request Dispatcher
83 E-Zest Resorts for U
84 Monitoring Online Tests through Data Visualization
85 Data Transmission Using Multi-Tasking-Sockets
86 Doctor Patient Tracker
87 Data Hiding in Audio Files
88 Mobile Service Provider Operations Portal
89  Online Doctor
90 Multi User Chat System
91 Network Routing System
92 Online Examination
93 Automation of Interview Scheduling Process
94 Library Management System (Standalone application)
95 Mobile Station Java Project
96 Lending Tree System
97 Library Management
98 VAT Information System
99 Material Management and Information System
100 Government in Action
101 Online Payment Service
102 Order Processing System for Student Music Store
103 Pesticides Information System
104 Property Management System
105 Resource Out-Sourcing
106 Resource Planner
107 Resource Supervision Management
108 SDLC Management System
109 Secured Data Transmission
110 Shopping Cart
111 Online Shopping Cart
112 Simulation of Ant colony Algorithm
113 Speed Age Courier System
114 Traffic Controller System
115 Vehicle Management System
116 Virtual Information System for Audit Group
117 E School
118 Work to Worker Services to Unorganized Sector
119 Broad walk Dealers Network
120 College Administrator Tool/ College Enrollment System
121 College Interact
122 College Management Tool
123 Comparable Entity Mining from Comparative Questions
124 Complaint Management System
125 Computer Retail Store and Maintenance
126 Computerized Examination Management Tool
127 Concurrent Train Simulation
128 Congestion Control Using Network Based Protocol
129 Corporate BPO Solution Management
130 Corporate Leave Management System
131 Corporate Recruitment System (CRS)
132 Cyber Shopping
133 Data Centric Knowledge Management System (DCKMS)
134 Event Tracker
135 DHL Courier System
136 Distributed DBA
137 Distribution Business Automation System
138 EAMCET Mock Counseling
139 Face Identification
140 EzHotels
141 Graphic Media Player
142 Employee Transaction Scenario
143 Hospital Management System
144 Hostel Management Information System
145 FAQ-O-Matic System
146 Get Your Campus
147 Internet Banking
148 Multi-Sensor Railway Track Geometry Surveying System
149 Online Examination
150 Webs Eye
151 Stenography Using Image, Audio & Video
152 Visa Processing Information System
153 University Admission System
154 Telecom Connection System
155 Medi Tracker
156 Travel Management System
157 Online Railway Reservation System
158 Airline Reservation
159 Travel Desk Management System
160 Alumni Information Database
161  Remote Desktop Administration
162 Health Center Management system
163 Payroll System
164 Self-Diagnosis with Advanced Hospital Management
165 108 – Public Health Emergency Services
166 Water Marking
167 Intranet Chatting
168 Online Banking
169 Net Banking
170 Gateway Of Business Portfolio
171 Distributors Channel Management System
172 Online Doctor
173 Online Mobile Recharge
174 Patient Management System
175 Online Order Processing System (AJAX Enabled)
176 Virus Information System
177 Peer to Peer File Sharing Program
178 An Agent Based Intrusion Detection, Response and Blocking using signature method in Active Net
179 Telecom Business Information System
180 Online Telephone Management System
181 Online Tourism Guide
182 Online Taxicab Service
183 Online Registration For Voter Card
184 Safe Internet
185 Mobility Management Approaches for Mobile IP Networks
186 Local Service Center
187 Reseller Management System
188 Re-Ordering Of Packets Using Retransmission Timer
189 Online Crime Investigation
190 Revenue Collection and Recovery Services
191 E-education
192 Exam Branch Management System
193 Home Improvement System
194 Value Added Sales Tax Information System
195 E dues (E Billing System)
196 Content Management System
197 Train Information System
198 Enterprise Resource Information System
199 Global Interactive Solutions
200 Global Communication Media
202 Hotel Management System
   
204 Retail-Management-System
205 Painting Application
206 Social Health Care Record
207 Reversible Watermarking
208 Audio Cryptography System
209 Monitoring Online Tests through Data Visualization
210 Alumni Management System
211 Product Service Management System
212 ATM Location System
213 Work in Progress Application
214 Chores Made Easy
215 E-Procurement
216 Emotion Detection
217 Institutional Infrastructural Information System
218 Placement Cell
219 Project Management System
220 Query Handling
221 Timetable Generation System
222 Online Staff Leave Management
223 PLACE Personal Learning Assistance Center

Office Correspondence and Auto Questionnaire Java Project

INTRODUCTION

GENERAL: Office correspondence and auto questionnaire java based project are developed as per the requirements of the mechanical department.

OFFICE CORRESPONDENCE

Mechanical department deals with the different type of letters. The letters which are received by the mechanical department are incoming letters and the letters which are sending through the department are the outgoing letters.

The different types of letters received and sent by the mechanical department are as follows:

  • Local letters
  • Headquarters letters
  • Others


office correspondence

LOCAL LETTERS

The letters received from and send to other departments of Vijayawada division are termed as local letters.

INCOMING LOCAL LETTERS

The letters received from other departments of Vijayawada division are termed as incoming local letters.

OUTGOING LOCAL LETTERS

The letters sent to other departments of Vijayawada division are termed as outgoing local letters.

HEADQUARTER LETTERS

Secundrabad division is headquarters of the Vijayawada division. So the letters received from and send to Secunderabad division are termed as headquarters letters.

INCOMING HEAD QUARTER LETTERS

The letters received from Secunderabad division are termed as incoming head quarter Letter.

OUTGOING HEAD QUARTER LETTERS

The letters sent to Secunderabad division are termed as outgoing headquarters Letters.

OTHERS

The letters received from and send to the divisions other than Vijayawada and Secunderabad are termed as other letters.

INCOMING OTHER LETTERS

The letters received from the divisions other than Vijayawada and Secunderabad are termed as incoming other letters.

OUTGOING OTHER LETTERS

The letters sent to the divisions other than Vijayawada and Secunderabad are termed as outgoing other letters.

If the reply for the above letters is to be given immediately then those letters are marked as demi official letters.

So different types of demi official letters can be

  • Incoming Local demi official letter
  • Outgoing Local demi official letter
  • Incoming Head quarters demi official letters
  • Outgoing Head quarters demi official letters
  • Incoming Other demi official letters
  • Outgoing Other demi official letters

All the incoming letters are received by the chief office superintendent and are marked to different sections of the mechanical department with the authorized signature of the senior divisional mechanical engineer. Then the respective task is performed by section accordingly to the letter which is received by it and sends the reply to the chief office superintendent. Then the chief office superintendent with authorized signature of the senior divisional mechanical engineer sends the letter as an outgoing letter.

The mechanical department consists of seven sections.

  • Contract/tenders
  • Carriage & wagon staff
  • General/pass
  • Rolling stock
  • Stores
  • Budget
  • Power

AUTO QUESTIONNAIRE

The test to avail the promotion is conducted for the employees of the Vijayawada division. The question bank offered to the employees for preparation comprises of the following type of questions.

  • Long answers
  • Short answers
  • Fill in the blanks
  • Multiple choices
  • Expansions

auto questionnaire

STATEMENT OF THE PROBLEM 

OFFICE CORRESPONDENCE

To maintain the details of different types of letters, to show the status of the letter and also to generate the reports. 

AUTO QUESTIONNAIRE

To maintain the questions and to generate the questions randomly when appropriate type of question is selected.

EXISTING SYSTEM

OFFICE CORRESPONDENCE

In the existing system, the details of the letter are being maintained manually by entering different types of letters in different books. To know the present status of the letter, it is very difficult in the existing system because one has to verify all the entries in that particular book. So it is time-consuming. 

AUTO QUESTIONNAIRE

In the existing system, question paper is set manually by selecting the type of questions from the printed question bank. It is very difficult and time-consuming to set question paper manually because when selecting a question one has to verify whether it was previously given or not.  One has totally the maximum marks for which paper was given and marks allotted for each question and he should also consider the choices for each type of question.

PROPOSED SYSTEM 

OFFICE CORRESPONDENCE

The proposed System is a web-based application. It maintains details of all the letters within the mechanical department. The present system shows the pending letters and reports. 

AUTO QUESTIONNAIRE

In the proposed system the question paper is set automatically by selecting random questions when an appropriate number of question type is selected.

OBJECTIVES OF STUDY 

OFFICE CORRESPONDENCE

  • Automating the manual work.
  • To generate the status of the letter
  • reminder  provision for pending letters

AUTO QUESTIONNAIRE

  • To generate the question paper quickly from the available database.         

REQUIREMENT ANALYSIS   

FUNCTIONAL REQUIREMENTS

OFFICE CORRESPONDENCE

  • The user can add the details of all the letters into the database and view the pending letters.
  • The authorized user can edit the details of the letters and delete the letters from the database.

AUTO QUESTIONNAIRE

  • The authorized person can add, delete and update the questions in the database.

SYSTEM DESIGN SPECIFICATION 

SOFTWARE REQUIREMENTS

Operating system: Windows XP professional

Programming Language: JAVA

Web Technology J2EE (JDBC, Servlets, JSP, HTML)

Browser: Internet Explorer

Web application serverApache Tomcat

Model Design: Rational rose

IDE: Net Beans 6.7.1

Data Base: Oracle 10g, MS Access. 

HARDWARE REQUIREMENTS

Processor: Intel p4

RAM: 256MB RAM

Hard disk: 20GB or more

Required Software’s:

  • Oracle 9i
  • Java
  • Netbeans 6.7.1
  • Mozilla Firefox

Instructions to Deploy:

1. Install the required software’s
2. Open Netbeans and open the project from source code
3. Configure database connections from DBConn package of Source Packages under the root PPO & Technical
4. Right click on CreateTab.java under Test Packages under the root PPO & Technical and click on run
5. Right click on root and click on run

Note: In case of reference problems right click on root and click on resolve reference problems, and select the library files.

Output Screens:

  • Homepage in office correspondence
  • Selection of letter type in office correspondence
  • Reports generation using a serial number in office correspondence
  • Report generation using by date in office correspondence
  • Report generation using between dates in office correspondence
  • Report generation using marked in office correspondence
  • Report generation using received from in office correspondence
  • Report generation using send to in office correspondence
  • Report generation using general in office correspondence
  • Report generation using remainders in office correspondence
  • Pending letters in office correspondence
  • Editing of the letter in office correspondence
  • Login page for deleting the letter in office correspondence
  • Letter deleted successfully in office correspondence
  • Login page in the auto questionnaire
  • Operations on question bank in the auto questionnaire
  • View of multiple choice questions in the database
  • Default question paper in the auto questionnaire
  • Question generator in the auto questionnaire
  • window to open or cancel generated question paper in the auto questionnaire
  • Generated question paper opened in MS word in the auto questionnaire

CONCLUSION 

The primary goal of this project is to reduce the work which is being done manually. By maintaining the details of all the letters in the database we view the letters based on different fields such as serial number, marked to, date and so on. The letters which are pending can be viewed easily and the remainder is generated. Editing and deleting the details of letters is also possible.

The question paper is being generated by selecting the questions randomly from the database. We need to mention the maximum marks and the type of question. Creation of our own template is also possible. This system is very user-friendly.

SCOPE 

The application i.e., office correspondence which we developed is a standalone one i.e., within the department we can use. The letters are received in paper format and then they are saving them in the database. Due to this time gets wasted. If we develop a web-based application the letters received by the department are sent through emails then a lot of time gets saved.

Download Office Correspondence and Auto Questionnaire Java Project Code

Planning & Technical Management System in Java

The manual procedure for interaction between the PPO users and the other users in ELS (Electric Loco Shed) is prone to certain limitations.  The existing system has been facing certain limitations like communication gap between various departments of ELS and maintaining the details manually which is a time-consuming process. So, it is becoming very difficult to maintain the Loco information, its Schedule, its Failures and the time to time communications between the departments.

To Overcome these drawbacks The Proposed system is an enhancement to the existing system covering some of its limitations by automating the process. The PPO which maintains the information of the Locos, Schedules the Locos, Assigns the work to different departments, Finds the repairs and all other work is computerized. This general introduction includes the scope of the system.

Home page of Planning & Technical Management System

SCOPE OF SYSTEM

  • View all the details regarding the Locos.
  • Maintain all the details regarding locos like a loco number, loco schedule.
  • Maintain the Loco failure details.
  • Activities like the update, deletions, and creations done in the system by the developer in future.

PURPOSE OF THE SYSTEM

The main aim of the Planning & Technical Management System project is to reduce the paperwork and duration of work process and to maintain the data of Electric Loco Shed efficiently the maintenance of all details is undergoing manually in the existing system. So it is becoming very difficult for the communication between the various departments of ELS and also to maintain & refer to the Loco information.

To overcome these drawbacks, computerizing the details of the Locos related to a particular Electric Loco Shed is needed. So this system is built to access the information of the loco in an easier way. The system also provides information regarding the staff attendance so that the top management can have an easy way to handle the staff members’ regularity.

EXISTING SYSTEM

The existing system is entirely being operated manually. All the registers are being maintained in hardcopy files, which is quite difficult to maintain and harder to access. It is very much time consuming and requires a lot of requisites for the information to be passed from one department to another department. And in case of replacements, if spares are not readily available, tenders are being issued so as to opt for the best quote that is obtained which is more cost efficient. Also, there is a possibility of encountering errors due to the human intervention.

PPO Department Work Description Page

PROPOSED SYSTEM

The proposed system is the computerized version of the existing system wherein all the files are digitized and stored in a database which can be accessed by only privileged users. Information regarding any worker or a loco can be instantly known at any time. Our proposed system also enhances security by maintaining the digital signatures of workers who work on a particular loco for future reference. The communication between the users of different departments is made very easier in the system.

OBJECTIVES OF STUDY

  • Maintaining digitized data for easier access.
  • Remote access to data for all the departments of ELS.
  • User-friendly environment to get the required information. 

REQUIREMENT ANALYSIS 

FUNCTIONAL REQUIREMENTS

This section describes the functional requirements of the system for those requirements which are expressed in the natural language style. They are as follows:

  • Automate tedious manual work.
  • Automatic alert provision for task completion on locos.
  • They should be able to view the required reports related to locos.

NON-FUNCTIONAL REQUIREMENTS

  • Performance: The completely separate business logic at the server side from the user interface ensures good performance.
  • Interface: the User interface is web browser based. The client-side user interface is developed using HTML and JSP.
  • Usability: This section includes all of those requirements that affect usability. It will be very easy to use for the naïve user.
  • Supportability: Choosing Java platform makes this system cross-platform independent.
  • Reliability: The system is more reliable as it inherits the Java platform qualities.

SYSTEM REQUIREMENTS AND SPECIFICATIONS 

SOFTWARE REQUIREMENTS

Operating System: Windows XP Professional

Programming Language: JAVA

Web Technology: J2EE (JDBC, JavaScript, JSP, HTML)

Browser: Mozilla Firefox

Web application server: Apache Tomcat 6.0

Model Design: Rational Rose

Data Base: Oracle 9i

IDE: NetBeans 6.7.1 

HARDWARE REQUIREMENTS

Processor: Intel P4/AMD Athlon

RAM: 256MB RAM

Hard Disk: 20GB or more

Output Screens of the project:

1 The home page of Planning & Technical Management System
2 Login page for all departments
3 Daily Schedule Page
4 Loco Schedule Update Page
5 Loco Important Parts Update Page
6 View Loco History Page
7 PPO department Work Allotment Page
8 PPO Department Work Description Page
9 General Work Allotment View Page
10 Sectional Work Allotments Page
11 Sectional View Work Page
12 Staff Description Page
13 Attendance Report Type Selection Page
14 Daily Attendance Report of the whole Department
15 Monthly Attendance Report of the whole Department
16 Daily Attendance of Individual Staff Member
17 Monthly Attendance Report of Individual Staff Member
18 Yearly Report of Individual Staff Member

Conclusion:

The primary goal of this project is to computerize the entire process being done in the Electric Loco Shed (ELS/BZA) and provide instant access to the work that is being carried out in various departments to the authorities. It further aims at providing a digital database of all the records that are currently being stored in hard copies. This is all done with user-friendly GUI and easy to understand functionalities.

The project has been successfully completed by including all the specified features. Our project team members worked hard with the help of our guide to develop the system in such a way that we can retrieve information in all dimensions.  We can confirm that the entire project has been completed as per the stated requirements.

Download Planning & Technical Management System Java Project Source Code and Database.

Car Rental System Oracle Application

A Brief Description

The aim of my Car Rental System project is to achieve an Oracle Application able to store and manipulate data. The idea is to let the manager of a car rental to control all money transactions and keep track on of available cars, clients, employees and suppliers. A main issue is to take into consideration security matters. Here Oracle appears to be satisfying from this side.

My Car Rental System project consists of a main page that has six buttons connecting it to different parts of the main database. The cars button takes us to a form that shows the car ID, brand, type, supplier ID, price per day, insurance company and most important whether the car is rented or not.

The Clients button takes us to the client’s form where the manager can view the available clients, add a client or search for a specific client. Each client has ID, first name , last name , age, country, city, road, building, stage, sex, civil state, telephone, portable, fax, email, and the most important, the cars ID that was rented by the client. The employee button takes us to the employee form that gives the Employee ID, first name, last name, age, country, city, road, building, stage, sex, salary, civil state, job and department.

Car rental system Oracle project

The suppliers button takes us to the supplier form where information like the supplier ID, telephone number and address are viewed. Then the transactions form shows the transaction ID, some information about the client, and the master credit card ID and pin code. Here we should note that, the data concerning credit cards should be connected to banks or to online services supported by banks to provide validation to the input information.

The next button named “search by picture” takes us to a form with a set of pictures each having two buttons underneath it. One button named “See” and the other “Rent”. If “See” was clicked, it will call the cars form so directly we can get other information about the selected car. If “Rent” was clicked, the client form will appear and collecting the information from the client can start directly.

All what we were talking about was the main page. But for security issues, a “Log in” page was added with a username and password that must be with the manager only. The application creator, or simply I, is the only one who is able to change the password.Car rental Oracle project Home page

Tables Creation

I created a list of tables to handle this database.

The tables are: SUPPLIER, CARS, Clients, Employee, Transactions and Authentication.

Each table has a primary key. The primary keys are the first column of each table and named by the table name adding ID. I connected the clients table with the cars table through a foreign key. An illustrating picture is shown below:

Car rental system tables creation

And for more information about table creation using sql language refer to the text file included with the project on the CD.

Procedure of Work

After creating the tables, we enter the form builder which is part of the Developer Suite 10g. An important thing here to be mentioned is one should start OC4J service before running a form.

We create a new form and start dropping Text Items in the layout editor. Then In the Object Navigator, select Data Blocks and then go to menu and select edit > create. I usually used the manual way to create a new item. After the new item is created, double click it to open the properties. In the Database panel chose the suitable table that will be connected to this Data Block Item. After that, start adding new child items to this item that will represent the columns of the table.

Here comes the step concerning connection between Text Items and Data Blocks. In fact, this is an easy step to accomplish. Just double click the Text Item and adjust the database connection in the properties panel. Specifically input in the column name, the name of the column that should appear.

A good thing to mention here is that each button has a pl-sql statement behind it to execute the command. To call other forms I used CALL_FORM(‘C:\ahmad\main’) for example. That is why placing the project in the C drive is a must for the application to run.

As mentioned above, security of such a program is a must. That’s why I added a page to log in. The code behind the log in button is the following:

[sql]

DECLARE

USERNAME VARCHAR2(20);

PASSWORD1 VARCHAR2(20);

alert11 number(10);

BEGIN

SELECT UserNameww,passwordww INTO USERNAME,PASSWORD1

FROM Authentification

WHERE UserNameww = :USER1 AND passwordww = :PASS1;

IF (USERNAME = :USER1 AND PASSWORD1 = :PASS1) THEN

alert11 := SHOW_ALERT(‘Valid’);

CALL_FORM(‘C:\ahmad\MAIN’);

END IF;

EXCEPTION

WHEN OTHERS THEN

alert11 := SHOW_ALERT(‘INVALID’);

END;

[/sql]

The code simply declares three variables username, password and alert. It queries the authentification table for all usernames and passwords specified. If found, the access is verified and an alert is called saying that the entrance is valid. If not, then the access is denied and an Invalid message is thrown.

Each time a form is called, I added in the triggers an item called when the form is loaded. I wrote “Execute_Query;”

 

E-Admissions Project in Java using Servlets and Oracle

ABSTRACT

In present day scenario, a student goes to a counseling center to get admission in an institution. This is time consuming. Moreover the colleges are not able to select the students of their choice. The main aim of this project is to convert the existing paper filling admission process into electronic filling for all new under graduate student admissions.

We create a web application for prospective students to apply for admission into the list of available colleges and courses of desired university and track the status of their application. We create an administrative web interface for the college admissions officers to review, track, and process new student applications.

class diagram of E-ADMISSIONS Project

The visitors to the E-ADMISSIONS can be both students and colleges. The student can search and fill the admission forms of selected colleges. College administration selects the students based on their academic performance and confirms their admissions. Student can also pay the fees through online after receiving the confirmation.

The fees payment can be done in two ways using credit card or DD number through online. There is also an access control system, which prevents unauthorized public to access all the information, whereas subscribed users can have full access to all available information.

MOTIVATION

The colleges for which this application has been developed were facing huge problems in the management of the admission process. Every year, students in thousands queue up for collecting admission forms and then again for submitting them. This leads to problems in managing the applications, resulting in annoyed parents and students (alike). Also, the admission process is not transparent, leading to scope for widespread malpractices.

In order to rectify these shortcomings, the online admissions system is developed. Here students need not collect physical forms, they are required to fill the admission form and submit it online. This saves a lot of time and effort on the part of the college as well as for the students. Since students interact with colleges, only the deserving candidates can get admission into the college.

PROBLEM DEFINITION:

Generally in order to get admission into an institution, the student should definitely go to the Counseling Center. In this process, colleges will not be able to pick the students of their choice. There is no proper scope of interaction between Colleges and Students. This process is quiet time consuming and hectic mainly for the students who come from long distances.

  • Present system involves more human power. As the students who apply for the colleges are not small in number, much coordination is required in order to organize the counseling process.
  • The students coming from long distances cannot afford to stay for long time near the counseling centers.

HARDWARE SPECIFICATIONS

  • Intel P-IV Processor
  •  512 MB RAM
  • 10 GB Hard Disk 

SOFTWARE SPECIFICATIONS

  • Operating System       :   Windows NT/ XP, Windows 98
  •  Languages                  :   JAVA using Servlets,

JSP with JDBC Drivers, JavaScript, HTML

  • Database                     :   Oracle
  • Web server                  :   Tomcat 5.5

Source Code of INBOX file:

[php]
<%@ page import="java.sql.*,java.util.*,Db.*"%>
<%

Connection con=DBConnect.getConnection();

String sname=(String)session.getAttribute("uname");
PreparedStatement pstmt=con.prepareStatement("select cname,status,sdate,code,branch,appid from sinbox where sname=?");
PreparedStatement pstmt1=con.prepareStatement("select appid from sinbox where sname=?");

pstmt.setString(1,sname);
pstmt1.setString(1,sname);
ResultSet rs=pstmt.executeQuery();
ResultSet rs1=pstmt1.executeQuery();
%>
<html>
<title>student inbox</title>
<center>
<font size="5" >
<b><p style="color=’#7c7cba’;font-family:’Perpetua’"><marquee behavior=’alternate’>ONLINE ADMISSIONS SYSTEM</marquee> </p></b></font>
<table width=’100%’>
<tr><td width=’100%’ bgcolor="#a2a2ce"><font size=’5px’><center>
Welcome
<%
out.println(sname);
%></center></font></td></tr><tr align=’left’><a href=’studentlogin.html’>LOGOUT</A></tr></table>

<br><br>
<center>

<table border=1 cellspacing=’0′ cellpadding=’4′ bgcolor=’lightyellow’ style="font-family:’Perpetua’;font-size:’19’">
<tr>
<th align=’center’>CNAME</th>
<th align=’center’>APPLICATION-ID</th>
<th align=’center’>BRANCH</th>
<th align=’center’>SUBJECT</th>
<th align=’center’>DATE</th>
</tr>
<%
while(rs.next()){
%>
<tr><td align=’center’><%=rs.getString(1)%></td>
<td align=’center’><%=rs.getString(6)%><input type=’hidden’ name=’appid’ value='<%=rs.getString(6)%>’ readonly ></td>
<td align=’center’><%=rs.getString(5)%></td>
<td align=’center’><%=rs.getString(2)%></td>
<td align=’center’><%=rs.getString(3)%></td>
</tr>
<%
}
%>
</tbody>
</table>

<form action="link.jsp" method="post">

<b>Application id &nbsp; :&nbsp;&nbsp;&nbsp;</b><select name="appid">

<%
while(rs1.next()){
%>
<option><%= rs1.getString(1)%></option>
<%
}
%>
</select><br>
<br>
<input type="submit" value="select" style="font-size:’16’;font-family:’Times new roman’">
</form>
</center>
</body>
</html>

[/php]

Online Course Reservation System Project in VB & Oracle

Online Course Reservation System

Aim

To develop a problem statement, SRS document, UML Diagrams, Technical, Domain & Service layers for Online Course Reservation System.

Problem Statement

The Online Course Reservation System helps a student to reserve a course from a college of his or her choice online. If a student is already registered, they can log in. Else, they have to fill up the registration form provided by the administrator. After registering, the student can log in to the system. Then the student selects the college and courses.

Then based on the qualifications of the student the system determines if the student is eligible for the course he has opted for. If the course is available the student can proceed to the payment step, where the course fee can be paid online. After paying the fee, a receipt stating the details of the student and course they selected is provided by the Administrator. Then the student successfully logs out the system.

Welcome to Online Course Reservation System

Result

Thus the problem statement for Course Reservation system is written.

GANTT CHART

AIM:

To develop Gantt chart for Online Course Reservation System.

gantt chart

RESULT:

Thus the Gantt chart for Online Course Reservation System was successfully developed.

Modern Software Requirements Specification

Introduction

This SRS contains the documentation of the requirements used in creating the Online Course Reservation System. It also contains the Use case model hierarchy and the diagrams of the use case model. The software requirement specification is mainly used for requirement elicitation .The users of SRS are the client, the users, the system analysts and the system designers.

Purpose

The main purpose of SRS document is to illustrate the user requirement of the stock maintenance system. This document is developed after a number of consultations with the client. This document will also act as a contract between the client and the developer in case of any dispute during the delivery.

Scope

The scope of the Online Course Reservation System is :

1. A student should be able to

  • Login to the software through the first page of the application
  • Enter the details clearly
  • Enter the courses information clearly

2. The administrator should recognize the personal and account details

3. The course requested by the student should be reserved.

Definitions, Acronyms and Abbreviations

VB Visual Basic, Front end
OCRS Online Course Reservation System

Overview

The Online Course Reservation System helps a student to reserve a course from a college of his or her choice online. Based on the qualifications of the student the system determines if the student is eligible for the course he has opted for. Next, student can proceed to the payment step, where the course fee can be paid online.

Overall Description

This section describes the functions of the project and their aims. It also includes the constraints and the requirements of the project. The Online Course Reservation System is aimed at helping student to reserve a course in a college of their preference. The perspective of project is to efficiently manage reservation of seats online in a simple and convenient manner. The product has a simple and easy user interface.

Use-Case Model Survey

  • Login
  • Registration for new user
  • Enter students details
  • Check student information
  • Select the college
  • Select the course
  • Online fees payment
  • Course reservation

Introduction

It is a graph of actors, a set of use cases enclosed by a system boundary and the association between actors and the use cases. A use case is a special flow of event that occurs in the system. An actor is a user playing a role with respect to the system.

 Survey Description

  • Login- Existing user can enter in to the account
  • Registration for new user- New userto create their account
  • Enter student details- Students will give academic certificates
  • Check student information- Administrator will check eligibility of the student
  • Select college- The user will select the college
  • Select the course- Students will select the course
  • Online fees payment- Online fees payment will be made using credit/debit card or net banking.

Use-Case Model Hierarchy

Following are the actors in the in the system:

   Student– One who wants to Register through online and fill the form for writing the exam

Administrator– One who get the personal details and check the eligibility of the candidate.

Diagrams of the Use-Case Model

Diagrams, primarily use-case diagrams, of the entire use case model are included here

Assumptions and Dependencies

  • The user must have connected to the internet to use the system
  • The user’s computer  must be Windows 98 or later version platform
  • TCP/IP protocol must be installed to communicate  through HTTP message
  • The accuracy of the information of users is the responsibility of all users

Requirements

Online Course Reservation System requires Visual Basic 6.0 and Oracle 10g to be installed in the system. Also there will be a database which will keep all the records done by user while registration and course selection.

Use-Case Specifications

The various use cases are

  • Student details
  • Student Login
  • Course Selection
  • Payment
  • Course reservation
  • Update database

Functionality

The main functionality of system is that we can get from online even at our home itself.

Usability

Online Course Reservation System is very user friendly. Users can easily register and reserve a course of their choice.

Reliability

The system shall operate 95% of the time. The number of defect should not exceed 10 per function. In addition, before the submission of the final release the calendar must be tested in case of the defects over 10 per function.

Performance

  • The system shall accommodate 500 users during the peak usage time  window of  8:00am to 10:00am local time, with estimated average session duration of 45
  • All web pages generated by the system shall be fully downloadable in not more than 10 seconds over a 40KBps modem connection.
  • The system can display confirmation message to users within 4 seconds after the user submits information to the system.

Supportability

The system is supported by Visual Basic for design and Database Management Concepts for backend database storage.

Design Constraints

The design constraints of Hardware and Software

The Hardware:

The various hardware constraints needed are CPU, Processor speed, Coprocessor speed etc.

 The software:

The various software constraints are Front end, Back end and OS.

Online User Documentation and Help System Requirements

None

Purchased Components

None

Interfaces

It describes the various interface needed for the user

User Interfaces

The user interface is Windows XP Operating System.

Hardware Interfaces

The Hardware interfaces are:

CPU                            :           Core 2 Duo

Processor speed           :           2 GHZ

Coprocessor                :           Built in

Total RAM                  :           3 GB

Hard Disk                   :           250 GB

Keyboard                    :           105 Keys

Mouse                         :           Logitech Mouse

Operating system        :           Windows XP/2007/Vista,

The software interfaces are:

Front end                    :           VB

Back end                     :           Oracle

Operating System       :           Windows XP

Coach Management System Project in Java

Though, all the user requirement have been meet , the road does not end here. Future development can be undertaken to enhance the functionality and to increase the efficiency of the “Traction Loco Control ”

Poh shop detailas

The fact that this system is going to evolve everyday in the upcoming month. The team can’t just sit back new technologies package has to be incorporated in the system to make it fully secure and full proof. Also additional care has to be take to maintain the database which is going to increase and migrate it to other platform which can handle excessive load.

Coding:

[php]

import javax.swing.*;

import java.awt.*;

import java.awt.event.*;

import java.sql.*;

class help implements ActionListener

{

private JDialog dialog = new JDialog((Frame)null, "Help", true);

JLabel l1=new JLabel("COACH MAINTANANCE SYSTEM");

JLabel l2=new JLabel("Please Contact :- Sujeet Kumar Singh");

JLabel l3=new JLabel("Address             :-  C/O-R.C.Matho,Veer Sivajee path");

JLabel l4=new JLabel("North S.k.puri,dist-Patna");

JLabel l5=new JLabel("Bihar,   pin-800013");

JLabel l6=new JLabel("Contact no        :- 9308105802");

JLabel l7=new JLabel("Special Thanks For Mr. Rajesh Kumar");

JLabel l8=new JLabel("And Logic Solution");

JLabel image=new JLabel(new ImageIcon("logo2.gif"));

JButton b1=new JButton("Ok");

JPanel p=new JPanel();

help()

{

Container Pane=dialog.getContentPane();

dialog.setBounds(200,200,500,400);

p.setLayout(null);

l1.setBounds(50,30,475,30);

l1.setFont(new Font("",Font.BOLD,22));

l2.setBounds(100,75,300,30);

l2.setFont(new Font("",Font.BOLD,16));

l3.setBounds(100,100,400,30);

l3.setFont(new Font("",Font.BOLD,16));

l4.setBounds(230,125,300,30);

l4.setFont(new Font("",Font.BOLD,16));

l5.setBounds(230,150,300,30);

l5.setFont(new Font("",Font.BOLD,16));

l6.setBounds(100,180,300,30);

l6.setFont(new Font("",Font.BOLD,16));

l7.setBounds(95,275,400,25);

l7.setFont(new Font("",Font.BOLD,16));

l8.setBounds(175,300,400,25);

l8.setFont(new Font("",Font.BOLD,16));

image.setBounds(200,225,100,50);

b1.setBounds(210,325,80,30);

p.add(l1);p.add(l2);p.add(l3);p.add(l4);p.add(l5);

p.add(l6);p.add(l7);p.add(image);p.add(l8);p.add(b1);

b1.addActionListener(this);

Pane.add(p,"Center");

dialog.setVisible(true);

}

public void actionPerformed(ActionEvent e)

{

if(e.getSource()==b1)dialog.setVisible(false);

}

public static void main(String sr[])

{

new help();

}

}

[/php]

Future Application

This Project can be easily updated according to the needs of Mechanical Department of any railway zone.  This is made in such a way that it can be easily modified in a more advanced form if there will be such need.  The database of this software maintains the records of the details of Coaches who have been attached to the rake and the details of maintenance schedule of the coach.  These records will have a lot of use in future related to any enquiry.

This database can seamlessly be used by other candidate systems to be developed in future. It can be further developed as a net-centric database. The transactions are also revealed in this project.  Any financial enquiry can be satisfied easily through this software.  Hence, this project covers all-important details regarding the “Number Allocation System for Coach” of the Railway Zone. Therefore in future it will help to provide some important information’s, which may help in development of the company.

The main scopes and future enhancements are as follows

  • Proposed system can be delivered on a 3-tier architecture so as to improve scalability and performance
  • Browser Enabled User Interface for distributed Application
  • Arrangement for automatic back up and replication of database.
  • Enhanced security features like e-signature and public key encryption technology features for secure transfer of confidential data
  • On-Line help feature for “Expert Advice and Error Shooting”.

INTRODUCTION OF THE PROJECT 

Indian Railway is lifeline of India.. Ever Since the evolution of human being on this earth it has been a matter of immense curiosity for them to invent new things in life to make life easier and hassle free. Owing to its nature humans have always kept inventing and discovering for better livelihood. Going back to our past we see some Great inventions of mankind and one such is that of Railway.

The noval plan for the introduction of Indian rail system, Transformed whole history of INDIAN RAILWAY. The innoavative plan was first propsed in 1832, however auxiliary actions were taken for over a decade. In the year 1844, private enterpreneurs were allowed to launch a rail system by lord Hardinge, who was the Governer-Genral of India. By the year 1845, two companies were formed and east India Company was requested to support them in the matter.

  INDIAN RAILWAY have been divide into nine (9) zones- Western, Central, Northan, North Eastern, Northeast, Frontier, Southern, South Central, South-central & South-eastern covering the largest route length of cover 63000 kms of total Indian boundary. The last stations of the four directional boundaries are West-Mumbai South-Kanyakumari, East-Guwahati, and North-Jammu.

There are five types of trains which are running in the Indian Railways that are given below:

  1. Passenger train

                     2. Mail/Express

                     3. Shatabadi train

                     4. Jan-Shatabdi

                     5. Rajdhani

The Shatabdi train is the fastest among all these trains and covering only some of the destination. In the Indian Railway Coach Maintenance Department is the most important. There are many work handles in POH SHOP, these are given below:

  • Carraige Poh Shop
  • Wagon Poh Shop
  • Diesel Poh Shop
  • Production Poh Shop
  • Electric Rolling Poh Shop
  • Electric Shop

There are many production-units from where the coaches are newly manufactured that are:

  • Chittaranjan Locomotive Works
  • Diesel Locomotive Works, Varanasi
  • Integral Coach  Factory, Perambur
  • Rail Coach Factory, Kapurthala
  • Wheel & Axle Plant, Bangalore
  • Diesel Component Works, Patiala
  • The research Design and Standard Organization, Lucknow, provides vital inputs in R&D towards modernization.
  • 6 prestigious public sector undertaking : IRCON, RITES, CRIS, CONCOR, IRFC and Konkan Railway corporation. 

When, the coach is prepared in the POH SHOP. The train go to the yard. A Railway yard is an area having a network of railway tracks and siding for Storage and maintenance of cars and engineers. In the marshalling yard of Indian railway in which trains are assembled and good are loaded. In the marshalling yard railway wagons are Shunted and made up into trains.

In the yard, the  coaches are maintained in 3-schedules namely:-

1.A-Schedule

2.B-Schedule and

3.C-Schedule

  1. A-Schedule:- A Schedule is primary schedule. This schedule is done every month for any coach.
  2. B-Schedule:- This schedule is done in any coach after 3-month in the yard.
  3. C-Schedule:- This schedule is done in any coach after 6-month in the yard.

IOH means intermediate over holding. In this shop the coaches are maintained any time when necessary.

Apart from these register the organization has to publish reports about the coaches to supervisior.

Seceondary Detachment

Some times during running of the train some faults occur in a coach or number of coaches or entire rake. Then coaches are detached from that rake and sent for maintenance. This is called secondary detachment of coach.

My Job is to convert these entire manual jobs to a computerized system. My project work is the outcome as solution to the aforementioned manual jobs. This project is being done under DRM Office, Danapur (ECR).