ca project

7/29/2019 CA Project

http://slidepdf.com/reader/full/ca-project 1/60

1

1. INTRODUCTION



2

INTRODUCTION:-

This is a project work undertaken in context of partial fullfillment of Neha

Singh,Radhika Gupta and Divesh Dabur. We have tried our best to make the

complicated process of EMPLOYEE DATABASE MANAGEMENTSYSTEM as simple as possible using Front – End and Back – End both.

MICROSOFT VISUAL BASIC 6.0 (Front – End)

MICROSOFT – ACCESS (Back – End)

We have tried to design the software in such a way that user may not have

any difficulty in using this application and further expension is possible

without much efforts.

Employee’s activity in computerised way rather than manually which is time

consuming. We are confident that this software can be readily used by non-

programming personal avoiding humun handled chance of error. This

application is used by two types of users:

Administrator (manager)

Employees of the organisation

Administrator must be an authorized user who can further change thepassword and username. Administrator can change the details used In

database like employee’s informations , department of employees , salary of

employees etc.

Employees can not have authorities to change the username, password, and

details stored in database. They can only view the details and use this

application for genral calculations.

The main aim of the entier activity is to automated the process of day to day

activities of an organisation. The Employee Database Management System ismade efficiently and user friendly.

Problem of proposed system:-

Failure of an existing system.

Inefficiency of an existing system.

Structural error in the existing system etc.



3

For identifying problems/opportunities, we scan following:-

The performance of the system.

The information being supplied ant its form.

The economy of processing.

The control of the information processing.

The efficiency of the existing system.

The security of the data and software.

The security of the equipment and personnel, etc.

FUNCTIONS PERFORMED BY SYSTEM:-

Manage the recordes of all employees.

Registration of new employee.

View recordes of all employees.

View recordes of employee according to their department.

Search the employee’s recordes by their EMP number.

View the salary of employees.

Increase the salary of employees.

Decrease the salary of employee. Total number of employess in the organisation.

Total number of employees in each departments.

FEATURES OF THE SYSTEM:-

System connectivity.

No data duplication.

No paper work required.

Time efficiency.

Cost efficiency.

Automatic data validation.

User-friendly environment.

Data security and reliability.

Fast data insertion and retrieval.

Easy performance check.

Use of graphics.



4

2. Objective of System



5

OBJECTIVES OF THE SYSTEM:-

A computer-based management system is designed to handle all the

primary informations.

Separate database is maintained to handle all these details requried for

the correct statements calculations/corrections.

This application intends to introduce more user-friendliness in the

various activities such as records updation, maintenance, searching and,

deletion.

The searching of recordes has been made quite simple as all the details

of employees can be obtained by unique employees number.

Similarly, record maintenance and updation are also so easy.

The detailsof employees are also being automatically updated in the

database thus keeping the records absolutely up to date.

The system is more user-friendly.



6

3. Project Categories,Tool

And Environment



7

Front-End and Back-End:-

MICROSOFT VISUAL BASIC 6.0 (Front – End):-

Visual programming enables visual development of graphical user

interfaces, easy to use and easy to learn. One of the principal

advantages is that the programmer need not write code to display the

required component. The visual programming environment displays a

list of available component, the programmer pick up the required

component from the list. The component can be moved resized and

even deleted if so required. There is no restriction in the number of

controls that can be placed.

MICROSOFT – ACCESS (Back – End):-

It is developed for the smaller organisation that have to store limited

data so MS access is the best suited for it. It is possible to define

relationship between tables as will be seen once defined these

relationship between tables are also stored in the database. It is

possible to define validation at the field as well table level this ensureaccuracy of data being stored. We also used query, report, sorting etc.

Hardware Requirement:-

Intel core - i3 Processor or above.

Colour Monitor.

Keyboard.

Mouse.

32 MB RAM or above.

Software Requirement:-

Microsoft window 7.

Microsoft Visual Basic 6.0.

Microsoft – Access 3 or 7.



