MAHARASHTRA STATE BOARD OF TECHNICAL EDUCATION,

MUMBAI

A
MICRO PROJECT REPORT
ON

“DEVELOP & MAINTAIN XML DATABASE FOR EMPLOYEE

INFORMATION SYSTEM”

SUBMITTED BY
KHUSHI KOTE
SUPRIYA KANDHARE
MANDAKINI KHARBE
DHAMMASHILA ZAGADE

GUIDED BY
“Ms. SILEDAR J.T.”

DEPARTMENT OF COMPUTER ENGINEERING

INDIRA INSTITUTE OF TECHNOLOGY (POLYTECHNIC),
VISHNUPURI, NANDED.
ACADEMIC YEAR
2024-2025

I
MAHARASHTRA STATE BOARD OF TECHNICAL EDUCATION, MUMBAI

CERTIFICATE

CERTIFIED THAT THE MICROPROJECT REPORT ENTITLED

“DEVELOP & MAINTAIN XML DATABASE FOR EMPLOYEE INFORMATION
SYSTEM”

Is a Bonafide work carried out by KOTE KHUSHI KAILAS, KHARBE

MANDAKINI CHANDU, SUPRIYA DILIP KANDHARE, ZAGADE
DHAMMASHILA MADHAV in partial fulfilment for the award of diploma in Computer
Engineering of the Maharashtra State Board of Technical Education Mumbai during the
year 2024-2025.It has been certified that all the corrections/suggestions indicated for
internal assessment has been incorporated in the report deposited in the Department library.
The Micro-project report has been approved as it satisfied the academic requirements in
respect of Micro-project for the Diploma.

Course In-Charge HOD PRINCIPAL

(Ms. SILEDAR J.T.) (Ms. CHOUDHARY N.G.) (Dr. AGRAWAL E. S.)

DEPARTMENT OF COMPUTER ENGINEERING

INDIRA INSTITUTE OF TECHNOLOGY (POLYTECHNIC),
VISHNUPURI, NANDED.

II
 ACKNOWLEDGEMENT
I offer my sincere thank with a deep sense of gratitude to my guide
“Ms. SILEDAR J.T.” and Head Of Department “Ms. CHOUDHARY N.G.” for their
valuable direction and guidance to my micro project work his meticulous attention
towards my micro project without taking of his voluminous work. I am also thankful to
our principle “Dr. AGRAWAL E. S.” for his encouragement towards my micro project.
Last but not least I am also thankful to all staff members of our department for their
valuable guidance during my micro project work.

Sincerely

NAME ROLL NO

Khushi Kote 07
Supriya Kandhare 21
Mandakini Kharbe 06
Dhammashila Zagade 16

Branch: Computer Engineering.

Class: CO5I

III
 Evaluation Sheet For The Micro Project
Academic Year: 2024-2025. Name Faculty: MS. SILEDAR J.T.
Course: ADBMS Course Code: 22521 Semester: 5I

Title of the project: “Develop & Maintain XML Database For Employee
Information System’’
Major learning outcomes achieved by the students by doing this project:
A) Practical Outcomes In Cognitive Domain:
1) Apply Information Technology knowledge to solve broad-based Information
Technology related knowledge.
2) Apply appropriate computer engineering related technique /tools with an understanding
of the limitations.
B) Unit Outcome In Cognitive Domain:
1) Apply ethical principles for commitment to professional ethics, responsibilities and
norms of the practice also in the field of computer engineering.
C) Outcomes In Effective Domain:
1) Follow ethical practices.
2) Follow precautionary measures.
D) Comments/Suggestions About Team Work/Leadership/Interpersonal
Communications (If Any)

Marks out Marks out of

of 6 for 4 for
Roll performance performance Total out of
Student Name
no. in group in oral / 10
activity (d5 presentation
col.8) (d5 col.9)
Kharbe Mandakini
06.
Chandu
Zagade Dhammashila
16.
Madhav
07. Kote Khushi Kailas
Kandhare Supriya
21.
Dilip

IV
 INDEX

Sr. Page
Particulars
No. No.

PART-A 1

1.1 Introduction 1

1.2 Aim Of The Micro Project 1

1.3 Action Plan 1

1.4 Resource Used 2

PART-B 4

2.1 What is XML Database for Employee 4

2.2 System Requirements For Employee 5

2.3 Database Design For Employee Information System 5

