Fee Management Software

1. Feasibility Study

1. Introduction

The Fee Management Software (FMS) is software which output as information that can be used by the accountant and also for management for college. Output will get the information of fees.

                The FSM help them to reduce the workload and maximize the effectiveness. Fee billing is very important for any institution.

1.1   Technical Feasibility:

In technical feasibility the prime importance is given to development, resource availability and technology. The resource required which include server and client side software and hardware.

In our college all the activities are computerized except the fee management. So the minimum technical equipments required to this project are available in our college. The fee management software is technically feasible in our college.

1.2Economic Feasibility:

An evaluation of development cost weighted against the ultimate income or benefits derived from the developed application. Economical justification includes a broad range of concerns that include cost benefit analysis. Cost benefit analysis includes costs for product development and weights them against tangible and intangible benefits of the application.

Our project Fee management software does not use any extra software or hardware. Development and operating cost is less and the benefit is very high and small in size. So it is economically feasible in our college.

1.3Operational Feasibility:

     The proposed system offers the greatest level of user friendliness and combined with greater processing speed. Since the processing speed is very high compared to that of manual (traditional), the accountant can take timely actions depending on information obtained. Since the workload is also reduced, accountant concludes that the project is feasible.

2. Project Organization

Project Leader     Manu George

Quality Analyst    Manu George

Designer Sakkir

System Administrator: Mrs.Beena Ranjith

Programmer.3 Manu George

Document writer Jophy Joseph

Programmer.1 Sakkir

Programmer.2 Jophy Joseph

 

3. Project Startup And Planning

3.1   Preparing Project  Plan

For the purpose of FSM in thecolleges, officershave to collect the information and profile of students and manage them. When we approached Mrs.Beena Ranjith Madam, cashier in our college, we understood that all the operations required managing the Fees is done by her alone. So to reduce this job we thought to create a new system which is processed through computers.

3.2   Manpower

Role	Name
Team Leader Quality Analyst Document Writer Programmers System Administrator	Manu George Manu George Jophy Joseph Sakkir Sulaiman Manu George Jophy Joseph Mrs. Beena Ranjith

3.3 Hardware andNetworking OS

A web hosting service is a type of Internet hosting service that allows individuals and organizations to make their own website accessible via the World Wide Web. Web hosts are companies that provide space on a server they own or lease for use by their clients as well as providing Internet connectivity, typically in a data center. Web hosts can also provide data center space and connectivity to the Internet for servers they do not own to be located in their data center, called collocation.

            The scope of hosting services varies widely. The most basic is web page and small-scale file hosting, where files can be uploaded via File Transfer Protocol (FTP) or a Web interface. The files are usually delivered to the Web "as is" or with little processing. Many Internet service providers (ISPs) offer this service free to their subscribers. For this project the development platform is asp.net so the server space is provided by the Windows server. Single page hosting is generally sufficient only for personal web pages. A complex site calls for a more comprehensive package that provides database support and application development platforms

The host may also provide an interface or control panel for managing the Web server and installing scripts as well as other services like e-mail. Some hosts specialize in certain software or services (e.g. e-commerce). They are commonly used by larger companies to outsource network infrastructure to a hosting company.

            The operating system requirements are: server should be of Windows XP or Windows Vista or Windows 7. Client could be Windows 9x, Windows XP, Windows Vista etc.

3.4  Data Base Management System

A database management system is used to store data in a database. Users can access the data and manipulate it. An application can provide the user with interface to the database. Here we are using MySQL database.

MySQL

The Structured Query Language (SQL) comprises one of the fundamental building blocks of modern database architecture.SQL is an ANSI (American National Standard Institute) standards computer language for accessing and manipulating database systems.

A database most often contains one or more tables. Each table identified by a name. A table contains record with data. With SQL we can query a database and have a result set returned.                      MySQL is comprehensive, integrated data management and analysis software that enables organizations to reliably manage mission-critical information and

Confidently run today's increasingly complex business applications. MySQL allows companies to gain greater insight from their business information and achieve faster results for a competitive advantage.

