[go: up one dir, main page]

0% found this document useful (0 votes)
30 views36 pages

Final Doc Both

The document describes a placement management system project. It includes sections on the problem statement, objectives, scope, requirements analysis, data dictionary, and entity relationship diagram. The project involves building a web-based system to manage student and company information as well as the placement process.

Uploaded by

surajthorat810
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
30 views36 pages

Final Doc Both

The document describes a placement management system project. It includes sections on the problem statement, objectives, scope, requirements analysis, data dictionary, and entity relationship diagram. The project involves building a web-based system to manage student and company information as well as the placement process.

Uploaded by

surajthorat810
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 36

A

PROJECT REPORT
ON

“Placement Management System”

Submitted By
Mr.Gavhane Vikas Navnath
Mr.Landge Tejas Dilip

Guided By

Mrs Deshmukh Mam

In partial fulfilment of the award of the degree


of
T.Y.B.Sc. (Computer Science)
of
Sangamner Nagarpalika Arts, D.J.Malpani Commerce & B.N Sarda
Science College(Autonomous), Sangamner
(Affiliated to Savitribai Phule Pune University)

DURING ACADEMIC YEAR

2023-2024
INDEX
Sr.No. Title
1. Acknowledgement.
2. Introduction
• Problem statement
• Objective of the System

3. Scope of the System

4. Implementation details
-Requirement Analysis

5. System Design
-Data Dictionary
-Entity Relationship Diagram
-system Model using OOSE

6. Coding
7. Input-Outputs Screens and Reports
8. Testing
9. Advantages and Future Enhancement
10. Bibliography and Reference
ACKNOWLEDGEMENT

A few words of gratitude to be inserted with project “PLACEMENT


MANAGEMENT SYSTEM”. It is our earnest duty to express our
thanks to all those who contributed directly or indirectly to our
project.
Firstly we would like to thank S. N. Arts, D. J. Malpani Commerce
& B. N. Sarada Science College(Autonomous College),
Sangamner and Department of Computer Science for giving us an
opportunity. Thanks to Prof. Laddha R. S. Vice Principal, Head of
Department for his encouragement and valuable guidance.
We would like to thank Miss.Talnikar H.V who initiated us to
complete this project and guided us timely. It’s our privilege to
express our gratitude to all staff members & non-Teaching Staff
members for their excellent suggestions and active co-ordination.
And last but not least, we would like to thank all our friends for their
support and the timely help.

Yours Sincerely,
Shete Chaitnya Sunil
Shelke Ganesh Jayram
(Computer Science)
ABSTRACT

• The project named “Placement Management System”, a


student/company information system is a web based System.
• In this project a large database se of student where in all the
Information of student including the personal records and the
academic performance in terms of student progress and company
information including profile of Company eligibility criteria and
facilities it provide etc.
• The job details of the placed student will be provide by
administrator. They provide approval of student registration and
updating.
• The system provide the facility of viewing both the personal and
acadamic information of the student and company.
• The users can easily to this and the date can be retrieve easily. In
the main page there are option for a new register student to directly
login using username and password, submit resume.
• It can also search for eligible student and Company and also
insertion and deletion of records by the administrator, Eligilible
student will recive an email or SMS on their register mobile in
which the date & time and location will be provide.
INTRODUCTION

Computer plays an important role in our daily life. Anything we want


we can get only in one mouse click. Speed, reliability and accuracy of
the computer make it a powerful tool for different purposes. A very
important and basic need of today’s modern business world is the
quick availability and processing of information using computer. One
can easily get the type of required information within a fraction of a
second.
In this project a large database se of student where in all the
Information of student including the personal records and the
academic performance in terms of student progress and company
information including profile of Company eligibility criteria and
facilities it provide etc.The job details of the placed student will be
provide by administrator. They provide approval of student
registration and updating.The system provide the facility of viewing
both the personal and acadamic information of the student and
company.The users can easily to this and the date can be retrieve
easily. In the main page there are option for a new register student to
directly login using username and password, submit resume.
It can also search for eligible student and Company and also insertion
and deletion of records by the administrator ,Eligilible student will
recieve an email or SMS on their register mobile in which the date &
time and location will be provide.
Problem Statement-
A placement management system typically refers to a software or
platform that helps organizations manage their recruitment and
placement process. The system usually includes features such as job
posting, resume management, applicant tracking, interview
scheduling, and analytics.
The scope of a placement management system can vary depending on
the organization's size, industry, and hiring needs. However, in
general, the system can streamline the recruitment process, reduce
administrative burdens, improve candidate experience, and help
organizations make data-driven hiring decisions.

Objective of the System-


