Chapter 8: Introduction to Database Management System

A. Multiple Choice Questions:

1. (b) Telephone directory

2. (c) MS Excel
3. (b) Database Management System
4. (a) Relational Data Model
5. (b) Attributes
6. (c) Record
7. (d) All of the above
8. (a) Primary key
9. (c) Form
10. (a) Query

B. True or False:

1. A database can be organized. False

2. Data is the collection of raw facts. True

3. A table can be created without a primary key. True

4. Two tables can be related in a network data model. True

5. MS Access is an example of a database. True

C. Fill in the Blanks:

1. The raw facts constitute data.

2. An entity is a real-world object about which information is to be stored in a database.

3. The output of a query may be displayed in the form of a report.

4. The data values for all the fields related to a person or object are called a record.

5. All the field values that are eligible to be the primary key are the candidate keys for that table.

D. Answer the Following Questions:

1. Define the terms:

(a) Database: A structured collection of data stored and accessed electronically, usually managed by a
DBMS.

(b) Data Redundancy: The unnecessary repetition of data in a database, which can lead to inefficiency
and storage issues.

(c) Report: A formatted and organized presentation of data retrieved from a database, often used for
analysis or decision-making.

2. Give one point of difference between:

 (a) Data vs. Information: Data refers to raw, unprocessed facts, whereas information is data that has
been processed and interpreted to have meaning.

(b) Form vs. Query: A form is a user-friendly interface for entering or displaying data, while a query is
a request made to the database to retrieve specific data.

(c) Network vs. Hierarchical Data Model: In a network data model, each record can have multiple
parent and child records, while in a hierarchical data model, records have a tree-like structure with
a single parent for each child.

3. Give any four advantages of a DBMS.

o Reduces data redundancy

o Ensures data consistency
o Facilitates data sharing among multiple users
o Enhances data security and privacy

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

Book_Id Book Name Author Name Price Publisher

F001 Pride and Prejudice Jane Austen 550 ABC

S004 Amazing Astronomy E. Shane 1050 ABC

C005 IT and Mankind MHA Diwaan 2500 HYM

5. (a) Fields in the given table: Book_Id, Book Name, Author Name, Price, Publisher
(b) Primary key: Book_Id
(c) Is there any alternate key? Yes, Book Name can be considered an alternate key.
(d) Difference between primary key and foreign key:

A primary key uniquely identifies records in a table, whereas a foreign key is a field in one table that
links to the primary key of another table. For example, if another table "Borrowers" references the
"Library" table, the "Book_Id" from the "Library" table could be a foreign key in the "Borrowers" table.

Chapter 9: Starting with LibreOffice Base

A. Multiple Choice Questions:

1. (c) Float
2. (b) False
3. (c) Both date and time
4. (b) It is free and open-source software
5. (c) Both a and b
6. (a) Database
7. (b) Ctrl+O
8. (a) 2
9. (a) Tab
10. (d) All of the above

B. True or False:

1. Text data can contain special characters. True

 2. Memo data type is used to store descriptive or large amounts of text data. True

3. A Boolean data type can only have two values, typically true/false or yes/no. False

4. LibreOffice Base does not support storing audio files directly. True

5. The properties of a field change based on the data type selected. True

6. Field descriptions are optional while designing a table. True

7. The End key or specific navigation buttons are used to move to the last record. False

8. An edit icon or indicator appears when a record is being edited. True

9. Tables in a database can be edited after creation. False

10. The Sort dialog box can sort data in both ascending and descending order. False

C. Fill in the Blanks:

1. A data type refers to the type of data that will be stored in that particular field.

2. The alphanumeric data is a combination of letters, numbers, or special characters.

3. Varchar data type can be used to store Aadhar numbers.

4. The BLOB data type is used to store digitized images.

5. The shortcut key to save a table is Ctrl + S.

6. Status Bar on the Base Interface Window displays information about the type of view of the object
in the database.

7. A key icon appears before the field name indicating that it is a primary key.

8. The data can be entered in a table only in datasheet view.

9. The black pointing arrow just before the field name in a table is called selection pointer.

10. The process of arranging the records in particular order on any field is called sorting.

D. Answer the Given Questions:

1. Differentiate between:

(a) Memo vs. Varchar Data Type:

o Memo: Used to store large text entries, such as paragraphs or descriptions.

o Varchar: Used to store smaller text strings with variable lengths, such as names or
addresses.

(b) Number vs. Decimal Data Type:

o Number: Stores integer values (whole numbers).

o Decimal: Stores precise decimal numbers with a specified number of decimal places.

(c) Design View vs. Datasheet View of a Table:

 o Design View: Allows the user to define the structure of the table (fields, data types, primary
keys, etc.).

o Datasheet View: Displays the table in a spreadsheet-like format for data entry and viewing.

2. Name the menu items present on the Base User Interface.

