INDEX
SL NO Content Page no
1 Introduction to the Project 5
2 Objectives of the Project 6
3 Hardware and Software 7
requirements
4 Main Components of Project 8
4.1 Creating Database 9
4.2 Creating Table 10
4.3 Creating a Form 13
4.4 Inserting Data in the Table 21
4.5 Creating Relationship between 22
Tables
4.6 Creating Queries 24
4.7 Creating a Reports 27
5 Limitations of the Project 32
6 Future Scope and Enhancement 33
7 Bibliography 33
Page 1
4
1. Introduction of the Project
In today’s digital workplace, managing employee
information efficiently is essential for every organization.
Traditional manual systems — using paper records or
spreadsheets — often lead to data duplication, errors, and
delays in accessing employee details. To overcome these
challenges, organizations are adopting computerized systems
that ensure accuracy, security, and easy accessibility of
employee data.
The Employee Database Management System (EDMS) is a
software solution designed to store, manage, and retrieve
employee information in a structured manner. It provides a
centralized database to manage employee details such as
personal information, department, attendance, and salary.
This system helps the HR department and management to
monitor performance, maintain accurate attendance records,
and generate reports quickly.
By automating daily HR operations, the EDMS improves
overall efficiency, reduces paperwork, and ensures data
consistency — contributing to better decision-making and
smoother organizational workflow.
Page 1
5
2. Objectives and Scope of the Project
LibreOffice Base Project: Employee Database Management System
The main objectives of the Employee Database Management System are:
• To maintain a centralized and secure database of all employee records.
• To automate tasks related to employee management, such as attendance
tracking and salary maintenance.
• To reduce manual errors and save time in managing employee data.
• To provide quick access to employee details such as contact, department,
and work status.
• To simplify report generation for HR and management analysis.
• To ensure data accuracy, integrity, and confidentiality.
• To improve coordination between departments by sharing updated
employee information.
The Employee Database Management System covers all key functions
related to employee administration within an organization.
It includes the following modules:
• Employee Management: Storing and managing employee details like
name, gender, contact, department, and salary.
• Department Management: Maintaining information about departments
and their managers.
• Attendance Management: Recording daily attendance and tracking
employee presence/absence.
• Report Generation: Generating customized reports on employee details,
attendance, and salary statistics.
• Data Security: Ensuring authorized access to sensitive employee records.
The system can be extended in the future to include additional modules such
as payroll
Page 1
processing, performance evaluation, leave management, and
automated notifications, making it a complete HR management solution.
6
3. Hardware and Software Specification
Hardware:
• Processor: Pentium® 200 @ 3.70 GHz
• Processor Speed: 533 MHz
• RAM: 2 GB or more
• Hard Disk 2.00 GB
Software:
• At-least 650 M bytes available disk space for a default
install (including JRE) via download, After installation
and deletion of temporary installation files
• OS-Microsoft Windows (Windows XP, Windows 2003,
Windows Vista,Windows 7, Windows 8 *)
• LibreOffice will use approximately 440 M bytes disk
space
• LibreOffice
Page 1
7
[Link] Components of Employee
Database Management System
The Employee Database Management System will have the following components,
Tables
• Employees → EmpID, Name, Gender, Contact, DeptID, Salary
• Departments → DeptID, DeptName, Manager
• Attendance → AttID, EmpID, DeptID, Date, Status [Present/Absent]
Forms:
• To enter new Employees, Departments, and Attendance details.
Relation:
• EmpID & DeptID in Attendance.
Example Query 1: Employees with Salary greater than ₹50,000
Tables to use: Employees, Departments, Attendance
Fields to select:
• [Link]
• [Link]
• [Link]
• [Link]
• [Link]
Filter (Criterion):
👉
• Salary → >50000
Report: Lists all employees earning more than ₹50,000 along with their
department.
Example Query 2: Employees absent on 01-09-2025
Tables to use: Employees, Departments, Attendance
Fields to select:
• [Link]
• [Link]
• [Link]
• [Link]
Filter (Criterion):
• Date → =#25/09/01#
👉
• Status → "Absent"
Report: Lists employees who were absent on 1st September 2025 with their
department
Page 1 details.
8
4.1 Creating a Database
• Go to Start Menu → LibreOffice Base
• The Database Wizard will open
• Choose "Create a new database" → click Next.
• For “Register the database,” choose Yes
• Select Finish.
• Enter a file name (e.g.Employee_Database_Management_System.odb).
Page 1
9
4.2 Creating a Tables
Perform the steps for creating Employees table.
• Step 1: Open School Result Management System Database by clicking
on File → Open option and locate
Employee_Database_Management_System.odb file.
• Step 2: Click on Tables tab, then click on Create Table in Design View
option under the Tasks pane.
• Step 3: A blank table opens in the Design View. Type the field names
and data types as shown.
• Step 4: Set EmployeeID as the primary key
• Step 5: Click on the Save button from the standard toolbar. The Save
As dialog box will open, save the table as Employees.
Page 1
10
Perform the steps for creating Departments table.
• Step 1: Click on Tables tab, then click on Create Table in Design View
option under the Tasks pane.
• Step 2: A blank table opens in the Design View. Type the field names
and data types as shown.
• Step 3: Set DeptID as the primary key
• Step 4: Click on the Save button from the standard toolbar. The Save
As dialog box will open, save the table as Departments.
Page 1
11
Perform the steps for creating Attendance table.
• Step 1: Click on Tables tab, then click on Create Table in Design View
option under the Tasks pane.
• Step 2: A blank table opens in the Design View. Type the field names
and data types as shown.
• Step 3: Set AttID as the primary key
• Step 4: Click on the Save button from the standard toolbar. The Save
As dialog box will open, save the table as Attendance.
Page 1
12
4.3 Creating a Form and Insert records in a table
• Step 1: Click on Forms → Use Wizard to Create Form…
• Step 2: A Form Wizard appears.
Page 1
13
• Step 3: Select the table from Tables or Queries, then add all the
fields.
• Step 4: Click on Next button. Ignore Step 2,3 and Step 4.
• Step 5: Select the first option i.e. Columnar – Labels Left, then
click on the Next button.
Page 1
14
• Step 6: The data entry step will appear. Since we gonna create
form to enter data into a table choose first option ‘The form is to be
used for entering new data only’ and click on Next.
• Step 7: Choose the styles for the form interface and click on Next.
Page 1
15
• Step 8: Type a new name for the form and click on Work with the
form. Finally, click on Finish.
• Step 9: Form Looks as shown below
Page 1
16
Same way Create a data entry form for Departments table and
Attendance table so that Form looks as shown below
Page 1
17
Inserting Record using Employees_Data_Entry_form
Record added in Employees table
18
Page 1
Inserting Record using Departments_Data_Entry_form
Record added in Departments table
Page 1 19
Inserting Record using Attendance_Data_Entry_form
• Record added in Attendance table
Page 1
20
4.4 Inserting Data in the table
Employees Table Departments Table
Attendance Table
Page 1
21
4.5 Creating a Relationship between tables
Perform the steps for create the relationships between both tables
• Step 1: Click on the relationships option in the tool menu. ‘Add
table’ dialog box will appear
• Step 2: Add the tables in the amongst which you want to create the
relationship. Select the tables and click on ADD button
Page 1
22
• Step 3: Drag the Primary key column from one table and drop it
on the key column of another table.
Page 1
23
4.6 Creating Queries
Perform the steps to create a Query
• Step 1: Click on the query option in the database pane
• Step 2: Click on the Create Query in the Design view option
under the tasks pane
• Step 3: Add the tables dialog box will appear. Select the tables and
click on ADD button
Page 1
24
Displaying Employees with Salary greater than ₹50,000
• Step 1: Select the fields from selected tables and run the query
using option EDIT -> Run Query
• Step 2: Query table looks like given below
Page 1
25
Displaying Employees absent on 01-09-2025
• Step 1: Select the fields from selected tables and run the query
using option EDIT -> Run Query
• Step 2: Query table looks like given below
Page 1
26
4.7 Creating Reports
Perform the Steps for create the Report
• Step 1: Click on the Report option in the database pane
• Step 2: Click on the Use Wizard to create Report option
under the task pane
• Step 3: Select desire query under the tables or queries option and
select entire field in this step and click next button to move to next step
Page 1
27
• Step 4 : Specify the Label for each field an click next button
• Step 5 : In the grouping section, select the field by which you
want to group the data
Page 1
28
• Step 6 : In the sorting section, choose the field(s) you want to
sort by and specify whether the order should be ascending or
descending
• Step 7: In the layout section, select Tabular under Layout of
Data, and then click on Next.
Page 1
29
• Step 8 : Specify the title for the Report and click on the Finish
button
Summarised Report for created query looks as given below
Page 1
30
Same way Create Employees_Absent_On_1stSept_Report for
Employees_Absent_On_1stSept_query
Summarised Report for created query looks as given below
Page 1
31
5. Limitations of the Project
• The application now runs smoothly on Windows 10 without
compatibility issues
• LibreOffice Base does not support some advanced features
available in paid database systems like MS Access or SQL Server.
• Performance may decrease when handling very large datasets or
complex queries.
• Limited integration with third-party software compared to
commercial alternatives.
• Lacks some collaboration features that are more robust in MS
Office or cloud-based platforms.
• May require additional configuration or extensions for full
functionality (e.g., connecting to external databases like MySQL
or PostgreSQL).
• User interface is less modern and intuitive compared to
commercial counterparts.
• Creating complex reports or forms may take additional time due to
limited built-in templates.
Page 1
32
6. Future Scope and Enhancement
• Listed limitations will overcome in upcoming versions.
• Working on User Interface.
• Able to deal with large volume of data.
• Students will easily prepare project on other topics in future.
7. Bibliography
• Information Technology NCERT Text Book, 2024
• Information Technology By Sumita Arora, Dhanpat Rai
Publications
• Information Technology CBSE Materials, 2024
Page 1
33