INDEX

1. Acknowledgement.

2. Introduction of the Project.

3. Objective of Project.

4. Project Creation Steps:

 Table Creation

 Form Creation

 Report Creation

5. Future Scope, Limitation of Project.

6. Conclusion and References/Bibliography.

 Asian Christian High School
(Affiliated to CBSE; Affln. No.: 1930159; School Code: 55109)
Jeemangalam, Bagalur P.O., Hosur, Krishnagiri Dt.
Tamil Nadu-635103, Ph.: 04344-255800/807/822/831
E-mail: achs@acaindia.org
Website: www.achs-india.org

Bonafide Certificate
Certified to be the bonafide record of Information Technology project work

done on __________________________________________________

by Master/Miss_____________________________________________

of Class X at Asian Christian High School, Hosur, during the year 2024-’25.

Submitted as part of SSE (Practical) done at Asian Christian High School.

Name of the Candidate: ____________________________

Roll No: ______________________________________

School Seal Date of Examination: _____________________________

Internal Examiner Principal Head of the Department

 Asian Christian High School
(Affiliated to CBSE; Affln. No.: 1930159; School Code: 55109)
Jeemangalam, Bagalur P.O., Hosur, Krishnagiri Dt.
Tamil Nadu-635103, Ph.: 04344-255800/807/822/831
E-mail: achs@acaindia.org
Website: www.achs-india.org

Bonafide Certificate
Certified to be the bonafide record of Information Technology practical work done

by Master/Miss__________________________________________of

Class X at Asian Christian High School, Hosur, during the year 2024-’25.

Submitted as part of SSE (Practical) done at Asian Christian High School.

Name of the Candidate: ____________________________

Roll No: ______________________________________

School Seal Date of Examination: _____________________________

Internal Examiner Principal Head of the Department

 ACKNOWLEDGEMENT

This project report would be inconclusive without acknowledging the services of

those helping hands in the entire process of the project presentation.
With a grateful heart I acknowledge the presence of the Omnipotent behind the
endeavours concerning this project.
At the outset, I express my deep sense of obligation to Mr. Sijumon K.G., Principal
of Asian Christian High School, Jeemangalam, Hosur, for his unrelenting
motivation, guidance and support.
Mrs. Y. S Sangeetha, our dear teacher and mentor for Information Technology,
deserves whole-hearted appreciation for her great inspiration and continuous
guidance in completing this project.
A special mention has to be made of my friends for all the support and help rendered
towards the fulfillment of the project.
Special thanks to my parents for the cooperation and support which helped me in
materializing this project.
 INTRODUCTION
A database management system is a software package with computer
programs that controls the creation, maintenance, and use of a database. It
allows organizations to conveniently develop databases for various
applications.
A database is an integrated collection of data records, files, and other
objects. A DBMS allows different user application programs to concurrently
access the same database.
Well known DBMSs include Oracle, IBM DB2, Microsoft SQL Server, Microsoft
Access, PostgreSQL, MySQL, FoxPro, and SQLite.
Data can be organized into two types:
• Flat File: Data is stored in a single table. Usually suitable for less amount
of data.
• Relational: Data is stored in multiple tables and the tables are linked using
a common field. Relational is suitable for medium to large amount of data
Database servers are dedicated computers that hold the actual databases
and run only the DBMS and related software. Typically databases available
on the database servers are accessed through command line or graphic user
interface tools referred to as Frontends; database servers are referred to as
Back-ends. Such type of data access is referred to as a client-server model
There are some key features of a database:
1. A database can have one or many tables. An address book example is a
very simple one, in real world there are many more details involved. A big
company would have in its database, one table for its products, one table for
its suppliers, one table for its customer details, one for orders received and
maybe many others.
2. Each table in a database contains information about one type of item. So,
a database is a container that holds tables and other objects and manages
how they can be used.
3. Another very important thing to remember is that when we put in
information, we may have people with the same name (there can be more
than one Charu Arora) or the same address (members of a family). But
when creating a database an important feature is record uniqueness in every
table. it is important to be able to distinguish between different items having
duplicate values. Uniqueness helps to avoid accidental duplication of records
caused by user or computer error. This can be achieved by using some
 number or value that uniquely identifies a record. If such a unique value
