Break down of the accounts with their individual classifications.Full description
A PROJECT REPORT ON ACCOUNT MANAGEMENT SYSTEM A TECHNICAL PROJECT REPORT SUBMITTED IN PARTIAL FULFILLMENT OF THE REQUIREMENT FOR THE DEGREE OF
MASTER IN COMPUTER APPLICATION UNDER BPUT, Orissa
Submitted By:Jyoti Brahmamayee Priyadarsini Dash Regd. No - 1005292015
Under Guidance Of:Prof. Asit Kumar Sar
Dept. of MCA
GANDHI ENGINEERING COLLEGE BHUBANESWAR, ODISHA – 752054, INDIA [2012 – 2013]
DEPARTMENT OF MCA GANDHI ENGINEERING COLLEGE BHUBANESWAR, ODISHA - 752054
CERTIFICATE This is to certify that, Jyoti Brahmamayee Priyadarsini Dash, a Student of 6 th Sem., MCA of Gandhi Engineering College, Bhubaneswar bearing Regd. No. 1005292015 hass ha
succ su cces essf sful ully ly de deve velo lope ped d th thee pr proj ojec ectt en enti titl tled ed “ACCO “ACCOUNT UNT MANA MANAGEM GEMENT ENT
RICHMOND OND TECHNOLOGY TECHNOLOGY LTD for submi submission ssion and partia partiall fulfil fulfillment lment SYSTEM” of RICHM for the award of the degree of Master in Computer Application (MCA) of Biju Pattnaik
Univ Un iver ersi sity ty of Te Tech chno nolo logy gy,, Ro Rour urke kela la du duri ring ng th thee ac acad adem emic ic ye year ar 20 2012 12-2 -201 013 3 (Semester-VI) under our supervision and guidance. The matter embodied in this project work has not been submitted for the award of any other degree. During this period of work, he is sincere and fully dedicated to her project work. Her character and conduct is good. We wish her all success in her life.
Prof. Asit Kumar Sar Dept. of MCA, GEC, BBSR Internal Supervisor
HOD Dept. of MCA, GEC, BBSR
External Supervisor
DEPARTMENT OF MCA GANDHI ENGINEERING COLLEGE BHUBANESWAR, ODISHA - 752054
CERTIFICATE This is to certify that, Jyoti Brahmamayee Priyadarsini Dash, a Student of 6 th Sem., MCA of Gandhi Engineering College, Bhubaneswar bearing Regd. No. 1005292015 hass ha
succ su cces essf sful ully ly de deve velo lope ped d th thee pr proj ojec ectt en enti titl tled ed “ACCO “ACCOUNT UNT MANA MANAGEM GEMENT ENT
RICHMOND OND TECHNOLOGY TECHNOLOGY LTD for submi submission ssion and partia partiall fulfil fulfillment lment SYSTEM” of RICHM for the award of the degree of Master in Computer Application (MCA) of Biju Pattnaik
Univ Un iver ersi sity ty of Te Tech chno nolo logy gy,, Ro Rour urke kela la du duri ring ng th thee ac acad adem emic ic ye year ar 20 2012 12-2 -201 013 3 (Semester-VI) under our supervision and guidance. The matter embodied in this project work has not been submitted for the award of any other degree. During this period of work, he is sincere and fully dedicated to her project work. Her character and conduct is good. We wish her all success in her life.
Prof. Asit Kumar Sar Dept. of MCA, GEC, BBSR Internal Supervisor
HOD Dept. of MCA, GEC, BBSR
External Supervisor
DECLARATION I, Jyo studen entt of Mast Master er in Jyoti ti Br Brahm ahmama amayee yee Pri Priyad yadars arsini ini Da Dash sh, stud Computer Application, Gandhi Engineering College, and Bhubaneswar hereby declare SYSTEM” has been that the project report entitled “ACCOUNT MANAGEMENT SYSTEM”
done by me under the guidance of Prof. Asit Kumar Sar (Internal Supervisor), GEC, Bhubaneswar for the partial requirement for the Master in Computer Application Degree.
This This Proj Projec ectt Subm Submit itte ted d by me is the the effo effort rt of me and and has has not not been been deposited to any other organization or published earlier.
Place: Bhubaneswar
Date: 20/05/2013
Jyoti B P Dash
ACKNOWLEDGEMENT Completing a job has never been an easy go for a single person, often it is the result of invalu invaluabl ablee contri contribut bution ionss from from indivi individua duals ls in the surrou surroundi nding ng in a direct direct or indirec indirectt manner.
We are deeply grateful to our advisor Prof. Harry Narayan Swain, for having been a constant source of encouragement for my Project Report on “ACCOUNT MANAGEMENT SYSTEM,,
In our association association with our guide guide for this purpose, we experienced experienced not only his indepth knowledg knowledgee but also his affection affection towards us. We would would like to thank all our friends who have helped us for successful completion of our Project.
Last, st, but not the leas east, we give our sin sincer cere thank anks to
Mrs. Mrs. Arat Aratii
Pradhan,Technical Pradhan,Technical Project In-charge, In-charge, for giving me the opportunity opportunity and creating a nice
work environment for me to complete my technical Project report within the stipulated period of time.
Jyoti Brahmamayee Priyadarsini Dash
CONTENTS
1. Abstract……………………………………………………………………….6-7 2. Introduction.....................................................................................................8-10 3. System Analysis………………………………………………....................11-14 3.1. Objectives of System 3.2. User Requirements 3.3. Hardware And Software Requirements 4. Software Design……………………………………………………………15-24 4.1. UML Diagrams 4.1.1.
List of Abbreviations JSPJava Server Page SRS Software Requirement Spcification UML Unified Modeling Language ER Entity Relation
List Of Figures Particulars
Page No.
1. Figure 1.1 Context Level Diagram
10
2. Figure 1.2 E – R Diagrams
14
3. Figure 2.1Use Case Diagram
18
4. Figure 3.1Sequence Diagram
19
5. Figure 3.2State Chart Diagram
20
6. Figure 3.3Activity Diagram
21
List Of Tables Table
Page
No.
1.1 Table Table 1 Userdet 29
1.2 Table Table 2 Login 29
2.1 Table 3 Facdet :: :: :: N Table N Category
30
ABSTRACT This project is aimed at developing an application for the Training and Placement Department of the College. The system is an application that can be accessed throughout the organization with proper login provided. This system can be used as an application for the ACCOUNT MANAGEMENT SYSTEM (AMS)of the college to manage the student information with regard to placement. Students logging should be able to upload their information in the form of a CV. The key feature of this project is that it is a onetime registration. Our project provides the facility of maintaining the details of the students. It also provides a requested list of candidates to recruit the students based on given query. Administrator logging in may also search any information put up by the students. This project will aid colleges to practice full IT deployment. This will also help in fast access procedures in placement related activities.
INTRODUCTION This project is aimed at developing an online application for the Training and Placement Dept. of the college. The system is an online application that can be accessed throughout the organization and outside as well with proper login provided. This system can be used as an application for the TPO of the college to manage the student information with regards to placement. Students logging should be able to upload their information in the form of a CV. Visitors/Company representatives logging in may also access/search any information put up by Students. Training and Placement cell is active and working hard to address behavioral issues and over all personality development; and finding job opportunities for students and placement of students with reputed national and international organizations.
FEATURES: •
This project is to facilitate students in college to register, search and apply for jobs.
•
The user can access easily to this and the data can be retrieved easily in no time.
•
In the main page there are options for a new register, a registered student to directly
login using username and password, submit resume.
In the student registration form, we can give personal details, educational
•
qualifications, and professional skills and upload resume. •
The job details of the placed students will be provided by the administrator.
•
The administrator plays an important role in our project. They provide approval of
student registration and updating.
OBJECTIVE OF THE PROJECT Our project provides the facility of maintaining the details of the students and gets the requested list of candidates for the companies who would like to recruit the students based on given query. Work in the application wiil be done in the following ways
The categories of CVs are decided and uploaded and define it formally.
A server is used for storing the data.
The front-page of the system is created giving a brief description about the system
and a
login box. A role of approve is also introduced. When the student uploads his/her CV, the
approver should approve the document and only then can be uploaded. (Make appropriate assumptions).
SCOPE OF THE PROJECT
Our project has a big scope to do. We can store information of all the students. CV’s are categorized according to various streams. Various companies can access the information. Students can maintain their information and can update it. Notifications are sent to students about the companies. Students can access previous information about placement.
SYSTEM ANALYSIS SYSTEM: •
Designing and implementing the new links.
•
Designing and implementing the users.
•
Arranging new links as subject wise.
SYSTEM ANALYSIS:
System analysis will be performed to determine if it is feasible to design information based on policies and plans of the organization and on user requirements and to eliminate the weaknesses of the present system. •
The new system should be cost effective.
•
To expand management, improve productivity and services.
•
To enhance user / system interface.
•
To improve information quality and usability.
•
To upgrade systems reliability, availability, flexibility and growth potential.
3.1 Objective of the System: The main objective of the system is that to provide quality education with proper resources to the students in a reasonable expenditure. Improve the quality of education and also improve the lab facilities, teaching qualities, classroom facilities and other facilities for the students. Main aim is that make available results online for the students they can available 24/7 for the students.
Objectives:1. The System is composed with convenient modules of setting and editing the convenient modules for the students to give their opinions about the lecturers and know about the college details. 2. Modules are designed user friendly they can reach anywhere directly without any confusion.
3. This system is designed to save the time and reduce the paper work for taking opinions and making assessments. 4. Administrator will introduce the new colleges to the students to increase the options to the students while joining / selecting the colleges.
3.2 User Requirements: 1. User has to register with the system for using all the facilities available in the system 2. Student User has to submit his opinion about his faculty by course, name, subject and department / branch wise. 3. Student can view his results semester wise, it will give the information he/she has promoted/ demoted in the examinations. 4. Student has to login with his id number, which is assigned by the system. 5. College user has to provide details of total number of student, faculty members and contact information. 6. User can view the assessment details by way of charts and bar diagrams and providing course name, branch name, year etc. 7. This system runs any platform; user can access the student id from any place.
3.3 Software & Hardware Requirements:
a) HARDWARE REQUIREMENTS: Processor
:
Intel Pentium4 and above
Processor Speed
:
RAM
:
Hard Disk
:
833MHz and above 1GB RAM 40GB
b) SOFTWARE REQUIREMENTS: Operating System
:
Windows XP/Vista/7
Database
:
MYSQL
Server side technology
:
Servlet
Server side scripting
:
JSP
Client side scripting
:
HTML
Web-Server
:
Apache HTTP
UML DIAGRAMS
4.1. UML DIAGRAMS: 4.1.1 USE CASE DIAGRAM: •
A use case diagram is a diagram that shows a set of use cases and actors and relationships.
Contents •
Use case commonly contain
Use cases
Actors
Dependency, generalization and association relationships
Overall Use Case:
Administrator Use Case
Student Use Case:
DATABASE DESIGN 5.1 DATABASE DESIGN: Database Design is crucial task for each and every body .It is the most vital thing for a project .Once u got the idea about the Database structure then there is nothing too difficult to complete the task. Maximum of time would be spend for designing a proper database structure .So keeping in mind that thing here we are providing u the database designing as well as the number of tables would be required for the project work. These database tables are as mentioned below...
Data Base Design Snap Shot:
ADMINISTRATOR:
LOGIN_DETAILS:
EMPLOYEE DETAILS:
STUDENT DETAILS:
EMPLOYEE ACCOUNT:
COOLEGE ACCOUNT:
ER DIAGRAM
Address
Student ID
Admin
Gender
Father’s Name
DOB
Mother’s Name
College Name MCA Agreegate %
Pass Year X
Student
Percentage Grad. Pass Year Grad.
Percentage X Pass Year XII Percentag e XII
College Name
Admin_I D
ID UserType
Admin Login
User_name
Password
id totalAmou nt Date
Collegeaccount
Description
type transAmount
Purpose
DATA FLOW DIAGRAM (DFD) Data Flow Diagram is a diagrammatic representation of data movement through a system –manual or automated - from inputs to outputs through processing. The data flow diagrams help in the analysis of the flow of data through a system and thus help in identifying the system requirements. These are of two types – Logical Data Flow Diagrams and Physical Data Flow Diagrams. The Data Flow Diagram (DFD) clarifies system requirements and identifies major transformations that will become programs in system design. It is the starting point of system design that decomposes the requirements specifications down to the lowest level of detail.
1. LOGICAL DATA FLOW DIAGRAMS: (0 th Level)
The Logical Data Flow Diagrams represent the transformation of the data from input to output through processing logically and independently of the physical components that may be associated with the system.
2. PHYSICAL DATA FLOW DIAGRAMS: The Physical Dataflow Diagrams show the actual implementation and movement of data between people, departments, and workstations. Each component of a DFD is labeled with a descriptive name. Process names are further numbered that will be used for identification purposes. The number assigned to a specific process does not correspond to the sequence of processes. It is strictly for identification purposes. A data flow diagram allows parallel activities i.e. a number of dataflows coming out from the source and going into the destination. A DFD concentrates on the data moving through the system and not on the devices or equipments. A DFD may consist of a number of levels. The top-level diagram is called the Context Diagram, which consists of a single process and plays a very important role in studying the system. It gives the most general and broadest view of the system. Move over it gives the pictorial representation of the scope boundaries of the system under study.
3 NOTATIONS: Rectangle: Used to represent by an External Entity .
Circle: Used to represent by a process with the name of the corresponding function .
Arrow: Used to represent by flow of data .
Parallel lines: Used to represent the storage of data .
Output symbol: Used to produce hard copy of report .
if(i == 1) { stmt.executeUpdate("UPDATE "+batch+" SET restFee="+restFee+" , instalments="+instalments+" , inst1="+amount+" , inst1_recpt='"+Receipt+"' WHERE id="+id); out.print("
Your 1st Installment is Paid Successfully.You Need to Paid Rest Amount in Other 2 Installments
"); } else if(i == 2) { stmt.executeUpdate("UPDATE "+batch+" SET restFee="+restFee+" , instalments="+instalments+" , inst2="+amount+" , inst2_recpt='"+Receipt+"' WHERE id="+id); out.print("
Your 2nd Installment is Paid Successfully.You Need to Paid Rest Amount in Next Installments
"); } else if(i == 3) {
if(feeRest == totalFee) { stmt.executeUpdate("UPDATE "+batch+" SET restFee="+restFee+" , instalments="+instalments+" , inst3="+amount+" , inst3_recpt='"+Receipt+"' WHERE id="+id); out.print("
Congratul ation, You Paid All Your Course Fee
"); } else {
out.print("
Sorry! You Need to Pay All the Rest Ammount in This Installment.
"); }
} else { out.print("
Your Already Paid All your Course Fee.
"); }
con.close();
con=db.DbConnect.getCon(); stmt=con.createStatement(); String desc = "Student Having Reg No. "+reg+" paid this course fee."; if(i == 1 || i == 2) { stmt.executeUpdate("INSERT INTO collegeaccount VALUES( "+StrId+", '"+date+"', "+totalAmount+", 'Credited', "+amount+", 'Student Paid as Course Fee', '"+desc+"')"); } else if(i == 3) { if(feeRest == totalFee) { stmt.executeUpdate("INSERT INTO collegeaccount VALUES( "+StrId+", '"+date+"', "+totalAmount+", 'Credited', "+amount+", 'Student Paid as Course Fee', '"+desc+"')"); }
} else {} con.close(); %>
Homepage
Pay Course Fee Choose course
Pay Course Fee: Student Details
Pay Course Fee: Enter Course Fee Details
View Course Fee Details
Pay Employee Salary: Choose Year And Month
Pay Employee Salary: Salary Details For All Employee
Pay Employee Salary: Enter Bank Transaction ID
View Salary Details
College Account: Add Transaction
College Account: View All Transactions
CONCLUSION This system is developed using java as front end tool and MYSQL server as back end tool. The system is developed after studying the requirements and necessities of the system. Large data can be securely stored and accessed through MYSQL Server Database using queries. As the system is created in a user friendly manner with appropriate message guiding the user, even a person with minicomputer knowledge will be able to use the system. The key features of the project: •