8

4. Software Development

Life Cycle.



9

Waterfall Model:-

Problem

analysis

Need of

proposeds stem

Feasibility

study

System

Analysis

System

Design/coding

Integration

& Testing

Operation &

maintenance



10

1. Problem Analysis:-

Problem of Reliability:- Current system is not reliable. It seems to

vary in quality and results from one month to the next. Sometimes it

gives good output, but sometimes the output is worst.

Problem of Accuracy:- There are too many mistakes in reports and

calculations.

Problem of Timeliness:- In the current system the reports and output

produced is mostly late and in most of the cases it is useless because it

is not on time.

Problem of Validity:- The output and reports mostly contains

misleading information. The transactions and calculations are

sometimes not valid.

Problem of Economy:- The current system is very costly. We have to

spend lots of money in manual filing, calculations and remembering the

information, but still not get desired results.

Problem of capacity:- The current system is suffering from problem of

capacity also. The workload is too much. Few peoples cannot handle all

the working.



11

2. Need of Proposed System:-

Employees Details:- The New Proposed system and maintain the

entire employees details automatically and accurately. It remembers all

the records and can immediately produces the required reports at any

time without any errors.

Organisation Details:- The new proposed system stores and maintains

the organisation details also. It remembers all the record of organisation

and can immediately produces the require reports at any time without

any errors.

Calculations:- The new proposed system easily calculates the salary

employees and it is very fast and accurate.

Registration:- There is no need of keeping and maintaining employees

registration manually. It remembers each and every record and we can

get report related to employees at any time.

Speed: The new proposed system is very fast with 100% accuracy an

saves time.

Manpower: The new proposed system need less manpower. Less

people can do the work.



12

3. Feasibility study:-

Steps in feasibility analysis:-

Form a Project team and appoint a project leader.

Prepare system flows charts.

Enumerate potential proposed systems.

Define and identify characteristics of proposed system.

Determine and evaluate performance and cost effectiveness of each

proposed system.

Weight system performance and cost data.

Select the best proposed system.

Prepare and report final project directive to management.

Type of Feasibilities:-

Economic Feasibility:

Economic analysis is the most frequently used technique for evaluating

taw effectiveness of a proposed system. More commonly known as cost

and benefit analysis, in this procedure we determine the benefits and

savings that are expected from a proposed system and compare them

with costs. We found the benefits outweigh the costs. We take a

decision to design and implement the new proposed system.

Technical Feasibility:

This is concerns with specifying equipment and software that will

successfully satisfy the user requirement. The technical needs of the

system vary considerably, but include:

The facility to produce outputs in a given time.

Response time under certain conditions.

Ability to process a certain volume of transaction at a particular

speed.

Facility to communicate data to distant location.



13

After examining technical feasibly, we give more importance to the

configuration of the system than the actual make of hardware. The

configuration gives the complete picture about the system’s

requirements: Ten to twelve workstations are required. These should be

interconnected through LAN so that they could operate and

communicate smoothly. They should have enough speeds of inputs and

output to achieve a particular quality of printing.

Operational Feasibility:

It is mainly related to human organizational and political aspects. the

points to be considered are:

What Changes will be brought with the system?

What Organizational structures are disturbed?

What new skills will be required? Do the existing staff members

have these skills?

If not, can they be trained in due course of time?

Generally project will not be rejected simply because of operational

infeasibility but such considerations are likely to critically affect the

nature and scope of the eventual recommendations. For operational

feasibility study we appointed a small group of people who are familiar

with information system techniques, who understands the parts of the

business that are relevant to the project and are skilled in system

analysis and design process.

Legal feasibility:

Legal feasibility is a determination of whether a proposed project

infringes on known Acts, Statutes, as well as any pending legislation.

Although in some instances the project might appear sound, on closer

investigation it may be found to infringe on several legal areas.



14

4. System Analysis:-

The decision to acquire computer hardware or software must be

