A Project Report

On

“ CareerMella ”
For

Alpha Software Solution, India.

www.alphasoftwaresolution.com
 INDEX

Sr.No. Chapter Name Page No.

Index 1
1 INTRODUCTION 2
1.1 Company profile 3
1.2 Existing System 4
1.3 Need For System 4
1.4 Scope of Work 4
1.5 Operating Environment 5
2 PROPOSED SYSTEM
2.1 Proposed System 6
2.2 Objective of System 6
2.3 User requirements 7
3 ANALYSIS AND DESIGN
3.1 ER-Diagram 9
3.2 Use Case Diagram 10-13
3.3 Activity Diagram 14-17
3.4 Sequence Diagram 18-22
3.5 Class Diagram 23-24
3.6 Component Diagram 25
3.7 Deployment Diagram 26
3.8 Database Design 27-3
4 TESTING
4.1 Test Procedure & Test Plan 35
4.2 Test Case 36-39
5 User Manual 40-42
6 Drawback and Limitations 43
7 Proposed Enhancement 43
8 Conclusion 44
9 Bibliography 45
10 Annexure- I and II
10.1 Inputs Screen 46-55
11.2 Reports 56
 COMPANY INTRODUCTION

ALPHA Software Solution was founded with a passion for challenging

and redefining the 'boundaries of the possible'. For 11 years, Alpha Software
Solution has been innovating technology-based business solutions that
build trust by enabling our clients to cultivate growth streamline operations
and achieve objectives. We tailor our flexible and collaborative solutions to
meet the specific needs of our clients in Healthcare, Utilities, Federal
Government, IT & Software, Education, Manufacturing, Banking, and other
industries.

We offer software consulting and development services on platforms such as

.Net, ASP, Visual Basic, C#, Oracle, PHP, SQL-Server, DB2, SAS, Crystal
Reports, Business Objects, Cognos, SAP-BW, MSRS, Data warehouse &
Business intelligence applications, GIS etc. We help our clients in custom
application development including database, GUI, reporting and business
intelligence using various technologies. We work on areas including
architecture, design, development, administration, implementation,
maintenance.

In ALPHA Software Solution we encourage open culture, giving our staff

freedom to share innovative ideas and suggestions for improvement. We
believe in a healthy and progressive culture, which includes transparency,
discipline, team spirit, methodical working, sincerity, commitment and an
open-minded approach to any challenge.

Our Mission:-

Be a leader in providing knowledge based niche services for IT and Business

Process Outsourcing to customers worldwide.

Our Vision:-

Alpha Software towards adding value to clients, employees, and partners to

attain continued success.
 EXISTING SYSTEM AND NEED OF PROPOSED SYSTEM

1 Existing System:

 Existing system manages bridge between job provider and

job seeker using consultancy.
 This consultancy doing this task as manually, which is very
difficult task.
 They should go to collages to find job seekers and they
collect resume and provide to job provider.
 Job seeker also goes to consultancy office for searching job.
 Job provider also goes to consultancy office for finding
candidate for required place and for advertisement also.
 Job provider gives their advertisement in newspaper.

2 Need Of Proposed System:

This site is acting as middle men connecting Job Seeker and Job Provider.
This is a free site for Job Seeker. Job Seeker can log on to this site and
search for job, if job seeker is not member of this site, he can register on this
site and upload his resume. Job seeker can search job and apply also. In
this site, there are three types of user i.e. Job Seeker, Job Provider,
Advertiser. Job Seeker user search desired job by keywords, Exp, Locations
and Job Provider post his jobs with keywords, work exp, locations and he
can also search resume

He can log on to site and search for a Job, apply for a Job and can also
register his resume. This project is a business to Consumer, E-Commerce
web site.

Second feature of this project is that it is a B2C E- Commerce site which

means that online money transactions is taking place between Consumer
and Business house.

This is an on line Job web site on which can log in and can register him and
can search for jobs. Title of this project is “CareerMella” .Objective of this
project is complete automation and globalization of placements process.
 OPERATING ENVIRONMENT

HARDWARE AND SOFTWARE REQUIRMENTS:

HARDWARE USED:

CPU : PENTIUM BASED

RAM : 512 MB
HARD DISK: 20 GB
Internet connection LAN Card