2.4 Database Implementation XML Database For Employee 6

2.5 Advantages For Employee Information System 8

2.6 Challenges 8

2.7 Benefits 9

2.8 Conclusion 16

2.9 References 17

V
 PART A
1.1 INTRODUCTION

The objective of this micro-project is to design and implement an XML database for
storing and managing employee information.

1.2 AIM OF THE MICROPROJECT

to create an application for XML database for employee information system.

1.3 ACTION PLAN

Planned Name of
Sr. Planned
Details of Activity Finish Responsible Team
No. Start Time
Date Members

Decide the Subject of

1
project
Mandakini
Chandu Kharbe

Dhammashila
Collect information of
2 Madhav Zagade
project

Khushi Kailas
Kote

Supriya Dilip
3 Creating report Kandhare

Department Of Computer Engineering (SSS IIT Poly) 6

1.4 RESOURCES USED

Sr. Name of
Specifications Quantity Remark
No. Resources

Computer (i3-i5
Hardware prefarable),
01) Computer RAM minimum 2GB and
System onwards,HDD free Space
1GB or more

As per For all

batch practical of
Size used

Operating
02) Windows 11/Linux or higher
System

03) Software OXYGEN

Department Of Computer Engineering (SSS IIT Poly) 7

 PART B
2.1 What Is XML Database For Employee?
An XML database is a data persistence software system that allows data to be
specified, and sometimes stored, in XML format. This data can be queried, transformed,
exported and returned to a calling system. XML databases are a flavor of document-oriented
databases which are in turn a category of No-SQL database.

Extensible Mark-up Language (XML) lets you define and store data in a shareable
manner. XML supports information exchange between computer systems such as websites,
databases, and third-party applications. Predefined rules make it easy to transmit data as
XML files over any network because the recipient can use those rules to read the data
accurately and efficiently.

Extensible Markup Language (XML) is a markup language that provides rules to

define any data. Unlike other programming languages, XML cannot perform computing
operations by itself. Instead, any programming language or software can be implemented for
structured data management.

For example, consider a text document with comments on it. The comments might
give suggestions like these:

 Make the title bold

 This sentence is a header

 This word is the author

Such comments improve the document’s usability without affecting its content.
Similarly, XML uses markup symbols to provide more information about any data. Other
software, like browsers and data processing applications, use this information to process
structured data more efficiently.

When a company sells a good or service to another company, the two businesses need
to exchange information like cost, specifications, and delivery schedules.

Department Of Computer Engineering (SSS IIT Poly) 8

2.2 System Requirements for Employee

1) User-Friendly Interface

2) Time and Attendance Tracking

3) Performance and Productivity Tracking

4) Employee Scheduling

5) Employee Self-Service Portal

6) Automated On-boarding

7) Compliance Tracking

8) Security and Data Protection

1) User-Friendly Interface

A user-friendly employee management system is paramount in ensuring the

productivity of an organization’s workforce. The easier it is for employees to use, the more
likely they will use it. A user-friendly employee management system is key for improving
productivity, retaining employees, and meeting compliance requirements. With an intuitive
interface, it becomes easier to train new users, which is especially important as various
departments interact with the system. Additionally, it helps keep data accurate and up-to-date,
avoiding compliance issues and enabling effective planning and forecasting. Investing in a
suitable employee management system can help organizations achieve these goals and
maximize their potential.

2) Time and Attendance Tracking

An employee management system incorporating time and attendance tracking is

essential for any organization. It will help you ensure that employees work during their
scheduled times. Additionally, you can accurately track every employee’s time on different
tasks and projects. Furthermore, you can use it to calculate the correct amount of pay,

Department Of Computer Engineering (SSS IIT Poly) 9

 including overtime, commissions, and bonuses. Including a time and attendance tracking
system in an employee management system will help reduce the risk of staff working
overtime without compensation.

3) Performance and Productivity Tracking

An employee management system’s performance and productivity tracking function

can provide valuable insight into your employees’ productivity. Here’s why it is vital for your
organization:

 Performance and productivity tracking will help you identify areas of improvement
for your team members to ensure they are meeting their full potential.
 It provides a more accurate representation of labor costs in your organization.
 It helps you understand which team members are most effective and help you to
determine which employees should be assigned to specific tasks.
 This information can also be helpful when it comes to planning and forecasting.

4) Employee Scheduling

An employee scheduling feature of an Employee Management System can help you

