VISVESVARAYA TECHNOLOGICAL UNIVERSITY

a BELAGAVI-590 018, KARNATAKA

DBMS MINI PROJECT REPORT ON

SOCIAL MEDIA DATABASE MANAGEMENT SYSTEM

PROJECT ASSOCIATES
Nandeesh Reval 4BD19CS053

Prajwal Reddy B S 4BD19CS059

Prerana C P 4BD19CS063

PROJECT GUIDES
Prof. Shryavani K Prof. Vaishnavi Ajay Inamdar
Department of CS&E Department of CS&E
B.I.E.T, Davanagere. B.I.E.T, Davanagere.

Department of Computer Science and Engineering

Bapuji Institute of Engineering and Technology
Davanagere-577004
 Bapuji Institute of Engineering and Technology Davanagere-577004

Department of Computer Science and Engineering

CERTIFICATE
This is to certify that XXXXXXX and YYYYYYY bearing USN 4BDDDDDD and
4BDDDDDD respectively of Computer Science and Engineering department have
satisfactorily submitted the mini project report entitled “MANAGEMENT SYSTEM” for
DATABASE MANAGEMENT SYSTEM
LABORATORY (18CSL58). The report of the mini project has been approved as it satisfies
the academic requirements in respect of mini project work prescribed for the year 2021.
Project Guide

_
Prof. Shryavani K Prof. Vaishnavi Ajay Inamdar
Department of CS&E, Department of CS&E,
B.I.E.T, Davanagere. B.I.E.T, Davanagere.

Head of Department

Dr. Nirmala C R Ph.D.,

Prof. & Head, Department of
CS&E, B.I.E.T,
Davanagere.
Signature of Examiners:

Date: 1)
Place: Davanagere 2)
 ACKNOWLEDGEMENT
Salutations to our beloved and highly esteemed institute, “BAPUJI INSTITUTE OF
ENGINEERING AND TECHNOLOGY” for having well qualified staff and lab furnished with
necessary equipment’s.

We express our sincere thanks to our guides Prof. Shryavani K and Prof. Vaishnavi Ajay
Inamdar for giving us constant encouragement, support and valuable guidance throughout the
course of project without whose guidance this project would not have been achieved.

We express whole hearted gratitude to Dr. Nirmala C R, H.O.D of Computer Science and
Engineering Department. We wish to thank her for making our task easy by providing her
valuable help and encouragement.

We also express our whole hearted gratitude to our principal, Dr. H B ARAVIND for his moral
support and encouragement.

We would like to extend our gratitude to all staff of Computer Science and Engineering
Department for their help and support. Also, we have benefited a lot from the feedback,
suggestions given by them.

We would like to extend our gratitude to all my family members and friends especially for their
advice and moral support.
Vision
“To be centre of excellence recognized nationally and internationally, in distinctive areas of
engineering education and research, based on a culture of innovation and invention.”

Mission
“BIET contributes to the growth and development of its students by imparting a board- based
engineering education and empowering them to be successful in their chosen field by inculcating
in them positive approach, leadership qualities and ethical values.”

Vision and Mission of the Computer Science and Engineering Department

Vision
“To be a centre of excellence in imparting state-of-the-art technology in the field of
Computer Science and Engineering education enabling the students to become professionally
sound and ethically strong”.

Mission
1. Adapting best in class teaching and learning methodology to mould the students to
become industry ready.
2. Creating conductive environment for imparting quality education the facilitate research
and Innovation.
3. Establishing industry relationship to bridge the skill gap.
4. Educating the students to be successful lifelong learners by inculcating ethical values
and social responsibilities.
1. Program Educational Outcomes (PEOs)
PEO1 To provide students with adequate knowledge in mathematics, computer
science and few interdisciplinary courses that gears them for advanced
technology.

PEO2 To impart core knowledge in both hardware and software with problem
solving techniques.

PEO3 To conduct effective training programs in order to explore and enhance their
skills to synchronize with dynamic industry practices.

PEO4 To motivate students for higher studies and to involve in research.

2. Program Specific Outcomes (PSOs)