SOFTWARE USED:

OPERATING SYSTEM: windows XP

RDBMS: SQL server2005
DEVELOPING TECHNOLOGY: .net, java script, Ajax
FRONT END: Asp.net
SERVER : IIS
Microsoft Framework
Flash application
 PROJECT DESCRIPTION

a) Objective Of System:

Objective of doing this project is to enhance my knowledge in the field of E-

commerce. Technology using .Net .Some of the client requirement and
objectives of this site is as under:

 To increase the business of Client

 To make Globally Registration.
 To facilities job search
 To facilitate company so that it can search for best candidates
available
 To help candidates to fetch a right job
 To act as a middle men connecting Job seeker and provider
 User can search for different options available
 User can do online resume posting etc
 User can search engine to look for different vacancies ,facilities
available etc
 User can do apply for job on-line
 To increase bank transactions
 User can down load different forms etc

b) Scope Of System:

 It has the features of providing all the information online(through the

net) .About vacancy and About the Job seeker
 The job site is a special purpose web site as discussed above it is not a
portal
 The site includes the search engine and advance search engine which
gives the user easy way to find the Vacancy and eligible candidate for
a post
 The site also includes the electronic mail facility for the users who
have registered themselves
 This site act as a middle ware for the Job Seeker and Job Provider
 The site has the facility to inform the Seeker and Company about the
job and candidate
 This site provides extra facility of calendar to provide information
about walk through interviews.
 c) User Requirement:

Interactive user interfaces so that any technical or non technical

user can use the proposed system.

1 Multiple Profile Creation facility

2 Proper security mechanism for admin ,job seeker and provider
3 Maintaining huge amount of data in database.
4 Data integrity.
5 Data consistency
6 Fast searching according to requirement
7 Advance search Facility
8 Provide standard resume format
9 interviews via Web Cam

Main Modules: The whole system is divided into different module:-

1 Job Seeker
2 Employer
3 Resume Writing
4 Administration
5 Calendar (appointment, reminder)
6 Advertisement
7 Send Message, Email
8 Chatting
System Analysis
&
Design
ER DIAGRAM:
Use Case for Resume Writer:
Admin sequence:
Employer:
Jobseeker:
Resume Writer:
Advertiser Sequence:
Employer Activity:
Jobseeker activity:
Resume writer:
Advertiser activity:
Class Diagram
 Advertisement
Admin Advertiser
Areaid
User name Manage AreaCost Post AdvertiserId
user id AreaWidth UserName
password 1.. m Area Height m 1 Password
Add() Add() Add()
update() 1 update() update()
delete() delete() delete()
1 1
Add

Add
Subscribe
Package
m
m PackageId
PackageName
ResumeWriter PackageType
PackageAmount
ResumeWriterID
PackageDuration
userName
password Add()
update()
update() delete()
1
1
AdvertiserPackage
ResumePackage
PackageTypeId
EmployerPackage PackageID
PackageTypeId Add()
Service PackageID Update()
Add() PackageTypeId update()
Update() PackageID
update() Add()
Update()
Subscribe
update()
1 1
1
m Subscribe
Employer

Jobseeker
1 WalkIn UserID
UserName
UserId
Password
UserName 1 view m WalkId
Role
Password UserId
Add()
Role WalkinTitle Update()
Add()
Add()
Update()
m 1 Delete()
Update()
update() update() Add
1 1
1 1
post View

Apply m JobPost m

JobPostId
UserId Calender
JobName
Date
1
Add() Appointment
Update() Reminder
View Delete() Add()
Update()
1 update()
COMPONENT DIAGRAM
DEPLOYMENT DIAGRAM
MODULE HIERARCHY DIAGRAM
 DATABASE TABLE SPECIFICATION

CM_User_Account_Master:

COLUMN NAME DATA TYPE SIZE CONSTRINTS

User_Id Int 30 Primary key
User_Name nvarchar 256 Not null
Password nvarchar 256 Not null
Email_Id Int 30 Not null
Role_Id Int 30 Foreign Key

CM_JobSeeker_Master:

COLUMN NAME DATATYPE SIZE CONSTRAINTS