handled in the same way as any other business decision. The variety of

sizes and types of computing resources available puts a burden on the

analyst who must select suitable hardware, software or services and

advise the top management-accordingly.

SOFTWARE REQUIREMENTS SPECIFICATION:-

User Requirements of the New System:

The system shall provide easy storage retrieval and access of employee

information.

The system shall offer security to stored employee data through use of

passwords to control data access

The system shall have a user-friendly interface.

The system is expected to give results in a reasonable small time

interval.

The system shall accept, update, deletion and alteration of data.

Functional Requirements of the Proposed System:

The system should be able to provide the required figures of the

employee at any time.

The system ought to have ability to produce employee reports that

managers can apply in decision-making process.

The system should be able to accept data from users through use of

interface and interactive forms.

The system should be able to provide all the above efficiently and fast

enough.

The system will validate input data.



15

Non functional requirements:-

The system should be easy to maintain and adapt to by users.

The system should provide security to the database by use of

passwords.

Hardware Requirement:-

Intel core - i3 Processor or above.

Colour Monitor.

Keyboard.

Mouse. 32 MB RAM or above.

Software Requirement:-

Microsoft window 7.

Microsoft Visual Basic 6.0.

Microsoft – Access 3 or 7.



16

ENTITY RELATIONSHIP DIAGRAM:-

The entity relationship diagram depicts relationship between data objects. The

attributes of each data object noted in the entity relationship diagram.

Data object:- Data object encapsulates data only there is no reference within

a data object to operations that act on the data.

Relationship:- Data objects are connected to one another in a variety of

different ways. It can be define as a set of object relationship pairs that define

the relevant relationship.

Symbols used:-

ENTITY

RELATIONSHIP

DATA FLOW

ATTRIBUTES



17

ENTITY RELATIONSHIP DIAGRAM:-

DEPARTEMENT

DEPT NAMEDEPT NO. IT

FINANCE

MARKETING

HAS

NAME

MOBILE

NO.

EMP

NO.

E MAIL

AGE

SALARYGENDER

MARITAL

STATUS

EXPERIENCE

EMPLOYEE

IS A



18

DATA FLOW DIAGRAM(0 LEVEL):-

ADD NEW EMPLOYEES , ADD, DELETE, UPDATE,

PRINT & VIEW DETAILS CHANGE PASSWORD

VIEW DETAILS

EDBMS EDBMS

MANAGER STORE ACCESS ADMINISTRATOR

PRINT & VIEW DETAILS OF EMPLOYEE RECEIVE EMPLOYEE DETAILS

EMPLOYEE

DATABASEMANAGEMENT

SYSTEM

MANAGER

LOGIN

ADMINISTRATION

LOGIN



19

Data Flow Diagrams:-

Graphical representation of a system’s data and how the data processes

transform the data is known as Data Flow Diagram (DFD).

Data Flow Diagram shows how the data moves through the one entity or

process to another one, and where data stores, and it is used.

Symbols used:-

FUNCTIONS

PROCESS/SYSTEM

ENTITY

DATA FLOW

DATABASE



20

DATA FLOW DIAGRAM (1 LEVEL):-

ADMINISTRATOR AND

ALL MANAGERS CAN PRINT REPORTS

LOGIN

VIEW REPORTS

VIEW AND PRINT STORE DATA

ACCESS DATA

ONLY ADMINISTRATOR

CAN LOGIN

EMPLOYEE

DATABASE

MANAGEMENT

SYSTEMDATABASE

MANAGERS/ADMINISTRATOR

LOGIN

LOGIN

REGISTRATION

OF EMPLOYEES

EMPLOYEE’S

DETAILS

REPORTS

REGISTRATION

OF EMPLOYEES

MODIFYRECORDES

DELETERECORDES

REPORTS

ADMINISTRATOR



21

5. System Design:-

Major System Design Activities:

Several development activities a carried out during structured design.

They are database design, implementation planning, system test

preparation, system interface specification, and user documentation.