PSO1 Able to understand, analyse and develop simple to complex programs with the help
off knowledge gained from the Computer Science and Engineering subjects.
PSO2 Ability to develop real time, secure and distributed applications related to industry
and society with the knowledge of courses like Artificial Intelligence, Machine
learning, Big Data, Cloud Computing, IoT, Cyber Security and Open- source
Platforms.
Course Outcomes:
The students should be able to:

1 Use structured query language (SQL) for database creation and manipulation.
Demonstrate the working of different concepts of DBMS.
2 Implement and test the project developed for an application.

Course Objectives:
This course will enable students to:

1 Foundation knowledge in database concepts, technology and practice to groom

students into well-informed database application developers.
Strong practice in SQL programming through a various database problem.
2
Strong practice in SQL programming through a various database problem

3 Develop database application using front-end tools and batch-end tools of

DBMS
 ABSTRACT

The purpose of Employee Leave Management System is to automate the existing manual system
by the help of computerized equipment and full-fledged computer software, fulfilling their
requirements, so that their valuable data/information can be stored for a longer period with easy
accessing and manipulation of the same. The required software and hardware are easily
available and easy to work with. Employee Leave Management System, as described above can
lead to error free, secure, reliable and fast management system. It can assist the user to
concentrate on their other activities rather to concentrate on the record keeping. Thus it will help
organization in better utilization of resources. The organization can maintain computerized
records without redundant entries. That means that one need not be distracted by information
that is not relevant while being able to reach the information. The aim is to automate its existing
manual system by the help of computerized equipment and full-fledged computer software
fulfilling their requirements so that their valuable data information can be stored for a longer
period with easy accessing and manipulation of the same. Basically the process describes how to
manage for good performance and better services for the clients.

1
 Problem Statement Manual handling of employee information poses a number of
challenges. To develop a system that will maintain employee information in a database by fully
privacy and authority access. The project is aimed at setting up employee’s information system
about the status of the employee, the educational background and the work experience in order
to help monitor the performance and achievement of the employee through a password protected
system.

1.3 Aims and Objectives

⮚ The objective of this project is to automate leave management.

⮚ With the help of this application users can apply leave through online.

⮚ Head of the department can approve or escalate to higher levels; admin can update leave
status online.

⮚ The user can see the status of all leave taken and their remaining leave through this
application.

⮚ This system can be used to automate the workflow of leave request and their approvals.

⮚ There are features like approval of leave, cancellation of leave, report generators in this
system.

2
CHAPTER 2

REQUIREMENT SPECIFICATION

This chapter contains the Hardware requirements and Software requirements

specification of our mini project.

2.1 HARDWARE REQUIREMENTS:

Processor : Standard processor with 1.6 GHz or more.

RAM : 512 MB or more

Hard disk : 20 Gb or more

Monitor : Standard Color monitor

2.2 SOFTWARE REQUIREMENTS:

Operating System : Windows 7,8,10

Middle ware : PHP

Back end : MYSQL

Scripting : Java Script

Server : Apache ( Xampp )

3
CHAPTER 3

SYSTEM ANALYSIS AND DESIGN

3.1 Entity Relationship Diagram

The entity relationship data mode is based on preparation of real world that consisting of
collection of Basic objects call entities and relationships among those objects. an entity is an
“object” in the real world. That is distinguishable from other objects as you can see in the Fig
3.1.

4
Fig 3.1 Complete E-R diagram

5
3.2 Conversion of ER to Schema Diagram

The Fig 3.2 shows the skeleton structure that represents the logical view of entire
database. Schema defines its entities and the relationship among them. It contains a descriptive
detail of database, which can be depicted by means of schema diagram. This diagram shows the
working scope of an administrators and normal users.

Fig:3.2 ER to Schema Diagram

6
CHAPTER 4

IMPLEMENTATION

Implementation is the carrying out, execution, or practice of a plan, a method, or any

design, idea, model, specification, standard or policy for doing something. As such,
implementation is the action that must follow any preliminary thinking in order for something to
actually happen.

4.1 Overview

Implementation is the process of converting a new revised system design into operation.
The objective is to put the new revised system, which has been tested into operation while
holding costs, risks and personal irritation to the minimum. A critical aspect of the
implementation process is to ensure that there will be no description in the function of the
organization. The best methods for gaining control while implementation any new system would
be to use well planned test files for testing all new programs.