JobSeeker_Id Int 30 Primary key
Name nvarchar 256 Not null
Gender char 2 Not null
Address nvarchar 256 Not null
Pin_Code Int 10 Not null
STD_code Int 30 Not null
Phonenumber Int 15
Mobile_Nnumbe nvarchar 16
r
User_Id Int 30 Foreign key
Country_Id Int 30 Foreign key
State_Id Int 30 Foreign key
City_Id Int 30 Foreign key

CM_Job_ Seeker_Professional_Master:

COLUMN NAME DATA TYPE SIZE CONSTRAINTS

JSProfessional_Id Int 30 Primary Key
JobSeeker_Id Int 30 Foreign key
Company_Id Int 30 Foreign Key
Industry_Id Int 30 Foreign key
FunctonalArea_I Int 30 Foreign key
d
KeySkill_Id Int 30 Foreign Key
Start_Month DateTime
Start_Year DateTime
End_Month DateTime
End_Year DateTime
Total_Exp nvarchar 30 Not null
Annual_Salary nvarchar 50 Not null

CM_Jobseeker Education_Detail:

COLUMN NAME DATATYPE SIZE CONSTRAINTS

JobSeeker_id Int 30 Foreign key
DegreeType _Id Int 30 Foreign key
Degree_Id Int 30 Foreign key
Specialization_Id Int 30 Foreign key
Institute_Id Int 30 Foreign key
Passing_Year nvarchar 50 Not null
Marks Float 30 Not null
Grade nvarchar 30 Not null

CM_Jobseeker_ Keyskill:

COLUMN NAME DATA TYPE SIZE CONSTRAINTS

KeySkill_Id Int 30 Primary Key
KeySkill_Name Nvarchar 30 Not null
Experience nvarchar 50 Not null
LastUserMonth nvarchar 50 Not null
LastUserYear nvarchar 50 Not null
Proficiency nvarchar 256 Not null

CM_Employer_Detail:

COLUMN NAME DATA TYPE SIZE CONSTRAINT

Employer_Id Primary Key
Contact_Person nvarchar 50 Not null
Company_Profile nvarchar 50 Not null
Address nvarchar 50 Not null
Code nvarchar 50 Not null
ISD_Code nvarchar 50 Not null
Std_Code nvarchar 50 Not null
Phone_Number nvarchar 50 Not null
Mobile_Number nvarchar 50 Not null
User_Id Int 30 Foreign key
Company_id Int 30 Foreign key
Country_ Id Int 30 Foreign key
State_Id Int 30 Foreign key
City_Id Int 30 Foreign key

CM_Job Postdetail:

COLUMN NAME DATATYPE SIZE CONSTRAINTS

Job_Id Int 30 Primary key
Job_Title nvarchar 256 Not null
Qualification nvarchar 50 Not null
Min_Exp nvarchar 50 Not null
Max _Exp nvarchar 50 Not null
Job_Summary nvarchar 50 Not null
Contact_Person nvarchar 50 Not null
Email_Id Int 50 Not null
Job_Posting_Date nvarchar 50 Not null
Status nvarchar 50 Not null
Employer_Id Int 30 Foreign Key
Country_ Id Int 30 Foreign key
State_Id Int 30 Foreign key
City_Id Int 30 Foreign key
Company_Id Int 256 Foreign key
FunctionalArea_Id Int 30 Foreign key
Keyskill_Id Int 30 Foreign key

CM_Jobseeker Resume Detail:

COLUMN NAME DATATYPE SIZE CONSTRAINTS

User_Id Int 30 Foreign key
Resume_Title nvarchar 256 Not null
Created_Resume_Dat nvarchar 50 Not null
e

CM_WalKIn:

COLUMN NAME DATA TYPE SIZE CONSTRINTS

Walk_Id Int 30 Primary key
User_Id Int 30 Foreign key
Walkin_Title nvarchar 256 Not null
Walkin_Description nvarchar 256
Date nvarchar 50 Not null
Time nvarchar 50 Not null
Venue nvarchar 256
Contact_Number nvarchar 50
Contact_EmailId nvarchar 256
Company_Url nvarchar 256
Status nvarchar 1

CM_Appointment:

COLUMN NAME DATA TYPE SIZE CONSTRINTS