The objective of placement management systems is to facilitate and
streamline the process of connecting job seekers with potential
employers, managing job openings, and matching candidates to
suitable job opportunities. The placement management system is
designed to automate various tasks involved in the recruitment
process, such as creating job postings, managing resumes, scheduling
interviews, and tracking the progress of job applicants. The system
aims to improve the efficiency and effectiveness of the recruitment
process by providing a centralized platform for employers and job
seekers to connect and communicate.
Scope of the System:-
A placement management system typically refers to a software or
platform that helps organizations manage their recruitment and
placement process. The system usually includes features such as job
posting, resume management, applicant tracking, interview
scheduling, and analytics.
The scope of a placement management system can vary depending on
the organization's size, industry, and hiring needs. However, in
general, the system can streamline the recruitment process, reduce
administrative burdens, improve candidate experience, and help
organizations make data-driven hiring decisions.
A placement management system can be useful for any organization
that frequently hires new employees or needs to manage a large
volume of applications. It can be especially beneficial for recruitment
agencies, human resources departments, and companies with high
employee turnover rates.
Overall, the scope of a placement management system is to simplify
and optimize the recruitment process, making it making it more
efficient and effective for the both employers and students.
Requirement Analysis:-

Under our project resources are categorized in two main types :-


• Hardware Resources
• Software Resource

Hardware Resources and Specification:-


• Processor : i5 processor
• RAM : 4GB
• Monitor :HP 15.6 Inches
• Hard Disk :512GB

Software Resources and Specification:-


• Operating System : Windows 10
• Text editor : Visual Studio
• Documentation: M.S Word
• Front End: HTML,CSS
• Back End: PHP,MYSQL
Data Dictionary:
Student table-

Sr.no Data Field Data Type Size Constraints


1 Stud_id Int 10 Primary key
2 Stud_Name Varchar 20 Not Null
3 Stud_Password Varchar 10 Not Null
4 Stud_Phone.no Int 10 Foreign key
5 Stud_Email Varchar 25 Not Null
6 Stud_Birthdate Varchar 20 Not Null
7 Stud_SSCmarks Varchar 10 Not Null
8 Stud_HSCmark Varchar 20 Not Null
9 Stud_Degree Varchar 30 Not Null
10 Stud_UGmarks Varchar 10 Not Null
11 Stud_PGmarks Varchar 10 Not Null

Admin table-
Sr.no Data Field Data Type Size Constraints
1 Admin_id int 20 Primary key
2 Admin_Password varchar 10 Not Null
3 Admin_email varchar 10 Not Null
4 Admin_phoneno Int 10 Foreign key
Company table-
Sr.no Data Field Data Type Size Contraints
1 Company_id int 10 Primary key
2 Company_Name varchar 40 Not Null
3 Company_phoneno Int 10 Foreign key
4 Company_Address varchar 20- Not Null
5 Company_description varchar 30 Not Null

Advertise table-
Sr.no Data Field Data Type Size Contraints
1 Adv_id Int 30 Primary key
2 Adv_Date Varchar 10 Not NulL
3 Company_id Int 50 Foreign key
4 Min_qualification Varchar 50 Not Null
5 Min_Experience Varchar 50 Not Null
6 SkillSet Varchar 50 Not Null
7 Last_date Varchar 50 Not Null
8 No_of_post Varchar 50 Not Null
9 Package_offered Varchar 50 Not Null
Response table-
Sr.no Data Feild Data Type Size Constraints
1 Response_id int 20 Primarykey
2 Adv_id int 30 Foreign key
3 Stud_id int 10 Foreign key
4 Date varchar 20 Not Null
ER-Diagram:-

M
1 MAN
ADMIN AGE COMPANY

REGI publis HAS


STE h
R

M
STUDENT RESP ADVERTISE
OND
Use Case Diagram :-

Registration

login

Apply for job


Student

Post job

Manage Account

Send Mail
Admin
Update Profile

Delete Profile

Company
Logout
Class Diagram :-

Admin Company
+Admin_id:int +Comp_id:int
+User-name:var +Comp_name:var
+Email:String * +Comp_add:var
+Pass:String +comp_Con.no:var
+Post_adv() +Post_job()
+Send_mail() +Send_mail()
+Manage_stud() +Update_profile()
+Manage_comp()
+Update_profile()

* *

Student Advertise
+Stud_id:int +Adv_id:int
+Stud-name:varchar +Adv-Date:varchar
+Stud_pass:String +Last_Date:String
+Stud_con.no:String * * +Comp_id:varchar
+Stud_Email:varchar
+Apply_job() +Add()
+Update_profile() +Update()
+Delete_profile () +Search()
Activity Diagram for user :-