Data base design: This activity deals with the design of the physical

data base. A key is to determine how the access paths art to be

implemented.

Program design: In conjunctions with data base design is a decision

on the programming language to be used and the flowcharting, coding,

and debugging procedures prior to conversion. The operating system

limits the programming languages that will run of the system.

System and program test preparation: Each aspects of the system

have a separate test requirements. System testing is done after all

programming and testing completed. The test cases cover every aspect

of the proposed system, actual operations, and user interface and so on.

System and program test requirements become a part of design

specification- a pre requisite to implementation.

.



22

CONNECTIVITY TO ADODC:-



23



24



25

SPLASH FORM

LOGIN FORM:-



26

MAIN FORM(MDI FROM):-

REGISTRATION FROM:-



27

DETAILS OF EMPLOYEES:-

DETAILS OF ALL EMPLOYEES:-



28

SELECT DEPARTMENTS OF EMPLOYEES:-

DETAILS OF EMPLOYEES OF IT DEPARTMENTS:-



29

DETAILS OF EMPLOYEES OF FINANCE DEPARTMENT:-

DETAILS OF EMPLOYEES OF MARKETING

DEPARTMENT:-



30

SALARY OF EMPLOYEES:-

VIEW SALARY OF EMPLOYEES:-



31

LOGIN TO CHANGE SALARY OF EMPLOYEES:-

CHANGE SALARY OF EMPLOYEES:-



32

EXTRAS:-

CALCULATOR



33

PRINT:-

CHANGE BACKGROUND COLOR:-



34

COADING:-

SPLASH FORM:-

Private Sub Frame1_Click()

Unload Me

frmLogin.Show

End Sub

Private Sub Timer1_Timer()

If (Image1.Left <= 6480) Then

Image1.Left = Image1.Left + 100

Else

Image1.Left = 0

frmLogin.Show

Unload Me

End If

End Sub

Private Sub Timer2_Timer()

If (imgLogo.Top <= 1200) Then

imgLogo.Top = imgLogo.Top + 50

End If

End Sub



35

LOGIN FORM:-

Dim Aman As ADODB.Connection

Dim Chhadi As ADODB.Recordset

Dim flag As Integer

Private Sub cmdCancel_Click()

If MsgBox("are you sure you want to exit", vbYesNo) = vbYes Then

End

Else

Load Me

txtUserName = ""

txtPassword = ""

End If

End Sub

Private Sub cmdOK_Click()

Chhadi.MOVEFIRST

If txtUserName = Chhadi![UserName] And txtPassword = Chhadi![Password] Then

MDIForm1.Show

txtUserName = ""

txtPassword = ""

Else

flag = flag + 1

If flag = 1 Then