Appointment_Id Int 30 Primary key
User_Id Int 30 Foreign key
Appointment_Titl nvarchar 256 Not null
e
Description nvarchar 256
Date nvarchar 50 Not null
Time nvarchar 50 Not null
Address nvarchar 256
Employer_Id Int Foreign Key
CM_AdvertiseArea Master:

COLUMN NAME DATA TYPE SIZE CONSTRINTS

Area_Id Int 30 Primary key
Area_Page nvarchar 256 Not null
Area_Description nvarchar 256 Not null
Area_Cost nvarchar 256 Not null
Area_Height nvarchar 50 Not null
Area_Width nvarchar 50 Not null

CM_AdvertiseHitCount:

COLUMN NAME DATA TYPE SIZE CONSTRINTS

Advertise_Id Int 30 Primary key
Counter Int 30 Not null
Summary nvarchar Max Not null
Date DateTime

CM_Feedback:

COLUMN NAME DATA TYPE SIZE CONSTRAINTS

Feedback_Id Int 30 Primary Key
Feedback_By_Nam nvarchar 256 Not null
e
Subject nvarchar 256 Not null
Message nvarchar 256 Not null
Sent_Date DateTime - Not null
Status nvarchar 9 Not null

CM_List_Packages:

COLUMN NAME DATA TYPE SIZE CONSTRAINTS

PackageId Int 30 Primary key
PackageType_Id Int 30 Foreign key
Package_Name nvarchar 256 Not null
Package_Amount nvarchar 25 Not null
Package_Duration nvarchar 25 Not null
Package_Created_Dat Date time 256 Not null
e
Status
Description

CM_Package_Type:

COLUMN NAME DATA TYPE SIZE CONSTRAINTS

Package_Type_Id Int 30 Primary key
Package_Type_Nam nvarchar 256 Not null
e

CM_ Job Seeker _Job Apply:

COLUMN NAME DATA TYPE SIZE CONSTRAINTS

User_Id Int 30 Foreign key
Job_Id Int 30 Foreign key
Apply_Date nvarchar 30 Not null

CM_Role_Master:

COLUMN NAME DATATYPE SIZE CONSTRAINTS

Role_Id Int 30 Foreign key
Role_Name nvarchar 256 Not null
Created_Resume_Dat nvarchar 50 Not null
e

CM_List_Country_Master:
COLUMN NAME DATA TYPE SIZE CONSTRINTS
Country_Id Int 20 Primary key
Country_Name Nvarchar 256 Not null

CM_List_State_Master:

COLUMN NAME DATA TYPE SIZE CONSTRAINTS

State_Id Int 30 Primary key
State_Name nvarchar 256 Not null
Country_Id nvarchar 256 Foreign key

CM_list_City_Master:

Column name Data type Size Constraints

City_Id Int 30 Primary key
City_Name nvarchar 256 Not null
State_Id Int 30 Foreign key

CM_Industry_Type_Master:
COLUMN NAME DATATYPE SIZE CONSTRAINTS
Industry_id Int 30 Primary key
Industry_Name nvarchar 256 Not null

CM_List_FunctionalArea_Master:

COLUMN NAME DATA TYPE SIZE CONSTRAINTS

FunctionalArea_Id Int 30 Primary key
FunctionalArea_Name nvarchar 256 Not null

CM_ List_Company_Master:

COLUMN NAME DATA TYPE SIZE CONSTRAINTS

Company_Id Int 30 Primary key
Company_Name nvarchar 256 Not null
Company_Logo nvarchar 50 Not null
Created_Date DateTime Not null

CM_List_Specialization_Master:

COLUMN NAME DATA SIZE CONSTRAINTS

TYPE
Specialization_Id Int 30 Primary key
Specialization_Name nvarchar 256 Not null

CM_List_ Degree_Master:

COLUMN NAME DATA TYPE SIZE CONSTRAINTS

Degree__Id Int 30 Primary key
Degree_ Name nvarchar 256 Not null
Degree_Type_Id Int 30 Foreign key
Institude_Id Int 30 Foreign Key
Specialization_Id INT 30 Foreign Key

CM_DegreeType_Master:

COLUMN NAME DATA TYPE SIZE CONSTRAINTS

DegreeType _Id Int 30 Primary key
DegreeType _ Name nvarchar 256 Not null

CM_ResumeWriter:

COLUMN NAME DATA TYPE SIZE CONSTRAINTS