3.5 Development Tools And Language Combined

 Java Net Beans IDE

                 The Net Beans IDE (Integrated Development Environment) is a open source and is written in java programming language. It provides the services common to creating desktop application such as window and menu management, setting storage. Net Beans is an object oriented language and it provides security, reliability and accessibility.      

Java Compiler

Java compiler is a compiler for the java programming language. The most common form of output from a java compiler is java class files containing platform neutral java byte code.

The java virtual machine loads the class files and either interpret the byte code or just in time compose it to machine code and then possible optimize it using dynamic compilation.

This proposed software is going to be developed using the latest technology from Sun Microsystems called Java Net Beans 6.8.SQLConnectoris the software that connects information, people, systems, and devices. It spans clients, servers, and developer tools.
A Java program can be connected with the database by using JDBC. JDBC standard defines an API that java programs can use to connect to database servers. The java program must first open a connection to a database and can then execute the SQL statements. The Library

function Drive Manager. GetConnection performs the connection to database. Before opening a connection, the appropriate drivers for the database are loaded using Class forName.

Advantages of Net Beans

     The Net Beans Framework offers a number of advantages to developers.
1. Consistent programming model
     Different programming languages have different approaches for doing a task.

2. Direct support for security
     Developing an application that resides on a local machine and uses local resources is easy. In this scenario, security isn't an issue as all the resources are available and accessed locally

3. Simplified development

4. Easy application deployment and maintenance

5. Interoperability.

4. Requirement Study and Analysis

4.1   User Interviews:

When we approach the office accountant in our college Mrs. Beena Ranjith, we understood that all the operations required to manage the Fee collection are done by manually. So to reduce the manual operations we thought to create a new software which is processed through computers.

4.1.1 Description of Existing System

            In our college, fees management and documents of students are done manually. They have to arrange student’s information according to various departments. The accountant has to collect the fee of all individuals who want to pay Fees. For informing the dues of fee payment, he should given that in the notice board.

4.1.2 Problems Encountered In The Existing System

            The size of collection of resume may be very large. To handle such a large collection of resume is very difficult. Arranging these resume according to various departments and match them with the college ID number is very difficult task for accountant. It takes a lot of storage space and time consume because of using papers.

4.1.3 New Requirements

            Our proposed system is aimed at developing a Fee Management Software of our college. By using our system the accountant can enter and modify each student’s resume. The details of students are stored in a database and it can reduce the paper work and storage area.This will provide improved accuracy in results.

To develop a system that would recompiles the following:

Ø  Reduce the paper work and storage area.

Ø  Improve the output of operators.

Ø  Allow easy navigation through resume and company information

4.2Functional Decomposition of Proposed System

The proposed system aimed to reduce the drawbacks of the present system and hence improve the capabilities.The proposed system can be functionally decomposed as follows.

4.2.1 Create a Student Record

4.2.1.1 Introduction

            In this process, administrator can register a student in to the college.

4.2.1.2 Input and Processing

4.2.1.3Output

Registered successfully

4.2.2 Update University Number

4.2.2.1 Introduction

Here We Update the Student University Register Number

4.2.2.2 Input and Processing

                            

4.2.2.3 Output

            The entered student details updated and will be stored into the database

4.2.3 Remit Fees

4.2.3.1 Introduction

            To enter the fees structure as per the Govt and management

4.2.3.2 Input and Processing

4.2.3.3out put

            Save successfully

4.2.4 Preview student details

4.2.4.1 Introduction

 To preview all the student details

4.2.4.2 Input and Processing

4.2.4.3 Output

            Preview successful

4.2.5 Search report

4.2.5.1 Introduction

            Find the details of a particular student.

4.2.5.2 Inputand Processing

4.2.5.3 Output

Search successfully

4.2.6 Print the fees receipt

4.2.6.1 Introduction

            To print the fees receipt of particular student.

4.2.6.2 Input and Processing

4.2.6.3 Output

            Printed successfully

5. Context Analysis Diagram (CAD)

The Context Diagram focuses on relationships with external entities and identifies the information that is exchanged between these external entities and the business system under review. System context diagrams can be helpful in understanding the context which the system will be part of. 