User login & password

Chea
k
login
Invalid
valid

Register

Create profile

View Adv

Apply For Job

End
Activity Diagram for Admin:-

Start

login

Chea
ck
Invalid
login
Id/pa
ss

valid

Post_advertise

Update company deatail

Send mail

Update student deatail

End
Object diagram:-

A:Admin C:Company
+Admin_id:int +Comp_id:int
1 * +Comp_name:var
+User-name:var
+Email:String +Comp_add:var
+Pass:String +comp_Con.no:var
*

* *

S:Student A:Advertise
+Stud_id:int +Adv_id:int
+Stud-name:varchar * * +Adv-Date:varchar
+Stud_pass:String +Last_Date:String
+Stud_con.no:String +Comp_id:varchar
+Stud_Email:varchar
Component Diagram:-

Student.php

Registration.html
Placement
management
Database
system Current job.php

Company.html

Edu Details.php
Coding:-
Login.php
<?php
include "includes/header.php";

if(isset($_SESSION['admin'])){
header("Location: dashboard.php");
}
if(isset($_SESSION['name'])&&isset($_SESSION['email'])){
header("Location: profile.php");
}

$set_value = 0;
$error = '0';
if(isset($_REQUEST['email'])&&isset($_REQUEST['pass'])){
$email = trim($_REQUEST['email']);
$pass = trim($_REQUEST['pass']);
if($email=="admin@gmail.com"&&$pass=="admin"){
$_SESSION['admin'] = true;
header("Location: dashboard.php");
}
$pass = md5(trim($_REQUEST['pass']));
$sql = "SELECT *
FROM users
WHERE user_email='$email'
AND user_pass='$pass'";
$result = mysqli_query($con, $sql);
$num_rows = mysqli_num_rows($result);
if($num_rows>0){
$row = mysqli_fetch_array($result);
$_SESSION['id'] = $row['user_id'];
$_SESSION['name'] = $row['user_name'];
$_SESSION['email'] = $row['user_email'];
header("Location: home.php");
} else{
$set_value = 1;
$error = "Invalid Email or Password";
}
}
?>
<div class="col-md-9 main">
<!-- login-page -->
<div class="login">
<div class="login-grids">
<div class="col-md-6 log">
<h3 class="tittle" id = "signin">Sign In <i
class="glyphicon glyphicon-lock"></i></h3>
<p id="login_instructions" style="display:
block">Welcome, please enter the following to continue.</p>
<?php
if($set_value==1){
echo '<div id="error" style="display: block;">
<div class="alert alert-danger" role="alert"">
<i class="glyphicon glyphicon-lock"></i>
<strong>Error! : </strong> <span
id="error_message">'.$error.'</span>
</div>
</div>';
}
?>
<div id = "form-area" style="display: block">
<form id = "form" method="post"
action="login.php">
<h5>Email:</h5>
<input type="email" name="email" value=""
id="input-email" placeholder="Enter Your Email ID" required>
<h5>Password:</h5>
<input type="password" name="pass" value=""
id="input-pass" placeholder="Enter Your Password" required>
<input type="submit" value="Login" id="input-
submit" style="display: block">
</form>
<a href="#">Forgot Password ?</a>
</div>
</div>
<div class="col-md-6 login-right">
<h3 class="tittle">Why you should have to register with us
<i class="glyphicon glyphicon-file"></i></h3>
<p>By creating an account with our site, you will be able to
move through the recruitment process faster,
view and apply to various companies by yourself and
many more.</p>
<a href="registration.php" class="hvr-bounce-to-bottom
button">Create An Account</a>
</div>
<div class="clearfix"></div>
</div>
</div>
</div>
<!-- //login-page -->
<div class="clearfix"> </div>
<?php
include "includes/footer.php";
?>
Student.php
<?php
include "includes/header.php";
$set_value = 1;
$error = '0';
if(isset($_GET['id'])){
$id = trim($_GET['id']);
$sql = "SELECT *
FROM users,profile
WHERE user_id='$id' AND user_id=uid";
$result = mysqli_query($con, $sql);
$row = mysqli_fetch_array($result);

$name = $row['user_name'];
$email = $row['user_email'];

if($row['resume']=="")
$resume = 'dr.pdf';
else
$resume = $row['resume'];

if($row['profile_image']=="")
$profile_image = 'co.png';
else
$profile_image = $row['profile_image'];

if($row['mobile']=="")
$mobile = 'Incomplete profile';
else
$mobile = $row['mobile'];

if($row['dob']=="")
$dob = 'Incomplete profile';
else
$dob = $row['dob'];

if($row['ssc_marks']==0)
$ssc_marks = 'Incomplete profile';
else
$ssc_marks = $row['ssc_marks'];

if($row['hsc_marks']==0)
$hsc_marks = 'Incomplete profile';
else
$hsc_marks = $row['hsc_marks'];

if($row['graduation']=="")
$graduation = 'Incomplete profile';
else
$graduation = $row['graduation'];

if($row['graduation_discipline']=="")
$graduation_discipline = 'Incomplete profile';
else
$graduation_discipline = $row['graduation_discipline'];

if($row['graduation_marks']==0)
$graduation_marks = 'Incomplete profile';
else
$graduation_marks = $row['graduation_marks'];

if($row['post_graduation']=="")
$post_graduation = '-';
else
$post_graduation = $row['post_graduation'];

if($row['post_graduation_discipline']=="")
$post_graduation_discipline = '-';
else
$post_graduation_discipline =
$row['post_graduation_discipline'];

if($row['post_graduation_marks']==0)
$post_graduation_marks = '-';
else
$post_graduation_marks = $row['post_graduation_marks'];

if($row['gender']=="")
$gender = 'Incomplete profile';
else
$gender = $row['gender'];
}
?>
<div class="col-md-12 main" style="padding-top: 20px;">
<!-- login-page -->
<div class="col-md-3" >
<center>
<img src="image_uploads/<?php echo $profile_image; ?>"
width="150px" class="img-responsive" alt="profile-Image">
</center>
</div>
<div class="col-md-5">
<div class="outer">
<div class="middle">
<div class="inner">
<h1><?php echo $name; ?></h1>
<p><?php echo $email; ?></p>
<br>
<div class="col-md-6">
<h4><a href="resume_uploads/<?php echo
$resume; ?>" target="_blank"><u><i class="glyphicon glyphicon-
file"></i>View Resume</u></a></h4>
</div>
</div>
</div>
</div>
</div>
<div class="clearfix"></div>
</div>
<div class="col-md-12 main" style="padding-top: 20px;">
<div class="col-md-1">
</div>
<div class="col-md-8"">
<h4>Personal Detail</h4>
<style>
table {
border-collapse: collapse;
width: 100%;
}

