It-402 Project File
It-402 Project File
It-402 Project File
pg. 1
INTRODUCTION
The impact of computers and internet, on our lives today is probably much more than we really know.
Getting information and quickly turning it into a product that consumers want is an essential key to
staying in business and all of this is done nowadays using computers and applications or information
systems. And the information systems will continue to change businesses and the way we live. Many
corporate leaders are using technology to manage every aspect of their organization, from product
creation to customer service. It has brought evolution in almost every field, it changed the ways of
teaching, administration of activities such as e-learning, e-library and online portals where teachers
and students communicate and sharing of information has never been better.
This project is all about creating a database management system for School staff members. To explain
how to use a database, we will create one for Employee Management System. In the process, it will
be explaining how a database work.
I have taken a case study for the school to maintain the staff details in an organized way. I have
selected 2 tables to do this project work.
1. Departments
2. Staff
pg. 2
OBJECTIVE AND SCOPE OF THE PROJECT
My consideration while developing this project was to achieve the following goals:-
1. This project is for any school. Which provide staff management facility.
2. It also saves the valuable time of the admins and lots of paper works.
3. This will save lots of effort of the user. He/She is able to manage lots of information after using
this project and also able for seeing in different angles.
4. User can manage all the records very easily and can generate all kinds of reports for management.
pg. 3
HARDWARE AND SOFTWARE SPECIFICATIONS
Hardware:
Software:
➢ At least 650 MB available disk space for a default install (including a JRE) via download.
After installation files.
➢ Operating System(OS): Microsoft Windows
pg. 4
ABOUT LIBREOFFICE
LibreOffice is a free and open-source office productivity software suite, a project of The Document
Foundation (TDF). It was forked in 2010 from OpenOffice.org, an open-sourced version of the
earlier StarOffice. It consists of programs for word processing; creating and editing spreadsheets,
slideshows, diagrams, and drawings; working with databases; and composing mathematical formulae.
It is available in 120 languages. TDF does not provide support for LibreOffice, but enterprise-focused
editions are available from companies in the ecosystem.
LibreOffice uses the OpenDocument standard as its native file format, but supports formats of most
other major office suites, including Microsoft Office, through a variety of import and export filters.
It is available for a variety of computing platforms, with official support for Microsoft
Windows, macOS, and Linux and community builds for many other platforms. Ecosystem
partner Collabora uses LibreOffice upstream code and provides apps for Android, iOS, iPadOS,
and ChromeOS. LibreOffice is the default office suite of the most popular Linux distributions.
LibreOffice Online is an online office suite that includes the applications Writer, Calc, Impress, draw,
math and base, and provides an upstream for projects such as commercial Collabora Online.
It is the most actively developed free and open-source office suite, with approximately 50 times the
development activity of Apache OpenOffice, the other major descendant of OpenOffice.org, in 2015.
pg. 5
MAIN COMPONENTS OF EMPLOYEE MANAGEMENT
SYSTEM
1. Departments
2. Staff
To prepare a summarized report for the case I have used the following concepts of LibreOffice base.
1. Create Table
2. Insert data
3. Operations on tables
4. Queries
5. Forms
6. Reports
1. Department Table
pg. 6
2. Emp Table
Creating Database
Start the LibreOffice Base as per the standard process of starting the application in Windows or Linux.
In Windows,
1. Click Start > LibreOffice or double click on the LibreOffice icon on the desktop or Select Base
Database option from the bottom left panel.
3. we would not like to register, so we click and select the radio button with option, ‘No, do not
register the database’.
4. Select open the database for editing or want to create a table using the wizard.
5. Click on Finish.
pg. 7
pg. 8
Creating a Table
Once the database is created, we can start working with objects of the database. First and foremost is
the creation of the table and then entering data in the table. A table in LibreOffice Base can be created
using a wizard or using the Design view.
Step 1. Type the first field name (EmpId) in the Field Name column. Press Tab key. The cursor
moves to the second column i.e. Field Type.
pg. 9
Step 2. The Field Type column contains a list box. As you click on the down arrow, it appears and
we can select the desired data type from the list box. Select the
datatype (Varchar).
Step 3. Observe that certain properties appear in the Field Properties Pane as the data type is selected.
Some of the properties are Entry required, Length, Default value, Format example. Set the desired
properties for the entered field.
Step 4. Press Tab key to move to the next column. Add any description if
you want in the third column.
Step 5. Once the properties for the field are set, press Tab key to move to
next row.
Step 6. Enter the next field by repeating steps 1,2 and 3. Repeat the process for adding all fields in
the table. Fig. shows the Design View with all the fields.
pg. 10
2. Creating Department Table
pg. 11
Entering Data in a Table
To enter data in the table, double click on the created table Events icon in the Tables Object Area on
the database screen. Alternatively, we can open the table by right clicking on the desired table and
then selecting the Open option from the drop down menu. The datasheet view of the table will
appear as shown in Figure. It displays the field names in the top row. These fields are displayed in
the same order as they were added while creating the table.
pg. 12
Creating Relationships between Tables
To set up relationship between these tables follow the following steps.
Step 1. From main menu of LibreOffice Base, click on Tools > Relationships…
Step 2. The Relationship Design screen will appear as shown in Figure below. In the middle of the
screen there is Add Tables dialog box. Both the tables are listed in the dialog box.
Step 3. In the Add Tables dialog box, click Department table and then click Add button. Similarly
add Employee table to the Relationship Area.
Step 4. Click Close button to close the Add Tables dialog box. Observe that the tables Department
and Employee table added to the Relationship Area along with all its field list as shown in Figure.
Step 5. As we can see Dep_ID is the common field in the two tables. Hence it will be used to set a
relationship between the two tables. To create a relation between the two tables, we just have to drag
the common field Dep_ID from the Department table and drop it in Employee table. A line connecting
both the tables with the common field (Dep_ID) appears on the screen as shown in Figure.
The line is labeled as ‘l’ on the primary key side and as ‘n’ on the foreign key side. Hence the Dep_ID
from Department table as primary key will have unique values and is called referenced field. On the
other hand, in the Employee table, the values of Dep_ID might be repeated. Here it is known as
referencing field.
pg. 13
Creating a Form Using a Wizard
This is the simplest way to create a form. To explain how to create a form using a wizard, we will get
back to the Sports Day database created in the previous chapters. To create a form using wizard,
follow the following steps.
Step 1. Open the Sports Day database created in LibreOffice, and click the Form icon on the
Database Pane.
pg. 14
Click the option Use Wizard to Create Form… on the Tasks Pane. The Form wizard will open
along with a blank database form in design view in the background.
Step 2. The step 1 of the wizard is to select the tables or queries for which the form has to be created.
As we are creating a form for Employee table, select Events table from “Tables and queries” list box.
Step 3. After selecting the Employee table, all the fields of the Employee table will be listed in the
Available Fields list box.
pg. 15
Step 4. As we require all the fields to appear in the Form, shift all the fields of Employee table from
Available Fields list box to Fields in the Form list box using >> button. Observe that, all the fields
are shifted to Fields in the Form list box. Click on Next button to move forward.
Step 5. The second step consists of setting up a subform, i.e. a form within a form. You need to check
the checkbox “Add Subform” to add the subform. Since we do not want to set up any subform, click
Next button to proceed further.
Step 6. The wizard skips the next two steps that relate to the subform and moves on to step 5. This
step arrange controls i.e. to set up the design of the form. Observe that, by default, all controls will
be left aligned. Click Right Align radio button to align the controls from the right side of the form.
As mentioned before, a field control consists of two parts – label and the field value text box. So in
this step we arrange the label and field value text boxes as we want them to be visible on the screen.
pg. 16
Step 7. Click Next button.
Step 8. The step 6 of the wizard asks whether the form will be used for displaying data, entering data
or both. As we go with the default settings, so we click Next button.
Step 9. The next step is to apply styles to the form being created. We can select the desired background
colour and border type of the field value text boxes. Observe, by default the border of the field text
value is displayed in 3D look. We can select the options No Border or Flat if required.
pg. 17
Step 10. Click Next button.
Step 11. The next step is to set the name of the form. By default the name of the form is same as the
name of the table. Click in the textbox and type a different name if desired, say EmployeeForm. In
the same step, by default, the radio button with the option Work with the form is selected. If you
wish to modify the form after the wizard finishes, click Modify the form option.
Step 12. Click Finish button. The form with the first record will be displayed on the screen in a
separate window. Also, observe that, the name of the form, EmployeeForm will appear in the Object
Area of LibreOffice User Interface window.
pg. 18
Reports
A report is another useful feature of a database management system. We have seen that the records
that have been extracted using a query are displayed in a simple row and column format. Instead,
using a report we can present the retrieved data in an attractive and customized manner. We can create
a report based on a table or a query or both. Preferably, if a report has to be generated from multiple
tables, a query should be created first and then that query can be used to generate the report.
Let us create a report using the table Employee from the Employee Management System database.
Follow the following steps to create a report.
Step 1. In the LibreOffice Base User Interface, click on the Reports icon in the Database Pane.
Step 2. From the Tasks Pane, click Use Wizard to Create Report… option.
Step 3. The Report wizard along with two other windows will be displayed. One of the window is
Report Builder window and the other is Add Field dialog box. We will confine our study to the
wizard.
Step 4. The first step of wizard is to select the table and the corresponding fields that we want to
display in our report. From the Tables or Queries list box, select the table Employee.
Step 5. All the fields of the Events table will be listed in the Available Fields list box. Click >> button
to shift all the fields to Fields in report list box. Fig. shows the Fields in report list box after shifting.
Step 6. Click on the Next button. The next step is to label the fields. By default, the column headers
will be displayed as labels or column headers for the field values. As fields names are generally
shortened, to change to more self-explanatory names, type the new names in the respective text boxes.
Step 7. Click on the Next button. The next step is to group the data based on any of the fields in the
report. Since we do not want to group as of now, click on the Next button.
Step 8. The fourth step is to set the Sort options. If the data to be displayed in the report has to be
sorted in either ascending or descending order of a particular field, specify the field and sorting order
in this step. Say, for example, select the field Dep_ID. The radio button for Ascending is already
selected. Select Descending radio button to display the records in descending order.
Step 9. Click on the Next button to move on to the next step in which the layout of the report will be
selected.
Step 10. A layout is the manner in which the labels, field values and titles will be displayed in the
report. Out of various Layout options given, choose the desired layout, say Tabular and also the layout
pg. 19
of headers and footers (Default). You may also choose the orientation option Landscape or Portrait
in this step.
pg. 20
References
1. Domestic Data Entry Operator (IT 402 CBSE Study Material)
2. https://cbseacademic.nic.in/
3. LibreOffice.org
4. www.tutorialaicsip.com
5. www.techmint.com
pg. 21