Another factor to be considered in the implementation phase in the acquisition of the

hardware and software. Once the software is developed for the system and testing is carried out,
it is the process of making the newly designed system fully operational and consistent in
performance.

7
4.2 SOURCE CODE

<?php

session_start();

error_reporting(0);

include('includes/config.php');

if(strlen($_SESSION['emplogin'])==0)

header('location:index.php');

else{

if(isset($_POST['apply']))

$empid=$_SESSION['eid'];

$leavetype=$_POST['leavetype'];

$fromdate=$_POST['fromdate'];

$todate=$_POST['todate'];

$description=$_POST['description'];

$status=0;

$isread=0;

if($fromdate > $todate){

8
 $error=" ToDate should be greater than FromDate ";

$sql="INSERT
tblleaves(LeaveType,ToDate,FromDate,Description,Status,IsRead,empid)
VALUES(:leavetype,:todate,:fromdate,:description,:status,:isread,:empid)";

$query = $dbh->prepare($sql);

$query->bindParam(':leavetype',$leavetype,PDO::PARAM_STR);

$query->bindParam(':fromdate',$fromdate,PDO::PARAM_STR);

$query->bindParam(':todate',$todate,PDO::PARAM_STR);

$query->bindParam(':description',$description,PDO::PARAM_STR);

$query->bindParam(':status',$status,PDO::PARAM_STR);

$query->bindParam(':isread',$isread,PDO::PARAM_STR);

$query->bindParam(':empid',$empid,PDO::PARAM_STR);

$query->execute();

$lastInsertId = $dbh->lastInsertId();

if($lastInsertId)

$msg="Leave applied successfully";

else

9
$error="Something went wrong. Please try again";

?>

<!DOCTYPE html>

<html lang="en">

<head>

<!-- Title -->

<title>Employe | Apply Leave</title>

<meta name="viewport" content="width=device-width, initial-scale=1.0, maximum-

scale=1.0, user-scalable=no"/>

<meta charset="UTF-8">

<meta name="description" content="Responsive Admin Dashboard Template" />

<meta name="keywords" content="admin,dashboard" />

<meta name="author" content="Steelcoders" />

<!-- Styles -->

<link type="text/css" rel="stylesheet"

href="assets/plugins/materialize/css/materialize.min.css"/>

<link href="http://fonts.googleapis.com/icon?family=Material+Icons"
rel="stylesheet">

10
 <link href="assets/plugins/material-preloader/css/materialPreloader.min.css"
rel="stylesheet">

<link href="assets/css/alpha.min.css" rel="stylesheet" type="text/css"/>

<link href="assets/css/custom.css" rel="stylesheet" type="text/css"/>

<style>

.errorWrap {

padding: 10px;

margin: 0 0 20px 0;

background: #fff;

border-left: 4px solid #dd3d36;

-webkit-box-shadow: 0 1px 1px 0 rgba(0,0,0,.1);

box-shadow: 0 1px 1px 0 rgba(0,0,0,.1);

.succWrap{

padding: 10px;

margin: 0 0 20px 0;

background: #fff;

border-left: 4px solid #5cb85c;

-webkit-box-shadow: 0 1px 1px 0 rgba(0,0,0,.1);

box-shadow: 0 1px 1px 0 rgba(0,0,0,.1);

11
}

</style>

</head>

<body>

<?php include('includes/header.php');?>

<?php include('includes/sidebar.php');?>

<main class="mn-inner">

<div class="row">

<div class="col s12">

<div class="page-title">Apply for Leave</div>

</div>

<div class="col s12 m12 l8">

<div class="card">

<div class="card-content">

<form id="example-form" method="post" name="addemp">

<div>

<h3>Apply for Leave</h3>

<section>

<div class="wizard-content">

<div class="row">

12
 <div class="col m12">

<div class="row">

<?php if($error){?><div class="errorWrap"><strong>ERROR </strong>:<?php echo

htmlentities($error); ?> </div><?php }

else if($msg){?><div class="succWrap"><strong> SUCCESS</strong>:< ?

php echo htmlentities($msg); ?> </div><?php }?>

<div class="input-field col s12">

<select name="leavetype" autocomplete="off">

<option value="">Select leave type...</option>

<?php $sql = "SELECT LeaveType from tblleavetype";

$query = $dbh -> prepare($sql);

$query->execute();

$results=$query->fetchAll(PDO::FETCH_OBJ);

$cnt=1;

if($query->rowCount() > 0)

foreach($results as $result)

{ ?>

<option value="<?php echo htmlentities($result->LeaveType);?>"><?php echo

htmlentities($result->LeaveType);?></option>

13
<?php }} ?>

</select>

</div>

<div class="input-field col m6 s12">

<label for="fromdate">From Date</label>

<input placeholder="" id="mask1" name="fromdate" class="masked" type="text" data-

inputmask="'alias': 'date'" required>

</div>

<div class="input-field col m6 s12">

<label for="todate">To Date</label>

<input placeholder="" id="mask1" name="todate" class="masked" type="text" data-

inputmask="'alias': 'date'" required>

</div>

<div class="input-field col m12 s12">

<label for="birthdate">Description</label>

<textarea id="textarea1" name="description" class="materialize-textarea" length="500"

required></textarea>

</div>

</div>

<button type="submit" name="apply" id="apply" class="waves-effect waves-light

btn indigo m-b-xs">Apply</button>

14
 </div>

</div>

</section>

</section>

</div>

</form>

</div>

</div>

</div>

</div>

</main>

</div>

<div class="left-sidebar-hover"></div>

<!-- Javascripts -->

<script src="assets/plugins/jquery/jquery-2.2.0.min.js"></script>

<script src="assets/plugins/materialize/js/materialize.min.js"></script>

<script src="assets/plugins/material-preloader/js/material Preloader.min.js"><

/script>

<script src="assets/plugins/jquery-blockui/jquery.blockui.js"></script>

<script src="assets/js/alpha.min.js"></script>

15
 <script src="assets/js/pages/form_elements.js"></script>

<script src="assets/js/pages/form-input-mask.js"></script>

<script src="assets/plugins/jquery-inputmask/jquery.inputmask.bundle.js"></
script>

</body>

</html>

<?php } ?>

16
CHAPTER 5
SNAPSHOTS
Home Page
This is the login page of our Employee-Leave management System where
employees or admin can login to their respective user account by entering username and
password.

Fig 5.1 Home page

17
Admin page:
This is admin login page where admin can login into his page by entering user name and
password.

Fig 5.2 Admin page

Admin Dashboards This is the Admin dashboard page where admin enter his page and
controls all the operations.
Fig 5.3 Admin Dashboards

18
Employee Home Page
Here Employee can view and update his profile , change Password, apply leave.

Fig 5.14 Employee Home Page

Employee Info (Profile)

Here Employee can view his profile and update his information.

19
Fig 5.15 Employee Info (Profile)

20
Employee Leave application
Here Employee can apply Leave to his Department.

Figure 5.16 Employee Leave History

21
 CONCLUSION

With the theoretical inclination of our syllabus it becomes very essential to take the at most

advantage of any opportunity of gaining practical experience that comes along. The building

blocks of this Major Project "EMPLOYEE LEAVE MANAGEMENT SYSTEM" was one of

these opportunities. It gave us the requisite practical knowledge to supplement the already

taught theoretical concepts thus making us more content as a computer engineer.

22
 REFERENCES

Books

nd
1. “Web Programming”, by ‘Chris Bates’ Wiley Dreamtech India, 2
Edition.“BeginningJava. Server pages” by ‘Vivek Chopra’,’John Eves’.

2. AJAX for Dummies” by Steve ‘Holznerwiley’ publishing,INC

3. Software Engineering”, Ian Somerville, Sixth Edition, Pearson Education Ltd.”Object

Oriented System Development”,MCGraw-Hill by Ali Bahrami.

Websites

4. http://en.wikipedia.org/wiki/PHP

5. http://www.hotscripts.com/category/php/for

6. http://www.apache.org/for apache server.

7. http://www.mysql.com/click.php?e=35050 for MySql.

8. http://w3schools.com for information

23