more effectively plan your workforce and reduce the risk of overworking your employees. It
works best for organizations where teams work in rotating shifts. This feature can let your
employees view their scheduled and upcoming shifts, making their lives a little easier.
Managers can also see all employee shifts at once, making it easier to adjust schedules
quickly. It allows managers to balance the workload and prevent overworking staff.
Additionally, it helps managers plan for absences, minimizing the disruption to the
organization.

5) Employee Self-Service Portal

An employee self-service portal allows employees to securely access their personal

information and benefits, such as paid time off, health plans, stock options, and salary
information, all in one place. Employees can easily track vacation time, expenses, and other

Department Of Computer Engineering (SSS IIT Poly) 10

 information relevant to their organization’s needs. It will further reduce the workload of HR
and other administrative staff responsible for updating this information manually. In addition,
this feature can be helpful for employees who travel for work and cannot visit HR in person.
It can also benefit employees working from home and unable to visit the office.

6) Automated On-boarding

An employee on-boarding feature can help you quickly and easily collect all the
information from new employees. And it will provide them with the information they need to
know to work in your organization. For example, the on-boarding feature can collect
information about an employee’s background and experience, as well as their availability and
preferences for scheduling. It can also collect information about an employee’s finances, such
as their address and tax information. You can store this information in the employee
management system. And further, you can use it to calculate financial information relevant to
HR and other administrative staff.

7) Compliance Tracking

While looking for important features, you must check whether the EMS has
compliance tracking. An employee management system can help you to track your
compliance, which can help to reduce the risk of non-compliance and fines. It can be helpful
for organizations with a large international presence and those with contracts with
government entities. A good employee management system will include tracking compliance
with various regulations. It includes employee scheduling, benefits, pay and paid time off, the
Labor Act, health and safety, and privacy. Compliance tracking can help you to meet your
obligations regarding these regulations, including keeping records and providing reports
when necessary.

8) Security and Data Protection

When selecting an employee management system, ensure it is secure with measures

to prevent unauthorized access to the data. It should have an appropriate data protection

Department Of Computer Engineering (SSS IIT Poly) 11

policy based on the system type. The security features chosen should depend on the system,
the data’s nature, and its intended use. These features help safeguard your organization from
cyber assaults, data leaks, and identity theft and guard employees’ personal details and
privacy. Additionally, these features guarantee adherence to data protection regulatory
requirements. So when going for EMS do check for its security features.

Department Of Computer Engineering (SSS IIT Poly) 12

2.3 Database Design for Employee Information System

The XML database schema consists of the following elements:

- Employee (root element)

- Employee_ID (unique identifier)
- Name
- Department
- Designation
- Contact_Info (phone, email)
- Address

 XML Schema Definition (XSD):

<?xml version="1.0" encoding="UTF-8"?>

<xsd:schema xmlns:xsd="(link unavailable)"
targetNamespace="(link unavailable)"
xmlns:emp="(link unavailable)"
elementFormDefault="qualified">

<xsd:element name="Employee" type="emp:EmployeeType"/>

<xsd:complexType name="EmployeeType">
<xsd:sequence>
<xsd:element name="Employee_ID" type="xsd:string"/>
<xsd:element name="Name" type="xsd:string"/>
<xsd:element name="Department" type="xsd:string"/>
<xsd:element name="Designation" type="xsd:string"/>
<xsd:element name="Contact_Info">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="Phone" type="xsd:string"/>
<xsd:element name="Email" type="xsd:string"/>
</xsd:sequence>
</xsd:complexType>

Department Of Computer Engineering (SSS IIT Poly) 13

 </xsd:element>
<xsd:element name="Address" type="xsd:string"/>
</xsd:sequence>
</xsd:complexType>

</xsd:schema>

 Sample XQuery (EmployeeQuery.xq):

xquery version "3.0";

declare namespace emp = "(link unavailable)";

(: Retrieve employee by ID :)
let $empID := "101"
return //emp:Employee[emp:Employee_ID=$empID]

 Sample XML Document (Employee.xml):

<?xml version="1.0" encoding="UTF-8"?>

<Employees>
<Employee>
<Employee_ID>101</Employee_ID>
<Name>John Doe</Name>
<Department>HR</Department>
<Designation>Manager</Designation>
<Contact_Info>
<Phone>1234567890</Phone>
<Email>john.doe@example.com</Email>
</Contact_Info>

