𝐈𝐍𝐅𝐎𝐑𝐌𝐀𝐓𝐈𝐎𝐍
TECHNOLOGY
𝓟𝓡𝓐𝓒𝓣𝓘𝓒𝓐𝓛 𝓕𝓘𝓛𝓔
𝐓𝐄𝐂𝐇𝐍𝐎𝐋𝐎𝐆𝐘
Submitted To
Ms. Deepika Loona
Submitted By
Vatsal Gupta
Grade / Sec: 10 / A
Roll No.: 09
Session: 2025 – 2026
Acknowledgement
I would like to express my heartfelt gratitude to all
those who contributed to the successful completion
of this practical file. This work has been
accomplished with the constant support, guidance,
and encouragement I received from various people.
I am deeply thankful to my respected teachers,
whose valuable guidance, patient explanations, and
continuous encouragement helped me understand
complex concepts with clarity. Their invaluable
support has been a constant source of motivation
throughout this project.
I am also sincerely grateful to my parents for their
unwavering encouragement and to my friends for
their moral support. Their involvement, combined
with the dedication of my teacher, has greatly
enhanced my learning and strengthened my
practical knowledge in the field of Information
Technology.
Unit 3: Database Management System
Assignment 1
Objective: Get familiar with different features and
interface of libre office base. Task: Explore the features
and interface of base and write a brief explanation of
what libre office base is and its significance in database
management .
1. Interface: The basic interface of the libre office base
consists of the title bar, menu bar, standard toolbar, and status
bar on the top. And then the database pane which is on the
left side consists of options which allow you to create tables,
queries, forms and reports. Depending on which option is
selected, the respective task pane and object area displaying
the created object appears.
2. Features: LibreOffice base provides many features which
makes database management easier and more efficient. One
of the most useful feature is the availability of wizards for
creating tables, reports, forms etc. which makes database
management easier for new users. Besides that it also
provides the feature of creating of database in design view for
advanced users.
3. Significance of libre office base: LibreOffice Base is a
free and open-source database development and
administration tool for relational database management
systems that is part of the LibreOffice office suite. LibreOffice
Base is designed
to allow users to easily create, access, modify, and view
databases and their data. This is done by providing users with
a graphical user interface that allows users to work with four
main tools: Tables, queries, forms, and reports.
Objective: Create a new database and get familiar with
different database components.
Task: Launch LibreOffice base and create a new database file
named “SCHOOL DB” and save it in a suitable location.
Familiarize yourself with different database components such
as tables, queries, forms and reports.
Assignment 2
Objective: Create a new database and get familiar with different
database components.
Task: Launch LibreOffice base and create a new database file
named “SCHOOL DB” and save it in a suitable location.
Familiarize yourself with different database components such
as tables, queries, forms and reports.
Steps to create a new database:
1. open LibreOffice and then choose the option LibreOffice Base under
create.
2. A database wizard dialogue box appears. In the first step leave every
selection as it is and make sure that you have chose the option create new
database.
3. Click on Next
4. In the next step, choose the option no, do not register the database.
5. And then choose if you want open wizard to create tables or open the
databse for editing.
6. click on finish
7. After clicking on finish the save as dialogue box appears.
8. Enter the name SCHOOL DB in the file name box and
select the location in where you want to save the database and
click on save.
9. The database will then open.
In the opened database there are four components:
1. Tables: Each table of the database is a group of fields. When
creating a table, you also determine the characteristics of each field
within it.
2. Queries: A query in a database is a request for information from a
database management system (DBMS).
3. Forms: Forms offer a method of control-based data input.
4. Reports: A report is a Writer text document that can show your
data in an organized order and formatting.
Assignment 3
Objective: Design tables for a simple school database
Task: Create a table with the following attributes: student ID, name, age grade,
and address. Create the tables in libre office base and define appropriate data
types for each attribute
Solution:
1. Choose option create table in design view.
2. In the design view enter the field names and appropriate field attributes.
3. Set the primary key and save the table.
Assignment 4
Objective: Enter data into the table created before.
Task: Enter sample data into the table that you have created in the
previous task.
Solution:
1. open the table from the database pane by double clicking it .
2. Enter the data in the fields and use the tab keys to move to the next field or
record.
3. Save the data
Assignment 5
Objective: Learn to create and execute queries in LibreOffice Base.
Task: Write and execute a Query to retrieve all student records from the
“students” table. Write and execute a query to retrieve students aged 15
or older.
Solution:
1. Click on use Wizard to create Query
2. In the first step select the students table and then select the required fields from the available
fields and click on next.
3. In the next step select the sorting order if needed. We do not require any sorting order so we
will click on next.
5. In the third step select the search condition. We will choose the option match all of the
following and select age as the field. We will keep the condition “is equal to 15”.
6. Select Detailed summary in the next step and skip steps 5 and 6.
7. In the 7th step assign aliases if needed, we do not need any so we will click on next.
8. In the last step an overview of the query will be shown and also you can select what you
want to proceed after creating the query. We will choose the option „Display Query‟ and then
click on finish.
9. The outcome of the query will be shown as follows.
Assignment 6
Objective: Explore the form design feature and create a sample form.
Task: Create a sample data entry form for the “students” table”. Include fields for
student ID, name, age, grade and address in the form.
1. Select option use wizard to create form
[Link] the Students table and add all the fields. And then click on next .
3. Skip the next 3 steps.
4. In the fourth step, select the arrangement of the controls in your form as per
your requirement.
5. In the sixth step select the data entry mode. We will select the option „the
form is to display all data‟ to display all the entries in the form as well as any
new entry.
6. In the next step apply the styles of your form as your need and click on next.
7. In the last step, set the name of the form and select what you want to do after the form
is created. We have selected “work with the form‟ option.
8. The outcome of the form will look like the following
Assignment 7
Objective: Learn to generate reports in LibreOffice Base.
Task: Create a basic report to display all student records from the “students”
table. Customize the report layout and formatting as per your reference.
1. Choose option use wizard to create report.
2. In the first step, select the Students table created earlier and add all the fields to
the report. Click on next.
3. In the next step we can label the fields which is similar to assigning aliases, we do not
require any labels so we will click on next. And we will also skip the next step as we do
not require any grouping.
4. In the fourth step, we can sort the data. We want to sort the names by ascending order.
So we will select the name field and choose the ascending option.
5. In the next step choose the layout and orientation you want. We have selected
the layout as „columnar, single-column‟ and orientation as portrait.
6. In the last step, give your report a title and choose whether you want you report to be
static or dynamic. The default option is dynamic which means the data will
automatically change if it is modified in the table. We will choose the option „dynamic
report‟ and „create report now‟.
6. The outcome of the report will be the following;
Assignment 8
Objective: Understand the concept of relationships in database design.
Task: Create a new table named “courses” with attributes: Course ID, Course name and
Instructor ID.
1. Create a new table „courses‟ by following the steps that were done before by adding
fields (course Id, course name and Instructor name), data records, setting the primary
key as Course Id and saving it. The table will look like this:
2. Create a new field in the students table of Course Id and add data records to it.
3. Now, click on tools on the menu bar and then relationships .
4. Now add both the tables „Student table‟ and „courses‟ from the add tables dialogue
box.
5. Now match the attribute which is common in both tables and a primary key in one of
the tables i.e. Course Id. A line joining the attribute „course Id‟ will be displayed
showing that the relationship has been established.
Assignment 9
Objective: Write and execute a query to retrieve data from related terms
Task: 1. Write and execute query to retrieve names of students along the courses they are
enrolled in.
2. Write a query to retrieve names of instructors along with courses they are teaching.
For retrieving names of students and their courses:
1. Click on „ create query in design view‟
2. Select students and courses tables
3. From them, add name and course name attributes and do not apply any criterion.
4. Press F5 and the query will be created
To retrieve names of Instructors and their courses:
1. Click on use wizard to create query
2. Add table „Courses‟ and add fields „Instructor names‟ and „Course name.‟
3. Follow the steps without applying any search condition and then click on Finish.
4. The outcome will be as the following;
Assignment 10
Objective: Explore advanced query features in LibreOffice base.
Task: (1) Write and executive a query to find the average age of all students.
(2) Write and execute a query to identify students who are enrolled in more than one Course.
Solution:
(1) To find average age of students:
1. Choose „create query in design view‟
2. Then add table „Students‟ and add field „age‟
3. Next, in the function choose Average from the drop down menu.
5. Click on F5. The result will be shown:
(2) To identify students who are enrolled in more than one Course:
1. Click on „create query in design view‟.
2. Add tables „students‟ and „courses‟ and from the tables, add the fields „student ID‟,
„name‟, „course ID‟ and „course name‟.
3. Fill the criterion in the course name as >1.
4. Click F5 to run the query and save the query. The output will look like this since there are no
students who are enrolled in more than 1 course.
Assignment 11
Objective: (1) Enhance the data entry form created earlier with navigation buttons (eg-
Next, Previous, First, Last) for easy navigation between records.
(2) Implement validation rules to ensure data integrity (eg- Age should be a positive
integer).
Solution:
(1) [Link] click on the form and select edit option from the drop down menu.
2. The form will open in design view. From the forms control toolbar (on the left), choose the
navigation bar icon.
3. The mouse pointer will change into a cross. Now drag the cross and a navigation bar will be
inserted. Save the changes and the output will look like this:
(2) [Link] the „students‟ in the design view and click on the form tab on the menu bar. Select
„form properties‟ from the drop down list.
2. The form properties dialogue box will open. Select the data tab and then click on the three
dots next to filter... label.
3. Now, add the field names for which you want to add validation rules as well as specify the
criterion. You can add
up to 3 fields.
4. Click on OK and now the validation rules will be applied ensuring that no invalid data is
entered at the time of data entry itself.