The Context Diagram at the project level is the root of the Functional Decomposition at the conceptual level ofdetail.  The Context Diagram is level zero of the decomposition.

.

Fee Management                      System

                                                                                          College                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      Student/Fee                                                                                                                      Accountant                                                                                                                                                                                                        

                                                                                        

6. Data FlowDiagrams

Preview student details

Search Student record

Update University number

Student database

Fee Info database

Create a Student record

Remit  fees

Print the fees report

STUDENT_DETAILS

REPORT

REPORT

FEE_DETAILS

REPORT

Input Process

 

Data Flow                     Report                     Stored Database

7. Identification of Entities

1.      student ( Physical)

2.      SEMESTER (Physical)

3.      FEES (MGT/GOVT)(Physical)

8. Entity-Relationship Diagram

STUDENT

Semester

 

                                                                                                                                               

Enrolled

 

                                                                                                                                               

Remit Nnnnn

Fees (Mgt/Govt)

 

9. Identificationof Attributes

1. Student

ð  Student register number

ð  Student First name

ð  Student last name

ð  Gender

ð  Date of birth

ð  Phone number(1…n)

ð  Student Admission Number

ð  Course name

ð  Branch

ð  Address(1…n)

2. Govt/Management Fees

ð  Fees

ð  Admission/Registration Fee

ð  Tuition fee

ð  Caution deposit

ð  University affiliation fee

ð  Sports fee

ð  Student fund

ð  Technical association fee

ð  ID card

ð  Matriculation fee

3. Semester

ð  Semester 1

ð  Semester 2

ð  Semester 3

ð  Semester4

ð  Semester 5

ð  Semester 6

ð  Semester 7

ð  Semester 8

10. SecuirityAnalysis

                In our project Fee Management Software, the main security analysis comes under the entity level analysis. In our software, some of the attributes can be only edited and accessed by some entities. So different access levels are there for accessing each cells. We have mainly 3levels.

Ø  System level

Ø  Entity level

Ø  Attribute level

In system level, the accountant can register a student entry in the college and can update their resume if any modifications are required. So each student has their admission number and year of admission.

In entity level, each student has their own id and year of admission.

In attribute level, accountant deals with the student details .Thus student details cannot be lost by other users.

11. Normalization

When designing a relational database, it is normally a good thing to "normalize" the database.  There are different degrees of normalization, but in general, relational databases should be normalized to the "third normal form".  Simply put, this means that the attributes in each table should "depend on the key, the whole key and nothing but the key".

11.1 First Normal Form

 A relation R is in first normal form (1NF) if and only if all underlying domains contain atomic values only.

Student Table

ð  First name

ð  Middle name

ð  Last name

ð  Address

ð  Branch

ð  Phone

ð  Register number

ð  Admission number

ð  Gender

ð  Blood group

ð  Year of admission

ð  Govt/Management etc

Fee information

ð  Year of admission

ð  Admission number

ð  Admission/Registration fee

ð  Tution fee

ð  Sports fee

ð  Matriculation fee

ð  University Affiliation fee

ð  Caution deposit

ð  ID card

ð  Technical association fee

ð  Total etc...

11.2 Second Normal Form

A Relation R is in Second Normal Form (2NF) if and only if it is in 1NF and every non-key attribute is fully dependent on Primary Key.

Student Table

ð  First name

ð  Last name

ð  Gender

ð  Date of birth

ð  Branch

ð  Admission number

ð  Year of admission

ð  University register number

Fee information

ð  Admission/registration fee

ð  Caution deposit

ð  Tution fee

11.3 Third Normal Form

          No dependencies  on non key attributes. The third normal form is a normal form used in database normalization. The definition states that a table is in 3NF if and only if the following conditions hold:

The relation is in 2NF

Every non prime attribute is non transitively dependent on every key.

12. Table Creation

Stud Details:

Column name	Col_description	Data Type	Width	Constraints
FName	First name	varchar	20
LName	Student last name	varchar	50
Address	Address	varchar	50
AdmNumber	Admission number	int	20	PK
MName	Middle name	Varchar	8
PhNumber	Phone number	Int	50
YearofAdmission	Blood group	varchar	50
Branch	User name	varchar	50
Gender	gender	Varchar	50
BloodGroup	Blood group	varchar
Govt/Mangt	Government/managmentt	Varchar	50
PFName	First Name	Varchar	50
PMName	Last name	Varchar	50
PLName	Phone number	Int	50
ContactNumber	Phone number	Int	50
UnivNumber	University register number	Varchar	50
Date	date	Varchar	50

Fee Information

Yearofadmission	Year  of admission	Int	20	PK
GovtorMangt	Govt/Mangt	Varchar	20
AdmissionorReg Fees	Admission/Reg Fees	Int	20
TutionFees	Tution Fees	Int	15
CautionDeposite	Caution Deposite	Int	30
MatriculFees	Matriculation Fees	Int	20
SportsAffilFees	Sports Affil Fees	Int	15
StudentFund	Student Fund	Int	25
Univafilfee	Univafil fee	Int	20

Column name	Col_description	Data Type	Width	Constraints
TechAssoFees	Technical Association Fees	Int	30
IDCard	ID Card	Int	20
Total	Total	Int	15

CREATE TABLE STUDENT.DETAILS

(

Fname varchar(20),

lname  varchar(50),

address  varchar(50),

mname  varchar(80),

AdmNumber  int,

PhNumber  int,

YearofAdmission  int,

Branch varchar(50),

Gender varchar(50),

BloodGroup varchar(30),

Govt/Mangt varchar(50),

PFName varchar(50),

PMName varchar(50),

PLName varchar(50),

ContactNumbe  int,

UnivNumber varchar(50),

Date varchar(50)

);

CREATE TABLE STUDENT.FEEINFO

(

Yearofadmission Int,

GovtorMangt varchar,

TutionFees int,

CautionDeposite int,

MatriculFees int,

SportsAffilFees int

StudentFund int,

Univafilfee int,

TechAssoFees int,

IDCard int,

Total int,

);

INSERTINTOSTUDENT.DETAILS

                                VALUES

                                (

‘Rahul’,

                                ‘Raj’,

                                ‘Calicut’,

                                1901,

                                ‘E S’,

                                9037214325,

                                ‘2007’,

                                ‘Computer Science’,

                                ‘Male’,

                                ‘O+ve’,

 ‘Management’,

 ‘Rajendran’,

 ‘N’,

 ‘P’,

 ‘9995589924’,

 ‘21.02.90’,

 ‘Semester 7’,

’19.07.2010’

);

INSERTINTOSTUDENT.FEEINFO

            VALUES

                                (

2007,

                                ‘Management’,

                                100,

                                50000,

                                16000,

                                100,

                                100,

                                100,

                                50,

                                50,

                             66500

                                );

UPDATE STUDENT.DETAILS

SET

universityregnum= ‘CTAHECS033’

;

FROM STUDENT.DETAILS

FName  LName    Address  Adm Number M Name PhNumber  YearofAdm  Branch Gender 

Rahul     raj          Calicut    1901                     R             9994           2007         CS       Male Reshma raphel    Eranak        2081                  T             2321           2007         CS      Female

BloodGroup     Govt/Mangt      PFName     PMName  PLName  ContactNo  UnivNo          O+                    MGT               Rajendran         P                N              9847     CTAHECS033 O+                    GOVT             RAPHEL         K                 L              2334     CTAHECS037

SELECT * FROM DETAILS WHERE ADMISSIONNUM=’1901’;

FName  LName    Address  Adm Number M Name PhNumber  YearofAdm  Branch Gender 

Rahul  raj          Calicut      1901                     R             9994         2007          CS    Male

BloodGroup     Govt/Mangt      PFName     PMName  PLName  ContactNo  UnivNo          O+                    MGT               Rajendran         P                N              9847     CTAHECS033 SELECT * FROM FEEINFO WHERE YEAROFADMISION=2007

Yearofadmission    GovtorMangt    TutionFees    Caution Deposite  Matri Fees  SportsAffilFees

   2007                           Management 50000                    16000                    100                         100

StudentFund    Univafilfee      TechAssoFees   IDCard        Total

  100                           100                       50                             50                       66500