th, td {
text-align: left;
padding: 8px;
}

tr:nth-child(even){background-color: #f2f2f2}

th {
background-color: rgba(18, 149, 201, 0.69);
color: white;
}
</style>
<table border="3px" width="100%">
<tr>
<th>Name</th>
<td><?php echo $name; ?></td>
</tr>
<tr>
<th>Email</th>
<td><?php echo $email; ?></td>
</tr>
<tr>
<th>Mobile No.</th>
<td><?php echo $mobile; ?></td>
</tr>
<tr>
<th>Date Of Birth</th>
<td><?php echo $dob; ?></td>
</tr>
<tr>
<th>Gender</th>
<td><?php echo $gender; ?></td>
</tr>
</table>
<br>
<h4>Educational Detail</h4>
<table border="3px" width="100%">
<tr>
<th>SSC marks</th>
<td><?php echo $ssc_marks; ?></td>
</tr>
<tr>
<th>HSC Marks</th>
<td><?php echo $hsc_marks; ?></td>
</tr>
<tr>
<th>Graduation</th>
<td><?php echo $graduation; ?></td>
</tr>
<tr>
<th>&nbsp&nbsp&nbsp&nbsp&nbspGraduation
Discipline</th>
<td><?php echo $graduation_discipline; ?></td>
</tr>
<tr>
<th>&nbsp&nbsp&nbsp&nbsp&nbspIn Graduation (% or
cgpa)</th>
<td><?php echo $graduation_marks; ?></td>
</tr>
<tr>
<th>Post Graduation (Optional)</th>
<td><?php echo $post_graduation; ?></td>
</tr>
<tr>
<th>&nbsp&nbsp&nbsp&nbsp&nbspPost Graduation
Discipline</th>
<td><?php echo $post_graduation_discipline; ?></td>
</tr>
<tr>
<th>&nbsp&nbsp&nbsp&nbsp&nbspIn Post Graduation
(% or cgpa)</th>
<td><?php echo $post_graduation_marks; ?></td>
</tr>
</table>
<br><br>
</div>
<div class="clearfix"></div>
<div class="col-md-1"></div>
<div class="col-md-10">
<h4>Companies that are enrolled</h4>
<?php
$sql = "SELECT * FROM company
WHERE company_id IN
(
SELECT company_id
FROM drive
WHERE drive_id IN
(
SELECT drive_id
FROM enrolled_students
WHERE user_id='$id'
)
)";
$result = mysqli_query($con, $sql);
while($row = mysqli_fetch_assoc($result)){
$id = $row['company_id'];
$name = $row['company_name'];
$branch = $row['company_branch'];
$url = $row['company_url'];
echo '
<div class="editor-pics">
<div class="col-md-10 item-details"
style="border: #14bcd5 solid 1px; padding: 10px">
<h4 class="inner two"><a
href="view_company.php?id='.$id.'">'.$name.'</a>
</h4>
<h5>&nbspBranch:
'.$branch.'&nbsp&nbsp&nbsp
<a href="http://'.$url.'"
target="_blank">'.$url.'</a>
</h5>
</div>
</div><br><br>
';
}
?>
</div>
<div class="col-md-1"></div>
<div class="clearfix"></div>
</div>
</div>
<!-- //login-page -->
<div class="clearfix"> </div>
Company.html:-
<?php

if(isset($_GET['name'])&&isset($_GET['branch'])&&isset($_GET['sa
lary'])&&isset($_GET['date'])) {
//Set the Content Type
header('Content-type: image/jpeg');

// Create Image From Existing File


$jpg_image = imagecreatefromjpeg("PA.jpg");

// Allocate A Color For The Text


$color = imagecolorallocate($jpg_image, 0, 0, 0);

// Set Path to Font File


$font_path = 'Adobe Caslon Pro Bold.ttf';

// Set Text to Be Printed On Image


$company = strtoupper($_GET['name']);
$branch = strtoupper($_GET['branch']);
$salary = strtoupper($_GET['salary']);
$date = strtoupper($_GET['date']);

// Print Text On Image


$result_img = imagettftext($jpg_image, 25, 0, 11, 70, $color,
$font_path, "COMPANY : $company");
$result_img = imagettftext($jpg_image, 20, 0, 11, 150, $color,
$font_path, "BRANCH : $branch");
$result_img = imagettftext($jpg_image, 20, 0, 11, 200, $color,
$font_path, "SALARY : $salary");
$result_img = imagettftext($jpg_image, 20, 0, 11, 250, $color,
$font_path, "DATE : $date");
// $result_img = imagettftext($jpg_image, 60, 0, 528 -
(7*(strlen($text)/2)), 500, $color, $font_path, $text);
// Send Image to Browser
imagejpeg($jpg_image);
// Clear Memory
imagedestroy($jpg_image);
return 0;

}
Input-Outputs Screens and Reports:-
1.login:-

2.Registration:-
3.Company Details:-

4.student details:-
5.logout:-
Testing-
System Testing
The goal of the system testing process was to determine all faults in
our project .The program was subjected to a set of test inputs and
many explanations were made and based on these explanations it will
be decided whether the program behaves as expected or not. Our
Project went through two levels of testing.
1. Unit testing
2. Integration testing
UNIT TESTING
• Unit testing is commenced when a unit has been created and
effectively reviewed .In order to test a single module we need to
provide a complete environment i.e. besides the section we would
require.
• The procedures belonging to other units that the unit under test
calls.
• Non local data structures that module accesses.
• A procedure to call the functions of the unit under test with
appropriate parameters.
1. Test for the admin module
• Testing admin login form-This form is used for log in of
administrator of the system. In this form we enter the username
and password if both are correct administration page will open
otherwise if any of data is wrong it will get redirected back to the
login page and again ask the details.
INTEGRATION TESTING
In the Integration testing we test various combination of the project
module by providing the input.
The primary objective is to test the module interfaces in order to
confirm that no errors are occurring when one module invokes the
other module.
Advantages:-
• Placement Management System manages student
information in the college with regards to placement.
• It has the facility of maintaining the details of the student
,there by reducing the manual work.
• It gives the accurate data details of student or company to
the user.
• The system provides less time consumption.
• The user can register & upload details easily.

Future Enhancement of the system:-


• In future we can add company directly with company
manger, and provide the given details.
• In future ,given details send automatically to company.
• I will collect the all educational details & provide to main
company.
Bibliography and reference:-

On-line resources –
https://www.w3resource.com
https://www.w3schools.com
http://php.net/
https://www.tutorialspoint.com
https://www.postgresql.org/
https://html.com/
https://www.javatpoint.com
Books:
1. Programming PHP By Rasmus Lerdorf and Kevin
Tatroe, O'Reilly publication
2. Beginning PHP 5 , Wrox publication
3. PHP web services, Wrox publication
4. AJAX Black Book, Kogent solution
5. Mastering PHP , BPB Publication
6. PHP cookbook, O'Reilly publication

You might also like