THE SCHRAM ACADEMY
ONE SCHRAM AVENUE, MADURAVOYAL, CHENNAI -600 095
402 – X INFORMATION TECHNOLOGY
PRACTICAL REPORT
2022-2023
NAME : ..................................................
CLASS & SECTION : ..................................................
ROLL NUMBER : ..................................................
TITLE OF THE PROJECT : ..................................................
.....................................................
BONAFIDE CERTIFICATE
REGISTER NO. :.........................................
Certified to be the bonafide project work done by ................................................................. of Std
.......................in the subject of ............................................................................ of The Schram
Academy, Maduravoyal, Chennai -600 095, during the year 2021 -2022.
Date : Teacher incharge
ACKNOWLEDGEMENT
It is our privilege to express our sincerest regards to our respected Principal, Ms. Nazreena for her
valuable inputs, able guidance, encouragement, whole hearted cooperation and constructive criticism
throughout the duration of our project.
I extend my appreciation to Ms................................................... , our Information Technology teacher
who guided me to the successful completion of this project.
I take this opportunity to express my deep sense of gratitude to her invaluable guidance on going
encouragement, enormous motivation, which has sustained my efforts at all stages of project
development.
I would like to thank my parents and all other family members for their timely encouragement, and
love during the course of the project development.
Lastly, I would like to thank my classmates and friends for their cooperation and support throughout
the year.
LIBRARY MANAGEMENT SYSTEM
INDEX PAGE
SL.NO TOPIC PAGE
NUMBER
1
1 INTRODUCTION- EMPLOYEE MANAGEMENT SYSTEM
2 HARDWARE AND SOFTWARE REQUIREMENTS 1
3 ABOUT OPEN OFFICE BASE 2
4 IDENTIFYING FIELDS 3
5 CREATING TABLE 4
6 INSERTING RECORDS 5
7 UPDATING RECORDS 6
8 DISPLAYING RECORDS 7-8
A. DISPLAYING PARTICULAR RECORD USING WHERE
CLAUSE 7
B. SORTING -ORDER BY 7
C. DISPLAYING ALL RECORDS 7
D. DISPLAYING PARTICULAR COLUMN 8
E. DISPLAYING RECORD USING KEYWORD BETWEEN 8
F. DISPLAYING RECORDS USING PATTERN MATCHING 8
9 DELETE RECORDS 9
10 STEPS TO CREATE FORMS 10
11 STEPS TO CREATE REPORTS 10
12 OUTPUT SCREENS 11
13 BIBLIOGRAPHY 12
INTRODUCTION
EMPLOYEE MANAGEMENT SYSTEM USING OPEN OFFICE BASE
An employee management system is a software that helps your employees to give their best efforts
every day to achieve the goals of your organization. It guides and manages employees' efforts in the
right direction. It also securely stores and manages personal and other work-related details for your
employees. That makes it easier to store and access the data when there is a need.
In the employee management system, you can manage admin activities in an easier and quicker way.
Employees are an important part of your organization; it is their work that ultimately contributes to
the bottom line of the company. It is an important part of HR management. It also helps employee
engagement and performance management brings down costs and increases productivity.
HARDWARE AND SOFTWARE REQUIREMENTS
HARDWARE
PROCESSOR : 11TH GEN INTEL(R) CORE(TM) i5-1135G7@ 2.40GHz
INSTALLED RAM : 8.00 GB
SYSTEM TYPE : 64 BIT OPERATING SYSTEM, X-64 BIT PROCESSOR
OS : WINDOWS 11
SOFTWARE
OPEN OFFICE WRITER , OPEN OFFICE BASE.
ABOUT OPENOFFICE BASE
Apache OpenOffice Base is a comprehensive database management software provided by the Apache
Software Foundation.
The free and open-source system offers productivity tools that support companies, businesses, and
professionals. Features include AutoComplete, text frames, linking, and autocorrect dictionary.
Base is a fully featured desktop database management system, designed to meet the needs of a broad
array of users, from tracking a personal CD collection, to producing a corporate monthly departmental
sales reports.
Base offers wizards to help users new to database design (or Base) to create Tables, Queries, Forms
and Reports, along with a set of predefined table definitions for tracking Assets, Customers, Sales
Orders, Invoices and much more.
When a personal use database is all you need, Base offers the full HSQL relational database engine,
configured for single user, with the data stored right in the Base file, as well as native support for
dBase flat files.
For power users in the enterprise, Base delivers native support drivers for a variety of multi-user
database engines: MySQL, Adabas D, MS Access and PostgreSQL. In addition, support for JDBC
and ODBC standard drivers allows you to connect to virtually any database.
IDENTIFYING FIELDS – EMPLOYEE MANAGEMENT SYSTEM
TABLE NAME : Books
COLUMN NAME DATATYPE CONSTRAINTS
BOOK NO. INTEGER PRIMARY KEY
BOOK NAME VARCHAR(15)
AUTHOR VARCHAR(15)
EDITION INTEGER
PUBLISHER VARCHAR(10)
BORROWED STATUS VARCHAR(10)
CREATING TABLE
SYNTAX :
Create table “tablename”(“column1” data type constraint, “column2” datatype, .........,”column data
type);
Creating table – Book Record
create table “Book Record” (“Book no.” integer primary key, “Book Name” varchar(15), “Author”
varchar(15), “Edition” integer,”Publisher” varchar(10), “Borrowed Status”varchar(10));
INSERTING RECORDS
SYNTAX :
Insert into “tablename” (“column1”,”column2”........”column”) values (value1,value2,........valuen);
INSERTING RECORDS – EMPLOYEE TABLE
insert into "Book" ("Book no.","BookName","Author","Edition","Publisher","Borrowed Status")
values (337, 'HarryPotterGob', 'J.K.Rowling',2, ‘Bloomsbury”, ‘Borrowed’);
insert into "Book" ("Book no.","BookName","Author","Edition","Publisher","Borrowed Status")
values (313, 'CityOf Bones', 'Cassandra Clare',3, ‘Walker’, InHouse);
insert into "Book" ("Book no.","BookName","Author","Edition","Publisher","Borrowed Status")
(222, 'CrownOf Wishes', 'Roshani Chokshi',1, ‘Wednesday Books’, ‘Due’);
UPDATING RECORDS
SYNTAX
Update “tablename” set “columnname” =’Value’ where condition;
EMPLOYEE BASIC PAY UPDATION
update "Books" set "Borrowed Status"= InHouse where "BookName."=Crown Of Wishes;
DISPLAYING RECORDS
RUN COMMANDS – SHORTCUT KEY – F5
WHERE CLAUSE
ORDER BY CLAUSE – SORTING
DISPLAYING ALL RECORDS
DISPLAYING PARTICULAR COLUMN
DISPLAYING PARTICULAR RECORD
DISPLAYING RANGE VALUES – BETWEEN
DISPLAYING RECORDS USING PATTERN MATCHING – LIKE OPERATOR
DELETING RECORDS
SYNTAX
Delete from “tablename”;
Or
Delete from “tablename” where condition;
DELETING ONE RECORD FROM TABLE
Delete from "Books" where "Book no."=247;
AFTER DELETING
STEPS TO CREATE FORMS
STEPS TO CREATE REPORTS
OUTPUT SCREENS
FORM OUTPUT
REPORT OUTPUT
BIBILOGRAPHY
1. NCERT BOOK
2. https://www.openoffice.org/product/base.html
3. https://www.thesmbguide.com/apache-openoffice-base-reviews
Thank You,