Department Of Computer Engineering (SSS IIT Poly) 14

 <Address>123 Main St, Anytown, USA</Address>
</Employee>
<!-- Add more employee records -->
</Employees>

In above example to shows the information about the employee. In that example to
take the Employee_ID, Employee_Name, Employee_department, contact information and
email of the employee.
The above example shows the information about the employee. We saw the above
example only one employee’s information in that example.

This example to shows the information about the employee using the XML
(eXtensible Markup Language) that are shown in above example .

In this example we take the XML version that are “1.0” are used. That shows all/
overall information are shows in that example of employee.

In that all information are added more employee records, roots element and unique
identifier.
An employee management system’s performance and productivity tracking function
can provide valuable insight into your employees’ productivity. Here’s why it is vital for your
organization.

Department Of Computer Engineering (SSS IIT Poly) 15

 Output

Department Of Computer Engineering (SSS IIT Poly) 16

2.4 Database Implementation on XML Database for Employee

I've been trying to learn programming for a while. I've studied Java and Python, and
I'm comfortable with their syntax. Recently, I wanted to use what I've learnt with coding a
tangible software from ground up.

I want to implement a database engine, sort of a No-SQL database. I've put together a
small document, sort of a specification to follow throughout my adventure of coding it. But
all I know is a bunch of keywords. I don't know where to start.

Can someone help me find out how to gather the knowledge I need for this kind of
work and in what order to learn things? I have searched for documents, but I feel like I'll end
up finding unrelated/erroneous content or start from a wrong point, because implementing a
complete database engine is (seeming to be) a truly complicated task.

I want to express that I'd prefer theses and whitepapers and (e)books to codes of other
projects, because I've asked a question of kind in which people usually get answered in the
form of "read project - x' source code". I'm not at the level of comfortably reading and
understanding source

First, you may have a look that the answers for How to write a simple database engine.
While it focus on a SQL engine, there is still a lot of good material in the answers.
Otherwise, a good project tutorial is Implementation of a B-Tree Database Class. The
example code is in C++, but the description of what is done and why is probably what you'll
want to look at anyway.
Also, there is Designing and Implementing Structured Storage (Database
Engine) over at MSDN. Plenty of information there to help you in your learning project.

Department Of Computer Engineering (SSS IIT Poly) 17

2.5 Advantages for Employee Information System

1) Employee engagement

2) Employee self-service

3) Cost-effectiveness

4) Increased productivity

5) Data security

6) Data-driven decision-making

7) Attendance tracking

8) Benefits management

9) On-boarding

10) People analytics

11) Performance evaluation

12) Employee management system

13) Payroll administration

14) Workforce planning

15) Improve collaboration

Department Of Computer Engineering (SSS IIT Poly) 18

2.6 E-R Diagram for employee information

Department Of Computer Engineering (SSS IIT Poly) 19

 2.7 Benefits

1) Certainty on their first-day

We all remember our nerves on the first day at a new school. We didn't know who we
would be meeting, what to expect, and how to prepare.

Those same nerves exist for your new hires. They hope they made the right choice in
choosing your company, but it's natural for fear, uncertainty, and doubt to creep in as they
leave the comfort of their previous employer.

A robust HRIS platform can ensure that employees don't feel those first-day jitters.
Most modern HRIS platforms have robust digital on-boarding tools that can allow new hires
to: meet their new team, learn about the company's mission, vision and values, fill out their
new hire paperwork and start having conversations with their new manager.

Smart companies leverage these on-boarding tools to create a great employee first
impression. Rather than an employee spending their entire first day alone with a stack of
papers, that same employee can come in to the office already knowing what to do and who to
talk to.

2) Ability to control their information

Most employees do not have static lives. The accurate information on their first day
may no longer be accurate six months later.

Employees will move, and their home addresses will change. Employees will have
children and need to add new dependents. Employees will talk with their financial planner
and need to change their withholdings.

These are all significant life events for your employees that can have implications on
their healthcare coverage and tax filings, so the easier it is for employees to resolve these
issues, the happier they are.

Department Of Computer Engineering (SSS IIT Poly) 20

 A quality HRIS software is one where employees have full access to their own
demographic, pay and benefits information and, ideally, can make any of these changes on a
mobile app from the comfort of their own home.

Forcing employees to request these changes in a manual, paper-driven process will