MsgBox ("Enter valid Username/Password, otherwise system will be crupted after 2

times")



36

txtPassword = ""

txtUserName = ""

txtUserName.SetFocus

ElseIf flag = 2 Then

MsgBox ("Enter valid Username/Password, otherwise system wii be crupted after 1

times")

txtPassword = ""

txtUserName = ""

txtUserName.SetFocus

Else

flag = 3

MsgBox ("you entered wrong username/password, system is going to close")

End

End If

End If

End Sub

Private Sub Command1_Click()

Form1.Show

End Sub

Private Sub Form_Load()

flag = 0

Set Aman = New ADODB.Connection

Aman.Open "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=EMPDATA.mdb;"

Set Chhadi = New ADODB.Recordset

Chhadi.Open " select * from [loginvb]", Aman, adOpenStatic, adLockOptimistic

End Sub



37

MDI FORM:-

Private Sub ABOUT_Click()

Form4.Show

End Sub

Private Sub all_Click(Index As Integer)

Form3.Show

End Sub

Private Sub CALCULATOR_Click()

Dim a

a = Shell("calc.exe")

End Sub

Private Sub Change_Click()

frmLogin2.Show

End Sub

Private Sub COLOR_Click()

CommonDialog1.ShowColor

If MsgBox("Are you sure you want to chance color?", vbYesNo) = vbYes Then

Form11.BackColor = CommonDialog1.COLOR








38







MsgBox ("your forms color have been changed")

Else

MsgBox ("No changes")

End If

End Sub

Private Sub Current_Click()

Form9.Show

End Sub

Private Sub Department_Click()

Form6.Show

End Sub

Private Sub editdelete_Click()

frmLogin1.Show

End Sub

Private Sub EXIT_Click()

If MsgBox("Are you sure you want to EXIT?", vbYesNo) = vbYes Then

Unload Me

End If

End Sub



39

Private Sub MDIForm_Unload(Cancel As Integer)

frmLogin.Show

End Sub

Private Sub MonthView1_DateClick(ByVal DateClicked As Date)

MonthView1.Visible = False

End Sub

Private Sub New_Click()

Form2.Show

End Sub

Private Sub Personal_Click()

Form8.Show

End Sub

Private Sub PRINT_Click()

CommonDialog1.ShowPrinter

End Sub

REGISTRATION FORM:-


Dim a


End Sub



40


If Text1.Text = "" Then

MsgBox ("ENTER YPUR EMP NO.")

ElseIf Text2.Text = "" Then

MsgBox ("ENTER YOUR NAME")

ElseIf Combo3 = "" Then

MsgBox ("SELCT YOUR GENDER")


MsgBox ("ENTER YOUR ADDRESS")


MsgBox ("SELECT YOUR AGE")


MsgBox ("ENTER YOUR E-MAIL")


MsgBox ("ENTER YOUR QUALIFICATION")


MsgBox ("SELECT YOUR MARITAL STATUS")


MsgBox ("SELECT YOUR EXPERIENCE")


MsgBox ("SELECT YOUR DEPARTMENT")


MsgBox ("ENTER YOU SALARY")


MsgBox ("ENTER YOU MOBILE NO.")

ElseIf Text7.Text Like "##########" <> True Then

MsgBox ("Please enter only 10 digits.")



41

Else

MsgBox ("WELCOME NOW YOU ARE THE MEMBER OF ORGANISATION")

Adodc1.Recordset.Update

End If

End Sub


Text1.Text = ""

Text2.Text = ""

Text3.Text = ""

Text4.Text = ""

Text5.Text = ""

Text6.Text = ""

Combo1 = ""

Combo2 = ""

Combo3 = ""

Combo4 = ""

Combo5 = ""

Combo6 = ""

End Sub


Unload Me

End Sub



42



Unload Me

End If

End Sub


Adodc1.Recordset.AddNew

End Sub

Private Sub Form_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As

Single)

If Button = vbRightButton Then

PopupMenu EXTRAS, vbPopupMenuRightButton

End If

End Sub



End Sub



End Sub



43

Private Sub REFRESH_Click()

Form2.REFRESH

End Sub

Private Sub Text7_KeyPress(KeyAscii As Integer)

If KeyAscii = Asc("0") Or KeyAscii = Asc("1") Or KeyAscii = Asc("2") Or KeyAscii =

Asc("3") Or KeyAscii = Asc("4") Or KeyAscii = Asc("5") Or KeyAscii = Asc("6") Or

KeyAscii = Asc("7") Or KeyAscii = Asc("8") Or KeyAscii = Asc("9") Or KeyAscii = 8

Then

Else

KeyAscii = 0

End If

End Sub

DETAILS OF ALL EMPLOYEES:-


Dim a


End Sub



Unload Me

End If

End Sub


Form3.PREVIOUS = False

Form3.MOVEFIRST = False

End Sub



44


Single)



End If

End Sub



End Sub

Private Sub MOVEFIRST_Click()

Adodc1.Recordset.MOVEFIRST



Form3.NEXT = True

Form3.MOVELAST = True

End Sub

Private Sub MOVELAST_Click()

Adodc1.Recordset.MOVELAST

