Table of Contens
Table of Contens
Table of Contens
1
OBJECTIVES
The project was initially formally discussed among us and later designed in VB 6.0.
The project's back end is Microsoft Access. The program, as the name suggests is a
“Job Consultancy” maintains records in the organization.
2. Concentrate on Accuracy
2
INTRODUCTION TO PROJECT
This project “Job Consultancy” use the concept of database file to maintain the
various transaction and activities of a Job Counseling Centers, i.e. applicant’s personal and
educational record, job profile record of company, placement record of the applicant for Job
Counseling Centers.
This project gives the detail of applicant/company from which the job counseling
centers. It also maintains the records of all applicant and companies who are regular with the
jobs requirements and choosing their career for bright future.
This project also gives the detail of all applicants with their education detail and their
job requirements date by date and also company details with their recruitment.
With project information crept in many doubts regarding the project's database, front-
end, etc. We started thinking about Ms-Access's database as our Back-end and Visual Basic
6.0 as our Front-end. But soon we realized that it wouldn’t be portable from one machine to
other. Now what?
One whole day just passed thinking on this topic. We figured out many ways to
backup the data and add portability to it, but all in vein...
3
CHAPTER 2
Theoretical Background of Project
4
SCOPE OF THE PROJECT
The scope of this module is to study and develop a computerized Job Counseling
Center for Raipur.
The proposed projects of Job Consultancy function are given below:-
Applicant’s Record
Education Record
Company Detail
Job Profile of the Company
Job Placement Record
Date wise report of the candidate
Placement List
Report
List
5
CHAPTER 3
Definition of Problem
6
PROBLEMS ENCOUNTERED
While developing the software, we faced many major and minor problems. Initially,
we were not able to connect the database to the front end and faced some problems related to
the connectivity and the consistency of the database. Then it was very difficult to print the
REPORT, as a required printer driver was not available. Similarly we could not manipulate
the Report Page size.
During deployment, Project didn't work as expected, which helped us to figure out
that program can't be ported to client's machine without setup file as the program was running
fine on our machine but we were unable to run it on the client's machine in absence of
appropriate runtime DLLs (Dynamic Link Libraries). The most exasperating problem was to
print the form thus making it impossible for us to work further.
We took the help of all the possible people we could ask them for, and with their
assistance we came out in triumph
7
FUTURE ENHANCEMENTS
8
CHAPTER 4
System Analysis And Design
9
SYSTEM ANALYSIS
System Analysis
examine of a business situation with the intent of improving it through better procedure and
method. It is the process of gathering and method. It is process gathering and interpreting
facts.
system. Analysis is used gained and understanding of the conclusion of the system there is a
system description and as set of requirement for a new system. It there is on existing system,
then the analysis only defines the requirement. The step, which follows, will propose a new
The new system may be built a fresh or by changing the existing system. Development being
Analysis objective
An efficient system analysis always plays the role of strong foundation for
development of any proposed system. Information play key role, as the horizon of knowledge
keep on expending, since this project is anaphor to convert the manual in to computer based
system, a through knowledge of the day-to-day functions of present system of mandatory the
Feasibility Study
Feasibility is the determination of whether or not a project is worth doing. The
process followed in making this decision is called feasibility study. It determines whether a
project should be taken or not. Various types of feasibility were studied, like:
10
Technical feasibility
This is concerned with specifying equipment and the software that successfully
satisfies the user requirements. In examining the technical feasibility, the configuration of the
Operational feasibility
It is mainly related to the human organizational and political aspects. It involved the
study of the changes to be through in the system, new skills needed etc. In the present manual
system there is no use of computer and also the operational staff has no idea about the
operation of the computer system, hence an introductory training of the staff is needed.
Economic feasibility
It is the most frequently used technique for the evaluation of the effectiveness of the
proposed system. It involves the cost/benefit analysis. This study has outweighed the manual
Social feasibility
It is the determination of whether a system will by the user or not. This examines the
Management feasibility
It is to determine whether the proposed system will be acceptable to the management
or not.
Time feasibility
It is a determination of whether the proposed system can be implemented fully within
Fact Finding
Fact-finding means learning about the existing system as much as possible. The
system. It is one of the most difficult techniques. It requires intrusion into the user’s area and
11
can cause adverse reaction by the users if not handled properly. The user should not be able
to know that he is being observed else he might behave in a different manner. We had to be
very careful in doing the on-site observation though the users are co-operative or reluctant. A
lot of information about the system was gathered by observing the existing system at work.
various reports, procedure and practices of the, Raipur (C.G.). After studying these
documents we got the various requirements of the system which helped us to determine to
what extent were the requirements being met by the present system.
and came to grip with the entire scope of the problem. After the fact-finding, the system
These were then put forward to the management and the user. After the approval from
12
CHAPTER 5
Hardware And Software Requirement
13
SOFTWARE REQUIREMENT SPECIFICATION
Introduction
Job Counseling Center is an application program for assisting any Job counseling
center owner in managing a membership of the applicants and job vacancy detail of the
company’s requirement.
1. Purpose: automate the manual system
2. Scope of the Project: project/system deals with new membership detail, education
records, job profile record of the company, job placement record, and future scope,
various reports and lists.
Goals & Purpose
The departmental stores would have the following goals :
- Provide a GUI for job counseling center to interface with the backend record of detail
database.
- Screens to add/update new membership entry for the job requirements database
- Screens to add/update new member/job profile information in the database.
- Screen to search for any member by center as per educational qualification of the
candidates.
- Job Placement and interviews records of the candidates.
- Job Placement Report/Vacancy Report of the various companies date by date
systematically.
General description
1. Functionality and capabilities
(a) Complete system is GUI i.e. menu driven
(b) Generates any kind of report
(c) Member wise report
(d) Database has no limit
2. User characteristics: administrator has all rights for updating, deletion and
modification.
14
3. Information flow:
Applicant Requirement Company Profile Job Placement Entry Payment /
Receipt Entry reports
4. General constraints
(a) Database will be update every year
(b) No automatic backup facilities
(c) No facility of online reports
Functional requirements
Requirement:1
Description:- Maintain the product detail
1.1 Each record should have the following attributes-
applicant id no.
applicant name
birth date.
Category
education
job requirement
Each product id no. is unique for each product.
1.4Delete the item
Applicant record would be delete by applicant id no. If there is no requirement of
item and out of manfg_date.
1.5we can see stock list for maintained product.
Requirement:2
Description: - Maintain the details of supplier.
2.1 each distributor should have following attributes:
Member id no.
member_ name
address
city
company
job profile
15
salary package
16
SOFTWARE & HARDWARE REQUIREMENT
Software requirment :-
17
CHAPTER 6
Plate Form Specification
18
Introduction to Windows XP
An Operating System (OS) dictates how all the parts (software and hardware resources) of your
computer work together and how specific tasks (i.e., displaying and saving information) are to be
performed.
Windows XP is built primarily on Windows 2000 technology which includes the best attributes
of previous Windows versions. People who already know and have used previous versions of
Windows should have no problems using Windows XP. One major difference will be in the
logging in and logging out procedures. Windows XP offers several benefits over other versions,
namely, its built-in file encryption and password control capabilities provide basic data and
access security, increased reliability and performance ability, friendly graphical user interface
(GUI), and its Web communication features. Windows XP's desktop is graphical which allows
the user to click on pictures (or icons) to launch applications, open files and folders, connect to a
Users should find that Windows XP is more efficient and customizable than previous versions
and other platforms. The Start button on the bottom left corner of the screen allows easy access
to just about everything in the system. The Start button is used to initiate applications, opens or
search for documents, adjusts settings, activates the Help Support system, manages files, and
The taskbar acts as a "home base" and has three elements: the Start button, a bar across the
bottom of the screen that lines up opened (active) applications side-by-side, and the system tray
located on the bottom right corner where the clock and other system icons may appear. The
19
taskbar is an efficient tool of keeping track of what applications are active, and allows for
Visual Basic is the most Popular Object Oriented event Driven Programming
language .It revolves around readymade objects, and it is event driven i.e. all the activities in a
program are triggered by one event or another .The main advantage of visual Programming
languages is that we can concentrate on what we want our program to do, not how to get the
2. Flexibility: It not only provides database access but can also be used to link it with
easy to learn and work with, its syntax seems to be more familiar.
4. Features: Various Additional Features Like ADO reports And other various type
development tool and it is often referred to as a Rapid Application Development (RAD) tool.
Another key concept of Visual Basic is the ability to create and use self contained
controls enable us to add feature to our programs without having to be involved in the details
20
This software is also designed using several controls available in Visual Basic
with the help of which interactive user interface screen can be developed. Form Controls are
used as containers for other controls like command buttons, labels, scroll bar, combo box etc.
Coding scheme of different controls is hidden from their appearance and this
About MS Access
This is a Backend Tool widely used for Personal Computer as a Data Base.
The relational database is a well-defined theoretical model of working with and managing a
Data Structure, Data integrity and Data manipulation .The MS Access has a
distinct component, which adheres to these requirements. The basic Data Structure in Access
The Data integrity rules of the relational models can be defined within Access
relationship using integrity constraints. When a table is created in Access the integrity rule is
MS Access has many important features that make it not only an exceptional
database Management System but also an excellent database for personal system in windows
environment,
21
The goal of the access is to help you get your work done in the least of time,
Microsoft Access offers a variety of features for different databases needs. It can be
1. Personal application.
3. Department application.
The term database means different things to different people. For many
years in the world of Dbase was used to describe a collection of fields and records in a
client/server environment. Dbase refers to all the data schema, indexes, rules, triggers and
stored procedures associated with a system in access terms, a dbase is a collection of all the
tables, queries, forms, reports, macros and modules that compose a complete system.
information is stored in tabular form one record shows all possible attributes of an
entity. In a simple word entity can be identified by its attributes like his name, color,
height and hairstyle etc identify a person. So in databases a record makes tuple while
22
CHAPTER 7
Data Flow Diagram
23
DATA FLOW DIAGRAMS
A data flow diagram is graphical tool used to describe and analyze movement of data
through a system. These are the central tool and the basis from which the other components
are developed. The transformation of data from input to output, through processed, may be
described logically and independently of physical components associated with the system.
These are known as the logical data flow diagrams. The physical data flow diagrams show
the actual implements and movement of data between people, departments and workstations.
A full description of a system actually consists of a set of data flow diagrams. Using two
familiar notations Yourdon, Gane and Sarson notation develops the data flow diagrams. Each
component in a DFD is labeled with a descriptive name. Process is further identified with a
number that will be used for identification purpose. The development of DFD’S is done in
several levels. Each process in lower level diagrams can be broken down into a more
detailed DFD in the next level. The lop-level diagram is often called context diagram. It
consists a single process bit, which plays vital role in studying the current system. The
process in the context level diagram is exploded into other process at the first level DFD.
The idea behind the explosion of a process into more process is that understanding at
one level of detail is exploded into greater detail at the next level. This is done until further
explosion is necessary and an adequate amount of detail is described for analyst to understand
the process.
Larry Constantine first developed the DFD as a way of expressing system
requirements in a graphical from, this lead to the modular design.
A DFD is also known as a “bubble Chart” has the purpose of clarifying system
requirements and identifying major transformations that will become programs in system
design. So it is the starting point of the design to the lowest level of detail. A DFD consists
of a series of bubbles joined by data flows in the system.
24
DFD SYMBOLS:
In the DFD, there are four symbols
1. A square defines a source(originator) or destination of system data
2. An arrow identifies data flow. It is the pipeline through which the information flows
3. A circle or a bubble represents a process that transforms incoming data flow into outgoing
data flows.
4. An open rectangle is a data store, data at rest or a temporary repository of data
Data flow
Data Store
25
DATA FLOW DIAGRAM
ply
Ap
Job
26
CHAPTER 8
E R Diagram
27
E-R diagrams constructs
In E-R diagrams, entity types are represented by squares. See the table below. Relationship
types are shown in diamond shaped boxes attached to the participating entity types with
straight lines. Attributes are shown in ovals, and each attribute is attached to its entity type or
relationship type by a straight line. Multivalued attributes are shown in double ovals. Key
attributes have their names underlined. Derived attributes are shown in dotted ovals.
Weak entity types are distinguished by being placed in double rectangles and by having their
relationship type. The participation constraint is specified by a single line for partial
participation and by double lines for total participation. The participation constraints specify
whether the existence of an entity depends on its being related to another entity via the
relationship type. If every entity of an entity set is related to some other entity set via a
relationship type, then the participation of the first entity type is total. If only few member of
an entity type is related to some entity type via a relationship type, the participation is partial.
ENTITY TYPE
RELATIONSHIP TYPE
ATTRIBUTE
28
KEY ATTRIBUTE
MULTIVALUED
ATTRIBUTE
DERIVED ATTRIBUTE
TOTAL PARTICIPATION OF
E2 IN R
Structural Constraint(Min,Max)
On Participation Of E In R
unique,
Contain the minimum number of words needed to uniquely and accurately describe
the object.
For entities and attributes, names are singular nouns while relationship names are typically
verbs.
29
ER-DIAGRAM
Employee
No.
Employee
No.
Admin
Id Admin Create Data Operator
Login
ID
percent
Manager
DA Date
Employee DA
No.
Sal
Word
Given Salary
Employee to Tot
Net Employee
sell No.
places
EPF Address
Ph.No. Designation
Basic
Employee
No.
Employee history
PF
Employee Employee
No. Name PF index
History
Net.
Sell
Designation
EPF Basic
30
31
CHAPTER 9
Data Base Design
32
DATA BASE TABLE
COURSE FILE
JOB PROFILE
Field’s Name Data Type
Company Text
Job Requirement Text
Vacancy Date Date
No Post number
Education Read Date
Last Date Date
Salary Currency
Address Text
City Post Text
Experience Text
33
MEMBER ENTRY
Field’s Name Data Type
Member ID No
Member Name Text
Birth Date Date
Gender Text
Nationality Text
Address1 Text
Address2 Text
City Text
Mobile No Number
Education Text
Experience Text
Father’s Name Text
Email ID Text
Field of Interest Text
34
CHAPTER 10
Input & Output Screen Design
35
MAIN FORM:
COMPANY JOB:
36
JOB PLACE ENTRY:
SEARCH APPLICANT:
37
PLACEMENT REPORT:
VACANCY REPORT:
38
MEMBER LIST:
39
CHAPTER 11
Coding
40
CODINGS OF PASSWORD PROGRAM
End If
End Sub
41
CODINGS OF MAIN MENU PROGRAM
Private Sub Command1_Click()
Form2.Show
End Sub
End Sub
End Sub
42
CODINGS OF NEW MEMBER ENTRY PROGRAM
Private Sub CMBAYEAR_LostFocus()
Dim D As String
D = CMBADAY.Text & "-" & CMBAMON.Text & "-" & CMBAYEAR.Text
Dim AD As Date
AD = CDate(D)
LBLAPDATE.Caption = Format(AD, "DD-MMM-YYYY")
End Sub
Dim AD As Date
AD = CDate(D)
LBLBDATE.Caption = Format(AD, "DD-MMM-YYYY")
End Sub
End Sub
End If
End Sub
43
Listyear.AddItem (txtyear)
Listper.AddItem (txtper)
End Sub
Adodc2.Recordset.Save
'STOCK UPDATED
Adodc2.Refresh
n=n+1
Loop
'EDUCATION UPDATE
Dim MN As String
MN = DataCombo1.Text
Adodc1.Refresh
Adodc1.Recordset.Find "MEMBERNO='" & MN & "'"
Adodc1.Recordset.Fields("EDUCATION") = CMBEDUCATION.Text
Adodc1.Recordset.Save
'EDUCATION UPDATED
End Sub
44
Private Sub Command6_Click()
Listexam.Clear
Listuniv.Clear
Listyear.Clear
Listper.Clear
End Sub
End Sub
TXTSTOCK = 1
End If
End Sub
Dim AD As Date
AD = CDate(D)
LBLVDATE.Caption = Format(AD, "DD-MMM-YYYY")
End Sub
Dim AD As Date
AD = CDate(D)
LBLLDATE.Caption = Format(AD, "DD-MMM-YYYY")
End Sub
45
Private Sub CMDSAVE_Click()
Adodc1.Recordset.Save
MsgBox "RECORD SAVE SUCCESSFULLY"
End Sub
End If
End Sub
46
CHAPTER 12
Conclusion
47
CONCLUSIONS
It was a wonderful and learning experience for us while working on this project. This
project took us through the various phases of project development and gave us real insight
into the world of software engineering. The joy of working as a team and the thrill involved
while tackling while tackling the various problems and adopting to the requirements put
forward to us by the customer, gave us a feel of the developers industry.
It was due to this project we came to know how professional software software’s are
designed and what precautions should be taken. We also found that it not just the task of an
individual, rather a team work, which helped us in making a firm grip on Visual Basic 6.0
The project has laid the path to the depth of the subject, that requires a thorough study
and in which an Engineering student have flair of proficiency. We have left no stone unturned
while developing this software and making it easy to understand, easy to navigate through the
forms and re-cycling.
We enjoyed each and every bit of work we have put into this project and its successful
completion has given us our credit
48
CHAPTER 13
Limitation and future Scope
49
LIMITATION AND FUTURE SCOPE
Every project has its own advantages and limitations so is our project also.
50
CHAPTER 14
Reference
51
BIBLIOGRAPHY
3. Mastering in VB
… Evangels Petroutsos
4. Software engineering
… BPB Publication
6. Software Engineering
… Jalote
52