does not exist in your fields, as the database designer, we can create a
special additional field in a table where unique numbers or values can be
assigned for each new entry. Therefore, every table has a key field which
ensures that there are 100% unique values throughout the database.
4. Every database table should have one or more fields designated as key.
You can assign a unique value to this key for differentiating records that may
have similar names or addresses.
In the RDBMS data can be integrated using keys. These are Primary Key,
Composite Primary Key, and Foreign Key.

 Primary Key – is a column or group of columns in a table that

uniquely identify every row in that table.
 Foreign Key – is a column that creates a relationship between two
tables. The purpose of foreign keys is to maintain data
integrity and allow navigation between two different
instances of an entity.
 Composite Key – is a combination of two or more columns that uniquely
identify rows in a table. The combination of columns guarantees
uniqueness, though individual uniqueness is not guaranteed.

Base provides these important features:

 Database creation. New embedded databases can be created using

an embedded HSQLDB database engine.

 Connection to other data sources. Connections can be made to

many widely employed database engines and other data sources, including
spreadsheets, text documents, and address books. External data sources
must be created and properly configured before Base can make such a
connection.

 Tables. In many databases data is organized in tables with rows and

columns. In general terms, the columns represent categories of data, while
the rows represent individual instances. Tables in a relational database are
connected by relationships and these allow the data to be shared between
tables, eliminating data redundancy.
 Forms. A form is a user-friendly window that is used to view and edit
the data in the tables of a database. The form helps the user to enter data
quickly and accurately, ensuring that data updates are implemented
consistently across all affected tables within the database.

 Queries. A query retrieves data from the database, calculates results

where necessary, and filters records of interest from a large volume of data.
Queries can bring together data from one or more tables, sometimes via
another query or view.

 Views. For some connected database types, it is possible to create

database views. A view is a read-only, virtual table containing rows and
columns. It is constructed using a query that gathers data physically stored
in one or more “real” tables. Most queries created with Base are stored in
the Base document, but a view’s underlying query is stored within the
database engine.

 Reports. A report is used to extract key data from the database and
present it in an easy to read format, often for consumption by people (such
as decision makers) not otherwise directly involved with the database.

 Linking. Databases can be linked to other documents and external

forms, including use in mail merge.

 Filtering and searching. Filters are applied to limit the volume of

data displayed, focusing attention on records that match specific filter
criteria. Searching is used to locate records of particular interest that match
specific search criteria.

 Macros. LibreOffice Basic and Python macros can be used to simplify

running repetitive tasks preventing input errors, increase functionality, and
improve usability. LibreOffice includes the ScriptForge and Access2Base
macro libraries, which provide an extensive collection of resources that can
be invoked from Basic or Python scripts.
Objective Of Project

The goal of the project is to use Libre Office's Design view to develop a

student database.

The wizard approach will be used to construct a form on the student

database.

The project involves creating the database and forms step-by-step.

 Project Creation Steps:-

Using the Design View to Create a Table

1. Step 1: Select fields. We will use the Expenses sample table in the Business
category to select the fields we need for our first table. ...
2. Step 2: Set field types and formats. In this step you give the fields their
properties.
3. Step 3: Set primary key.
4. Step 4: Create the table.







FORMS
A form provides the user a systematic way of storing information into the
database. It is an interface in a user specified layout that lets users to
view, enter, and change data directly in database objects such as tables.
To create a Form use the following steps:

1. Click Use Wizard to Create Form.

2. Select my query from the Tables or queries drop-down list
3. Click >> to add all columns, then click Next >
4. There is no of subforms, so click Next >
5. Choose the second option (“Columnar - Labels on Top”) option for the
main form arrangement, then click Next >
6. Select This form is to display all data and select all 3 checkboxes to
prevent data modification, then click Next >
7. For the form name, enter whatever name, then click Finish
 REPORTS
Reports are used to present data in a way that makes it readily understood by
people without knowledge of the database. Reports can:
 Present data in easy-to-read tables
 Create charts for displaying data
 Make it possible to use data for printing labels
 Produce form letters such as bills, recall notices, or notifications to people