ResumeWriter_Id Int 30 Primary Key
Use_Id Int 30 Foreign key
Resumewriter_Nam nvarchar 30 Not null
e
City_Id Int 30 Foreign key
State_Id Int 30 Foreign key
MobileNumber Nvarchar 30 Not Null
PhoneNumber Nvarchar 30 Not Null
Created_Date DateTime Notnull
Updated_Date DateTime Notnull

CM_Advertiser:

COLUMN NAME DATA TYPE SIZE CONSTRAINTS

Advertiser_Id Int 30 Primary Key
Use_Id Int 30 Foreign Key
Advertiser_Name nvarchar 30 Notnull
Company_Name nvarchar 30 Not Null
City_Id Int 30 Foreign Key
State_Id Int 30 Foreign Key
Mobile_Number Nvarchar 30 Not Null
Phone_Number Nvarchar 30 Not Null
Created_Date DateTime Not Null
Updated_Date DateTime Not Null

CM_PackageSubscription:

COLUMN NAME DATA TYPE SIZE CONSTRAINTS

S_No Int 30 PrimaryKey
User_Id Int 30 Foreign Key
Package_Id Int 30 ForeignKey
Package_Category nvarchar 50 Not Null
Subscribe_Date DateTime Not Null
Modify_Date DateTime Not Null
CM_ PaymentGateway:

COLUMN NAME DATA TYPE SIZE CONSTRAINTS

Id Int 30 Primary Key
Merchant_Name Int 256 Not Null
Merchant_Id Int 50 Not Null
Store_Id Int 30 Not Null
Date DateTime Not Null

CM_ Transactioninfo:

COLUMN NAME DATA TYPE SIZE CONSTRAINTS

Id Int 30 Primary Key
User_Id Int 30 Foreign Key
Transaction_Number Int 50 Not Null
Amount Int 10 Not Null
Barcode_Number Int 10 Not Null
Card_Type nvarchar 20 Not Null
DateOf_Transaction DateTime Not NUll

CM_ Message:

COLUMN NAME DATA TYPE SIZE CONSTRAINTS

Msg_Id Int 30 Primary Key
To_msg nvarchar 30 Not Null
From nvarchar 30 Not Null
Subject nvarchar 30 Not Null
Msg_Body nvarchar max Not Null
Date DateTime Not Null

CM_JobSeekerExperience:

COLUMN NAME DATA TYPE SIZE CONSTRAINTS

User_Id Int 30 Foreign Key
Company_Name nvarchar 256 Notnull
Designation nvarchar 256
Start_Month nvarchar 10
Start_Year nvarchar 10
End_Month nvarchar 10
End_Year nvarchar 10
Created_Date DateTime Notnull
Updated_Date DateTime Notnull

CM_JobSkillSet:

COLUMN NAME DATA TYPE SIZE CONSTRAINTS

SkillSet_Id Int 30 Primary Key
KeySkill_Id Int 30 Foreign Key
Status Bit Notnull

CM_ListLevel:

COLUMN NAME DATA TYPE SIZE CONSTRAINTS

Level_Id Int 30 Primary Key
Level_Name Nvarchar 256 Not Null
Created_Date DateTime Not Null
Updated_Date DateTime Not Null

CM_ListLanguage:

COLUMN NAME DATA TYPE SIZE CONSTRAINTS

Language_Id Int 30 Primary Key
Language_Name nvarchar 256 Not Null
Created_Date DateTime Not Null
Updated_Date Datetime Not Null
CM_ListCollege:

COLUMN NAME DATA TYPE SIZE CONSTRAINTS

College_Id Int 30 Primary Key
College_Name nvarchar 256 Not Null
Created_Date DateTime Not Null
Updated_Date DateTime Not Null

CM_Reminder:

COLUMN NAME DATA TYPE SIZE CONSTRAINTS

Reminder_Id Int 30 Primary Key
User_Id Int 30 Foreign Key
Subject Nvarchar 256
Description Nvarchar 256
Date DateTime Not Null
Created date DateTime Not Null
Updated date DateTime Not Null

CM_PackageCategory:

COLUMN NAME DATA TYPE SIZE CONSTRAINTS