o File, Edit, View, Insert, Format, Tools, Window, Help

3. Label the Components of the LibreOffice Base User Interface:

o Title Bar: Displays the name of the open database.

o Database Pane: Shows the different database objects (Tables, Queries, Forms, Reports).

o Tasks Pane: Displays the actions related to the selected object (e.g., Create Table, Run
Query).

o Status Bar: Displays information about the current view or object status.

4. How can we define a primary key in a table?

o Open the table in Design View.

o Select the field you want to set as the primary key.

o Right-click on the field and choose Primary Key from the context menu, or click the Primary
Key icon on the toolbar.

5. Write steps to sort the table in descending order of primary key.

o Open the table in Datasheet View.

o Click on the Primary Key field column heading.

o Click on the Sort Descending button in the toolbar, or right-click on the column heading and
select Sort Descending.

6. What is the use of navigation box with respect to tables in a database?

The navigation box allows users to move between different records in a table. It provides buttons for
navigating to the first, previous, next, and last records, as well as options to add new records or jump
to a specific record by number.

Chapter 10: Working with Multiple Tables

A. Multiple Choice Questions:

1. (d) All of the above

2. (c) Both (a) and (b)
3. (b) Both the tables must have a common field
4. (b) The corresponding record in the transaction table can only be entered once.
5. (b) One-to-many
6. (b) One-to-many
7. (c) Tools
8. (a) Add Tables
9. (c) Drag and Drop
 10. (d) Set Value

B. True or False:

1. Redundancy should be minimized in a database. False

2. Each record should represent a unique entity. True

3. A field should store only one data value per record. True

4. Editing a table does not delete the records already entered. False

5. Master records should exist before related transaction records. True

6. In a one-to-many relationship, a master record can have multiple corresponding transaction records.
True

7. The Relationship option is in the Tools menu, not the Windows menu. False

8. Referential integrity is usually maintained by the database, not manually by the user. False

9. Relationships are generally set between tables based on common fields. True

10. Deleting a master record does not always lead to the deletion of transaction records; it depends on
the referential integrity settings. False.

C. Fill in the Blanks:

1. A table to be edited is displayed in datasheet view.

2. The most important prerequisite for setting a relationship between the two tables is that there must
be a common field between them.

3. In a one-to-one relationship, one specific record of a master table has one and only one corresponding
record in the transaction table.

4. One-to-many is one of the most common types of relationships between the tables in a database.

5. A record being entered in a transaction table must always exist in a master table.

6. The principle of referential integrity helps prevent missing data by keeping deleted data from getting
out of sync.

7. Creating relationships between tables restricts the user from entering invalid data in the referenced
fields.

8. Data integrity is maintained by referential integrity.

9. A relationship between customers and products is an example of a many-to-many relationship.

10. The relationship window is used to set relationships between the tables.

D. Answer the Following Questions:

1. Give any two advantages of relating tables in a database.

 o Data Consistency: Relating tables reduces data redundancy and ensures that data is consistent
across the database.

o Efficient Data Retrieval: It allows for more efficient data retrieval through relationships (e.g.,
joining tables based on a common field).

2. How is redundancy or inconsistency controlled in a database? Explain with an example.

Redundancy and inconsistency are controlled through normalization, where data is divided into
related tables, reducing duplication. For example, instead of storing customer information repeatedly
in every order, a separate Customer table is created, and orders are linked to the customer using a
Customer ID.

3. Define referential integrity. Who maintains referential integrity in a database?

Referential integrity ensures that relationships between tables remain consistent. It prevents users
from adding records to a related table if there is no corresponding record in the master table, or from
deleting a record in a master table that has dependent records in a related table. The database
management system (DBMS) maintains referential integrity.

4. Differentiate between one-to-one and one-to-many relationships. Give suitable examples to explain
your answer.

o One-to-One Relationship: Each record in Table A relates to only one record in Table B. For
example, each employee might have one employee ID card.

o One-to-Many Relationship: Each record in Table A can relate to multiple records in Table B.
For example, one teacher can teach many classes, but each class is taught by one teacher.

5. Explain many-to-many relationship with an example?

A many-to-many relationship occurs when multiple records in Table A relate to multiple records in
Table B. For example, in a university system, a student can enroll in multiple courses, and each course
can have many students enrolled. To represent this relationship, a junction table is used, such as
Student_Course that links students and courses with their respective IDs.

Chapter 11: Queries in Base

A. Multiple Choice Questions:

1. (c) Query
2. (d) All of the above
3. (b) Design View
4. (b) Two
5. (d) A query once created cannot be edited
6. (c) F5
7. (d) All of the above
8. (a) >
9. (a) >
10. (a) Add Table
11. (c) Summarizing

B. True or False:

1. A query can be run multiple times. False

 2. A query can be created from multiple tables. False