joining or leaving an association
To create a report requires careful preparatory work on the underlying database.
Unlike a form, a report cannot include subreports and thus incorporate additional
data sources. Neither can a report present different data elements than those
that are available in the underlying data source, as a form can do using list
boxes.
Reports are best prepared using queries. In this way all variables can be
determined. In particular, if sorting within the report is required, always use a
query that makes provision for sorting. This means that queries in direct SQL
mode should be avoided under these conditions. If we must use a query of this
type in our database, we can carry out the sort by first creating a view from the
query. Such a view can always be sorted and filtered using the graphical user
interface (GUI) of Base.

To create a Report use the following steps:

Step-1: Click on Report from left pane.
Step-2: Click on Use Wizard to Create Report.
Step-3: The 1st step Field selection.
Step-4: Click on Next button. 2nd step is Labelling fields get selected.
Step-5: Label the fields as you want.
Step-6: Click on Next button. 3rd step Grouping gets selected.
Step-7: Enter the criteria to group the fields by.
Step-8: Click on Next button. 4th step Sort options gets selected.
Step-9: Enter the required sort options.
Step-10: Click on Next button. 5th step Choose layout.
Step-11: Choose the layout for the report.
Step-12: Click on Next button. 6th step Create report gets selected.
Step-13: Create Report by giving an appropriate title to the report.
Step-14: Click on Finish button. The report is created.
1.

2.
3.

4.
5.

6.
7.

8.

--------------------------------------------------------------------------------------------------------------------------------
Future Scope, Limitation of Project:-
 In future our system can include good backup and restore facility.

 System is so much flexible so in future can increase easily and new

models can be added easily.

 Student admission number can also be added.

 To make the student result management effective, Tootal can be also

included along with Grade as a new field.

 The project covers only five records.

 The Report layout can be generated in different ways.

 The system works slow.

Conclusion and References/Bibliography:
The advantages of LibreOffice over other office suites:

•No licensing fees. LibreOffice is free for anyone to use and

distribute at no cost. Many features that are available as extra cost

add-ins in other office suites (like PDF export) are free with

LibreOffice. There are no hidden charges now or in the future.

•Open source. You can distribute, copy, and modify the software as

much as we wish, in accordance with the LibreOffice Open Source

licenses.

•Cross-platform. LibreOffice runs on several hardware architectures

and under multiple operating systems, such as Microsoft Windows, Mac

OS X and Linux.

•Extensive language support. The LibreOffice user interface,

including spelling, hyphenation, and thesaurus dictionaries, is available

in over 100 languages and dialects. LibreOffice also provides support

for both Complex Text Layout (CTL) and Right to Left (RTL) layout

languages (such as Urdu, Hebrew, and Arabic).

•Consistent user interface. All the components have a similar “look

and feel,” making them easy to use and master.

•Integration. The components of LibreOffice are well integrated with

one another.

 –All the components share a common spelling checker and other

tools, which are used consistently across the suite. For example,
 the drawing tools available in Writer are also found in Calc, with

similar but enhanced versions in Impress and Draw.

 –We do not need to know which application was used to create a

particular file. For example, we can open a Draw file from Writer.

•Granularity. Usually, if we change an option, it affects all

components. However, LibreOffice options can be set at a component

level or even at document level.

•File compatibility. In addition to its native OpenDocument formats,

LibreOffice includes support for opening and saving files in many

common formats including Microsoft Office, HTML, XML, WordPerfect,

Lotus 1-2-3, and PDF.

•No vendor lock-in. LibreOffice uses OpenDocument, an XML

(eXtensible Markup Language) file format developed as an industry

standard by OASIS (Organization for the Advancement of Structured

Information Standards). These files can easily be unzipped and read

by any text editor, and their framework is open and published.

LibreOffice Base is extremely user friendly and it allows users to easily

create and manage data. The best part about the data manager is that it's

free! It's similar to Microsoft Access, but it can be used on macOS and

Windows systems.
"Database System Concepts" by Abraham Silberschatz, Henry F. Korth, and
S. Sudarshan.
"Database Management Systems" by Raghu Ramakrishnan and Johannes
Gehrke.
"Fundamentals of Database Systems" by Ramez Elmasri and Shamkant B.
Navathe.
"Database Management Systems" by Raghu Ramakrishnan and Johannes
Gehrke.
DomeStIc Data Entry operator Textbook for Class X.