Package_Category_Id Int 30 Primary Key
Package_Category_Nam Nvarchar 256 Not Null
e
Created_Date DateTime Not Null
Updated_Date Datetime Not Null
CM_ResumeHitCount:

COLUMN NAME DATA TYPE SIZE CONSTRINTS

jobseeker_Id Int 30 Primary key
Counter Int 30 Not Null
Date Datetime Not Null

CM_Advertiser:

COLUMN NAME DATA TYPE SIZE CONSTRINTS

Advertiser_Id Int Primary Key
Advertiser_Name nvarchar 30 Allow Null
Advertiser_Address nvarchar 50 Allow Null
Login_Id Int Allow Null
City_Id nvarchar 10 Allow Null
Mobile_No nvarchar 15 Not Null
Email nvarchar 15 Allow Null
Company_Name nvarchar 30 Allow Null
Created_Date DateTime Not Null
Modify_Date DateTime Not Null
Status Bit Not Null

CM_AdvertiseChange:

COLUMN NAME DATA TYPE SIZE CONSTRAINTS

Advertisement_Change_Id Int 30 Primary Key
Advertisement_Id Int 30 Allow Null
New_Banner nvarchar 512 Allow Null
 Change_Date DateTime Not Null
Created_Date DateTime Not Null
Modify_Date DateTime Not Null
Status Bit Not Null

CMpostadvertise:

COLUMN NAME DATA TYPE SIZE CONSSTRAINTS

Advertisement_Id Int 10 Primary Key
AdvertiserId Int 10 Allow Null
PackageId Int 10 Allow Null
Area_Id Int 10 Allow Null
Advertisement_Banner nvarchar 512 Not Null
Target_Url nvarchar 50 Not Null
Start_Date DateTime Not Null
End_Date DateTime Not Null
Hit_Counter Int 10 Allow Null
Created _Date DateTime Not Null
Modified _Date DateTime Not Null
Status Bit Not Null

CM_AdvertisementPayment:

COLUMN NAME DATA TYPE SIZE CONSTRAINTS

Advertisement_Id Int 10 Allow Null
Payment_Id Int 10 Not Null
Pyment_Status Bit Not Null
Created_Date DateTime Not Null
Modified Date DateTime Not Null
Status Bit Not Null

CM_Messagemaster

COLUMN NAME DATA TYPE SIZE CONSTRAINTS

 Id Int 10 Allow Null
Provider_Name nvarchar 256 Not Null
Merchant_Account Int Not Null
No_Of_Sms Int Not Null
Date_Of_Subscription DateTime Not Null
Expire_Date DateTime Not Null

CM_MessageCounter

COLUMN NAME DATA TYPE SIZE CONSTRAINTS

Message_Id Int 10 Not Null
Member_Id Int Not Null
Sms_Limit Int Not Null
Sms_Sent Int Not Null
Date_Of_Activation DateTime Not Null
Expire_Date DateTime Not Null

CM_MessagePackage

COLUMN NAME DATA TYPE SIZE CONSTRAINTS

Package_Id Int 10 Not Null
Package_Name nvarchar 256 Not Null
Amount Int Not Null
Duration Int Not Null
No_Of_Sms Int Not Null

CM_MessageRenewal

COLUMN NAME DATA TYPE SIZE CONSTRAINTS

Renewel_Detail nvarchar 256 Not Null
Package_Id Int Not Null
Member_Id Int Not Null
Date Int Not Null
CM_Message_Details:

COLUMN NAME DATA TYPE SIZE CONSTRAINTS

Message_Detail_Id Int 10 Not Null
Member_Id Int Not Null
Message nvarchar Not Null
Mobile_To Int Not Null
Date DateTime Not Null
Status Bit Not Null

CM_Email_Details:

COLUMN NAME DATA TYPE SIZE CONSTRAINTS

Email_Id Int 10 Primary Key
User_Id Int Foreign Key
Message_To nvarchar Not Null
Subject Int Not Null
Body nvarchar Not Null
Sent_Time DateTime Not Null
Sent_Date DateTime Not Null
USER MANUAL
 HOME PAGE

ADD COUNTRY

ADD WALKIN:

VIEW ALL WALKINS:

UPDATE COUNTRY:

EMPLOYER LOGIN:

JOB POST SUMMARY:

POST ADVERTISEMENT:

ADVERTISE CHANGE: