UNIT-3: Database Management System using LibreOffice Base

Ch:8 Introduction to Database Management System

Q1. Define the terms

(a) Database

(b) Data redundancy

(c) Report

Ans.

Database: A database is a collection of logically related data items stored in an organised manner

Data redundancy: Duplication of record is called data redundancy

Report: A report is the formatted result of query which contain data required for decision making and
analysis

Q2. Give one point of difference between:

a) Data and information

b) Form and Query

c) Network and hierarchical data model

Ans:

a) Data and information

Raw facts and figures in called data

Processed data in called information

b) Form and Query

Form: A form is a feature of a database using which we can enter data in table in an easy and user friendly
manner

Query: A query is used to retrieve the desired information from the database

c) Network and hierarchical data model

Network Data Model: In Network Data model, multiple records are linked to same master file.

Hierarchical Data Model: All the records in this model are inked to each other at various levels, thereby
forming a hierarchy

Q3. Give any four advantages of a DBMS.

Ans. Advantages of a DBMS are:

1
1) Organized Storage: The data in the database is stored in an organised manner, so that retrieval of the
required data is fast and accurate.

2) Data Analysis: A database helps in analysis of data based on certain criteria.

3) Reduces Data Redundancy: Database reduces data redundancy (duplication of data)

4 Sharing of Data: In a database, the users of the database can share the data among themselves.

5) Data Integrity: Data Integrity means that the data is accurate and consistent in the database

8) Data Security: Database provides data security as only authorized users are allowed to access the
database and their identity are authenticated by using a username and password.

7) Privacy: The privacy rule in a database states that only the authorized users can access a database
according to its privacy constraints.

8) Backup and Recovery: Database Management System automatically takes care of backup and recovery

4. Consider the table given below and answer the questions:

(a) Name the fields in the given table.

Ans. Fields in the table are

1. Book_Id

2. Book Name

3. Author Name

4. Price

5. Publisher

(b) Which field should be made the primary key?

Ans. Book Id

(c) Is there any alternate key in the table?

Ans. Book Name

(d) How is primary key different from foreign key? Explain with example.

2
Ch:9 Starting with LibreOffice Base
D. Answer the given questions
1. Differentiate between:

(a) Memo and Varchar data type

(b) Number and Decimal data type

(c) Design View and Datasheet view of a table

3
2. Name the menu items present on the Base User Interface.
Ans:
1. File
2. Edit
3. View
4. Insert
5. Tools
6. Window
7. Help

3. Label the components – Title Bar, Database Pane, Tasks Pane, Status Bar of the
LibreOffice Base User Interface.

4
Q4. How can we define a primary key in a table?
Ans. A Primary key is a field which is unique for each and every record in
a table. To make a particular field as the primary key, place the mouse
pointer before the field name, and right click. A pop up menu appears
and Select the Primary Key option. A key icon appears before the field
name indicating that it is a primary key.
Q5. Write steps to sort the table in descending order of primary key.
Ans. Steps to sort the table in descending order of primary key are:
1. Open the table in datasheet view and select the primary key on which
you want to sort.
2. From the tool bar click Sort Descending icon to sort in descending
order.
3. The table will be sorted in descending order of primary key.
Q6. What is the use of navigation box with respect to tables in a
database?
Ans. Navigation box is used to navigate (move) through various records
of the table.
The various components of Navigation Box are as follows:
Record Selector Box - This is the text box where the currently active
record number is displayed. We may enter the record number that we
want to see in this text box.
Navigation Buttons - These are used to scroll vertically in the table.
• Press button to move to the first record.
• Press and to move to the next and previous records respectively.
• Press button to move to the last record.

5
Ch:10 Working with Multiple
Tables
Answer the following questions.
Q1. Give any two advantages of relating a table in a database.
Ans:
 Advantages of relating a table in a database are:
 A relationship can help prevent data redundancy.
 Creating relationships between tables restricts the user from entering invalid
data in the referenced fields
 Any updation in the master table is automatically reflected in the transaction
tables.
Q2. How is redundancy or inconsistency controlled in a database? Explain with an
example.
Ans:
Relations are set up between the tables to control data redundancy and
inconsistency. This helps in proper maintenance of a database by checking that
neither the records are duplicated nor there is variable data value for a particular
field in two or more tables. If you set up relations between tables, then adding or
updating a record in one table reflect the changes in all related tables.
[Link] referential integrity. Who maintains referential integrity in a database?
Ans: Referential integrity is used to maintain accuracy and consistency of data in a
relationship. According to the principle of referential integrity, no unmatched
foreign key values should exist in the database. The referential integrity in a
database is maintained by DBMS.
Q4. Differentiate between one-to-one relationship and one to many relationships.
Give suitable examples to explain your answer.
Ans:
One- To – One Relationship

6
In this type of relationship, one specific record of a master table has one and only
one corresponding record in the transaction table.

For Example, the record for Admission No in the master table (Student Detail) will
have only one corresponding record of same value of Admission No in the
transaction table of Student Result. This is because no two students will be given
same admission number.
One-To-Many Relationship
In this type of relationship, one specific record of the master table has more than
one corresponding records in related transaction table.

For Example, a teacher can teach multiple students or multiple classes. So we can say that there is a one to many
relationship between a teacher and class or Teacher and student.

7
Q5. Explain many to many relationship with an example.
Ans: In this type of relationship, there will be multiple records in the master table
that correspond to multiple records in the transaction table as well. For example, a
teacher in a school may hold multiple responsibilities such as class teacher, an
activity in charge or examination in charge. For each responsibility the teacher
might be attached with multiple students. So, this type of relationship will be many
to many relationships. Similarly, a shopkeeper may sell multiple products to
multiple customers. So, many – to- many relationships exist between a product
and a customer.

Ch:11 Queries in Base

Q1. Define a query? What is the need of creating a query in a database?
Query is used to retrieve the data from the database as per your requirement by
providing the desired specifications. Depending upon given specifications, the
specific records are searched from the database and then displayed in the desired
manner.

Need of creating a query in a database: As, the number of records increases,

finding the desired information in a database becomes difficult. By using queries,
we can retrieve the data without going individually through each record in the
table(s) and also display them in desired format.
Q2. Rearrange the steps given below so as to create a query using a wizard.
a) Give Alias
b) Select the fields
c) Set the criterion
d) Set the sorting order
e) Give table name
Ans:
a) Give table name, b) select the fields c) Set the sorting order d) Set the criterion
e) Give Alias

8
Q3. What all information is seen in the overview (last step) of the Query
wizard?
Ans:
The last step of the Query wizard displays the entire Overview of the query. It
includes the following:

 Name of the Query - If desired, type the new name in the textbox.
 The action to be performed after the wizard finishes. By default
Display Query option will be selected. Click and select the Modify Query
radio button if the query has to be edited in the Design view
 Complete detail of the query: This section contains a summary about the
query that has been created.
[Link] is the use of Alias row in the Design grid of the Query Design
window?
Ans: Alias row is used to display meaningful names in the output. An Alias is an
alternative name for a field in a query.

Q5: Name any four mathematical functions that can be applied to

numerical data in a query.
Ans: Mathematical functions that can be applied to numerical data in a query are:
Count, Sum, Minimum, Maximum, and Average

Q5. Name the three ways of creating a query in LibreOffice Base?

Ans.
1. Create query in Design view
2. Create query using Wizard
3. Create query in SQL view

9
Ch:12 Forms and Reports
D. Answer the following questions
1. Give one difference between a form and a report.

Q2. What is a field control with respect to forms?

Ans:
A form contains field controls arranged in a presentable and user-
friendly manner. Each field control consists of a
Label and the field value text box
A label is a piece of text that specifies the data that should be entered
inthe field value text box.
A field value textbox is linked to the respective field in the table.
Q3. Which tool on the Forms Record toolbar is used to insert text on the
form?
Ans: Text Box Tool is used to insert text on the form.
Q4. Name the two ways to create a form in LibreOffice Base.
Ans: There are two ways to create a form
1. Using a Wizard
2. Using the Design View

10
Q5. What is the difference between a static and a dynamic report?

Static Report Dynamic Report

Static Report are the fixed Dynamic Report updates
snapshot of data at a specific time. automatically based on database
changes.
In Static Report, as the field values In Dynamic Report, as the field
in the base table or query changes, values in the base table or query
the report will not change changes, the report will also
automatically. change automatically.
It contains a defined set of data. It reflects current state of the
database.
It requires manual re-running or It gets updated automatically
editing. based on user interaction.
This is not the default value of This is the default value of report.
report.

Q6. Write the function of Forms Controls toolbar and Records toolbar.
Forms Control Toolbar:
This toolbar contains various controls that can be added to the form.
Example: Adding a calendar to a date field, adding text to the form,
adding a new record using a form.
Records Toolbar:
The Records toolbar contains the navigation control buttons in the
extreme left. With the help of these buttons, we can traverse and view

11
the records in the file. As we move from one record to another, the
record number in the record text boxes changes.

12