Form3.MOVELAST = False

Form3.PREVIOUS = True

Form3.NEXT = False

Form3.MOVEFIRST = True

End Sub



45

Private Sub NEXT_Click()

Adodc1.Recordset.MoveNext

If Adodc1.Recordset.EOF Then

MsgBox ("NO MORE RECORDS IN DATABASE")

Form3.NEXT = False

End If



End Sub

Private Sub PREVIOUS_Click()

Adodc1.Recordset.MovePrevious

If Adodc1.Recordset.BOF = True Then

MsgBox ("NO EARLIER RECORDES")


End If

Form3.NEXT = True


End Sub



End Sub


Form3.REFRESH

End Sub



46

SELECT DEPARTMENT:-



End Sub


If Combo1 = "IT" Then

Form7.Show

ElseIf Combo1 = "FINANCE" Then

Form12.Show

ElseIf Combo1 = "MARKETING" Then

Form13.Show

Else

MsgBox ("Please select The department")

End If

End Sub



Unload Me

End If

End Sub


Single)




47


End If

End Sub



End Sub



End Sub


Form6.REFRESH

End Sub

DETAILS OF ALL EMPLOYEES OF IT/FINANCE/MARKETING

DEPARTMENT:-


Dim a


End Sub



Unload Me

End If

End Sub



48




End Sub

Private Sub Form_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)



End If

End Sub





Form7.NEXT = True


End Sub





Form7.NEXT = False


End Sub



49





Form7.NEXT = False

End If



End Sub






End If

Form7.NEXT = True


End Sub



End Sub


Form7.REFRESH

End Sub



50

SALARY OF EMPLOYEES:-


Dim a


End Sub


Text1.Text = Val(Text1.Text) + Val(Text2.Text)

Text2.Text = ""

End Sub


Text1.Text = Val(Text1.Text) - Val(Text2.Text)

Text2.Text = ""

End Sub


Adodc1.Recordset.Update

MsgBox ("SALARY IS UPDATED")

End Sub



Unload Me

End If

End Sub



51




End Sub

Private Sub Form_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)



End If

End Sub



End Sub





Form11.NEXT = True


End Sub





Form11.NEXT = False


End Sub



52





Form11.NEXT = False

End If



End Sub






End If

Form11.NEXT = True


End Sub



End Sub


Form11.REFRESH

End Sub



53

6. Integration and testing:-

During system testing, the system is used experimentally to ensure that the

software does not fail. Specific test data are input for processing, and the

results examined. It is desirable to discover any surprises before theorganization implements the system and depends on it. The different modules

are tested independently and then combined together and then tested.

Testing Objectives:

Testing is a process of executing a program with the intent of finding

an error

A good test case is one that has a high probability of finding an as yet

undiscovered error.

A successful test is one that uncovers an as yet undiscovered error.

Error:

It refers to the discrepancy between a computed, observed, or measured

value and true, specified or theoretically correct value i.e. it refers to

the difference between the actual output of the software and the correctvalue.

Fault:

It is a condition that causes a system to fail in performing its required

function. A fault is the basic reason for software malfunction and is

synonymous with the commonly used term bug.

Failure:It is the inability of a system or component to perform a required

function according to its specification. A Software Failure occurs if the

behavior of the software is different from the specified behavior. Faults

have the potential to cause failures and their presence is a necessary but

not sufficient condition for failure to occur.



54

Black Box Testing:

When we know the specified function that a product has been designed to

perform, tests can be conducted that demonstrate each function is fully

operational while at the same time searching for errors in each function. Ablack box test examines some fundamental aspect of a system with little

regard for the internal logical structure of the software.

Black box testing also called behavioral testing, focuses on the functional

requirements of the software. Black box testing attempts to find errors in the

following categories:

a) Incorrect or missing functions.

b) Interface errors.c) Errors in data structures or external database access.

d) Behavior or performance errors.

e) Initialization and termination errors.

White Box Testing:

When we know the internal workings of a product, tests can be conducted to

ensure that internal operations are performed according to specifications andall internal components have been adequately exercised. This testing is

sometimes called as glass box testing. Using white box testing methods, the

software engineer can derive test cases that

Guarantee that all independent paths within a module have been

exercised at least once

Exercise all logical decisions on their true and false sides

Execute all loops at their boundaries and within their operationalbounds

Exercise internal data structures to ensure their validity



55

Boundary Value Analysis:

For reasons that are not completely clear, a greater number of errors tend to

occur at the boundaries of the input domain rather than in the ‘centre’. It is for

this reason that boundary value analysis has been developed as a testingtechnique. Boundary value analysis leads to a selection of test cases that

exercise bounding Values. We used this approach to test several control

statements in our project.

Guidelines for boundary value analysis are as follows:

If an input condition specifies a range bounded by values a and b, test

cases should be designed with values a and b and just above and just

below a and b. If an input condition specifies a number of values, test cases should be

developed that exercise the minimum and maximum numbers. Values

just above and below minimum and maximum are also tested.

Apply the same guidelines to output conditions.

Boundary Value Analysis In case Of Mobile Number:

Values Result Description999999999 Invalid As it is less than 10 Digit

Number

1000000001 Valid As it is 10 Digit Number

9999999999 Valid As it is 10 Digit Number

10000000001 Invalid As it is More than 10 Digit

Number



56

7. OPERATION AND MAINTENANCE:-

Operations:-

Running of the system successfully depend on the personnel working in the

computer. They are responsible for providing the necessary support. Their

training must ensure that they are able to handle all possible operations,

routine and extra- ordinary in nature. Operators training should include such

fundamentals as how to turn the equipment on and use it, how to power off

and knowledge of what constitutes normal operation. The operators should

also be trained on different type of malfunctioning, how to recognize them

and what steps should be taken whenever they arise. As part of their training,operators should be given both a troubleshooting list that identifies possible

problems and remedies for them, as well as the names and telephone numbers

of individuals to contact when unexpected or unusual problem arise.

Training also involves familiarization with run procedures, which involves

working through the sequence of activities needed to use a new system on an

ongoing basis.

Maintenance:-

The software has been developed on the waterfall model and has been

vigorously tested under different situations there is very little need of

maintenance during the operation of the project. If the company wants to

upgrade their Platform then certain compatibility issued will be checked and

if passed then installation will be done and if fails than a complete new

software will be developed with the consultation of the company and if itwants new features it will be added if feasible under fresh terms and

condition.



57

5. Conclusion and futureWork:-



58

Scope of Future Application:

This project can be used in the organisation after adding some moreuseful modules in the project for which management is providing

services. Utmost care and back-up procedures must be established to

ensure 100% successful implementation of the computerized employee

database management system. In case of system failure, the

organization should be in a position to process the transaction with

another organization or if the worst comes to the worst, it should be in a

position to complete it manually.

Scope of Improvement:

Now a day’s organisations are providing many other facilities, this

project can also be improved with the improvement in the

organisations. Utmost care and back-up procedures must be established

to ensure 100% successful implementation of the computerized

banking system. In case of system failure, the organization should be in

a position to process the transaction with another organization or if theworst comes to the worst, it should be in a position to complete it

manually.

CONCLUSION:

This project is designed to meet the requirements of Employee

Database Management System. Servest keeping in mind thespecifications of the system. For designing the system we have used

simple data flow diagrams. Overall the project teaches us the essential

skills like: Using system analysis and design techniques like data flow

diagram in designing the system and understanding the database

handling and query processing.



59

6. Bibliography



BIBLIOGRAPHY

Books

1. Computer Application-I, Windows Programming Using Visual

Basic by Anuradha Agrawal

2. Visual Basic 6 Black Book by Steven Holzner

Websites

1. http://www.Youtube.com

2. http://www.Wikipedia.com

3. http://www.Google.com

ca project

Documents