3. The shortcut key to run a query is F5. True

4. LibreOffice Base provides two ways to create a query (Design View and Wizard). True

5. A query with numerical data can be saved. False

6. By default, the query result is not sorted. True

7. Queries can be used to display the average value of a numerical field. True

8. The criterion can be set on more than one field. False

9. An alias is an alternative name for a field in a query. True

10. The visible checkbox is selected by default in the Query Design window. True

11. Queries created using the wizard can be edited in Design View. True

C. Fill in the Blanks:

1. A query is a sort of question asked from a database.

2. The result of the query is displayed in table form with field names in columns.

3. A query can be created in three ways.

4. The Query Design window is divided into two sections.

5. The shortcut key to run the query is F5.

6. The conditions to filter the records are set in the criteria row.

7. When a table is selected in a Query wizard, the corresponding fields are displayed in the Available
fields list box.

8. The result of the query can be displayed in ascending or descending order of any particular field of
the table.

9. At the most 10 search conditions can be given in the query wizard.

10. The last step of the Query wizard displays the entire structure of the query.

11. The Design view is a more flexible method to create a query.

12. To edit any query, right-click on the edit icon of the query that has to be edited.

13. In the Alias row of the Query Design grid, we can type the column heading that will be displayed
instead of the field name when we run the query.

D. Answer the Given Questions:

1. Define a query? What is the need of creating a query in a database?

A query is a request or question asked from the database to retrieve specific data based on criteria.
Queries are needed to filter, sort, and perform calculations on data efficiently, ensuring relevant
information is extracted for analysis or reporting.
 2. Rearrange the steps given below so as to create a query using a wizard.

I. Give table name

II. Select the fields
III. Set the criterion
IV. Set the sorting order
V. Give Alias

3. What all information is seen in the overview (last step) of the Query wizard?
The overview shows the structure of the query, including selected fields, sorting order, criteria, and
any aliases applied.

4. What is the use of the Alias row in the Design grid of the Query Design window?
The Alias row allows users to give a custom name to a field, making the output of the query more
understandable.

5. Name any four mathematical functions that can be applied to numerical data in a query.

o Sum
o Average
o Minimum
o Maximum

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

o Query Wizard
o Design View
o SQL Mode

Chapter 12: Forms and Reports

A. Multiple Choice Questions:

1. (b) Forms Controls Toolbar

2. (d) All records
3. (b) It can contain only text fields
4. (c) Ctrl
5. (c) Tool Tip
6. (c) Report
7. (b) Standard (long)
8. (a) Design Mode
9. (c) Both a and b
10. (c) Both (a) and (b)

B. True or False:

1. Both forms and reports are objects in a database. False

2. Users can choose the layout of a form while creating it. True

3. You do not have to add all the fields from the table to the form. False

4. There are two ways to create a form: using the wizard and design view. True

5. A report is generated in a separate window. True

 6. Once a control is added, it can still be repositioned on the form. False

7. The Record toolbar contains a button to add a new record. True

8. Reports can be generated using both tables and queries. False

9. By default, records in a report are not sorted in descending order. False

10. Data in reports can be grouped based on a particular field. True

11. A report can display data in formats other than rows and columns. False

12. A report can include the date and time of generation. True

13. A report can be edited after it has been created. False

C. Fill in the Blanks:

1. A form can be used for data entry and data retrieval.

2. Each field control consists of a label and field value.

3. A label is a piece of text that specifies the data that should be entered in the field value text box.

4. By default, the border of the field text value is displayed in gray.

5. A tool tip is a small piece of text that is displayed when the mouse pointer is placed on a particular
control on the form.

6. The default orientation option for a report is portrait.

7. A layout is the manner in which labels, field values, titles, etc., will be displayed in the report.

8. The option to insert date and time in the report is present in the Insert menu.

9. A Report Wizard contains 8 steps.

10. A dynamic type of report changes automatically as the field values in the base table or query
change.

D. Answer the Following Questions:

1. Give one difference between a form and a report.

A form is used for data entry and interaction with the database, while a report is used to present
data in a formatted manner for printing or viewing.

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

A field control is a UI element on a form that allows users to input or view data, like text boxes,
checkboxes, and dropdown lists.

3. Which tool on the Forms Record toolbar is used to insert text on the form?
The Label tool on the Forms Controls toolbar is used to insert text on the form.

4. Name the two ways to create a form in LibreOffice Base.

o Form Wizard
 o Design View

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

A static report does not change once generated, whereas a dynamic report automatically updates
when the underlying data in the table or query changes.

6. Write the function of Forms Controls toolbar and Records toolbar.

o Forms Controls toolbar: Used to design and modify the layout of the form, allowing users to
add controls like text boxes, labels, and buttons.

o Records toolbar: Used to navigate records within a form, allowing users to add, delete, or
move between records.