only add stress and frustration to your employees' daily lives.

3) Pathways for future growth and promotions

We no longer live in a world where employees are expected to work for the same
employer their entire life. In that traditional employment structure, employees got used to the
'corporate ladder.' Employees knew that, at regular intervals, they would be up for
promotions, and they knew exactly what job sat above their own.

The modern landscape is much more dynamic as employees are less tied to their
employers and, in turn, employers do not have the same promotion structures. Because of this
change, modern employees have a much harder time understanding where they fit into their
organization, how they are performing and what opportunities lay beyond their current role.

4) Connection to colleagues and the company

Especially in the days of COVID and work from home, employees do not have the
same access to their corporate culture that they once did. The water cooler is not available to
all employees these days, and smart companies are recreating it online.

Most modern HRIS's help companies: connect disparate teams, blast out important
company updates, enable peer-to-peer messaging and better receive employee suggestions.

Giving your employees a space where they can connect with their peers, stay in tune
to key business updates and communicate to the broader organization is something that we
took for granted in physical offices. Now that we are moving more and more online, it is
something that employees will come to expect from their employers.

Department Of Computer Engineering (SSS IIT Poly) 21

5) Real-time analytics and reporting

No HR team can make data-driven decisions without real-time HR data. The best
human resources information systems (HRISs) are great at collecting data on how employees
are performing, what processes they need to complete, and how specific initiatives or
programs are spurring the organization's performance forward.

For instance, HRISs can quickly aggregate: employee engagement data, timesheet
information, turnover rates, promotional success, and more. This real-time insight into the
company’s progress is a great way to help companies make better HR investments and
strategies decisions.

 Employee Metadata (EmpMetadata.txt)

This section provides the contents of a text document (EmpMetadata.txt), which

contains sample employee metadata.

Node Name Node Data Node XPath Name XPath Data XPath
Type Length Type Length

EMPLOYEE_ID Number 8 XEmpID character 8

FIRST_NAME character 20 XFirstName character 20

LAST_NAME character 25 XLastName character 25

EMAIL character 25 XEmail character 25

PHONE_NUMBER character 20 XPhone character 20

HIRE_DATE Data 25 XHireDate character 25

JOB_ID character 10 XJobID character 10

Department Of Computer Engineering (SSS IIT Poly) 22

  XML Schema

 Newer, increasing use

 The type of an XML document can be specified using a DTD.
 DTD constraints structure of XML data.
 What elements can occur?
 What attributes can/must an element have?
 What subelements can/must occur inside each element, and how many times?
 DTD does not constrain data types.
 All values represented as strings in XML.
 DTD syntax.
 <!ELEMENT element (subelements-specification) >
 <!ATTLIST element (attributes)
 Sub-elements can be specified as
 names of elements, or
 #PCDATA (parsed character data), i.e., character strings
 EMPTY (no subelements) or ANY (anything can be a subelement)
 Example
 <! ELEMENT department (dept_name building, budget)> <! ELEMENT dept_name
(#PCDATA)>
 ! ELEMENT budget (#PCDATA)>
 Sub element specification may have regular expressions

Department Of Computer Engineering (SSS IIT Poly) 23

2.8 Conclusion

An employee information system, or employee management system (EMS), can help

businesses improve efficiency and productivity, and create a better work environment:
Finally, the benefits that a sophisticated HR information system brings can not be
overemphasized. An effective, reliable, and safe system ensures convenient administration of
the personnel's daily records and, hence, has a major contribution towards the organization's
prosperity.

Department Of Computer Engineering (SSS IIT Poly) 24

2.9 References:

1. Book Name: Database System Concepts, Author Name: Rajiv Chopra, Edition:2007,
Volume: I—Fundamentals.
2. Book Name: Fundamentals of Database Systems, Author Name: Ramez Elmasri and
Shamkant B. Navathe, Edition: 2005, Volume:I – Fundamentals.
3. Book Name: Database Management Systems, Author Name: Abraham Silberschatz,
Edition: 2002, Volume: I : Core Technologies.
4. Book Name: The Data Warehouse Toolkit, Author Name: Ralph Kimball and Margy
Ross, Edition:1997, Volume: Li—Advanced Features.
5. Book Name: High Performance My-SQL, Author Name: Baron Schwartz,
Edition:1998, Volume: I—Fundamentals.

Department Of Computer Engineering (SSS IIT Poly) 25