Unit 3: Database Management System

Chapter 8: Introduction to Database Management System

 Answers
A. Select the correct option.

1. a. Database 2. b. Data 3. c. A set of related fields

4. b. Database Management System 5. c. Both a and b

6. c. A primary key field can be NULL. 7. a. Relational Data Model

8. b. Attributes 9. b. Handouts 10. c. Query

B. Fill in the blanks.

1. Relational model 2. NULL 3. Composite key 4. Database

5. Record 6. Attribute 7. Form 8. Information

C. Answer the following questions.

1. Database is a collection of data, which is stored in a systematic manner, i.e., in the form

of tables so that one can retrieve and manipulate the information quickly and efficiently

from a large set of data.

2. The Database Management System (DBMS) is a computerised record keeping system or a

software that enables you to create, store, modify, and extract information from a

database. It does not support relationship between tables.

The Relational Database Management System (RDBMS) is a type of the DBMS software

that uses the Relational Database (RDB) model for its database. A relational model

enables the users to store data in several tables and supports relationships between

tables using keys.

3. Tuples: All the rows (consists of a set of related information that belongs to a particular

object) in a table/database are called tuples or records.

Attributes: An attribute is a piece of information about an object. All the columns in a

table/database are called attributes.

4. A primary key is a set of one of more fields that uniquely identifies each record in a table.

It does not contain any duplicate data. A table can have only one primary key. The value
 in the primary key field is different for every tuple and thus helps in uniquely identifying

the records.

5. A composite key or composite primary key refers to a combination of two or more

attributes (fields) that uniquely identify the records in a table. It may be a candidate key

or primary key. For example, In the Customer table of Dominos database, the

CustOrder_ID field alone cannot become a primary key as many products can be

purchased by the same customer, thus the same customer can have multiple entries.

Similarly, column Product_ID alone cannot become a primary key as the same product

can be purchased by different customers. Hence, composite key is CustOrder_ID and

Product_ID, as records can be retrieved uniquely by using both the fields.

6. Network Data Model: In this model, multiple records are associated with the same

master file. It is also considered an inverted tree with the master positioned at the base

and branches holding information linked to the master.

Hierarchical Data Model: In this model, data is structured in a manner resembling a tree,

with information organised into records. A record comprises fields and their respective

data values. These records are interconnected at different levels, creating a hierarchical

structure.

7. Different database objects are:

Table: The data is first stored in tables in row and column format. A column represents a

field or an attribute while a row represents a record.

Forms: A form is a feature of a database using which we can enter data in a table in an

easy and user friendly manner.

Queries: A query is used to retrieve the desired information from the database. In simple

terms, it is a question asked from the database.

Reports: Reports are used to display the selected data in a printable format.

8. Four advantages of RDBMS are:

• RDBMS provides the features to create, update, and administer a relational database.
• RDBMS makes easy to search and retrieve the data within the database and ensures that
data integrity is maintained.

• RDBMS makes it possible to run queries across multiple tables at once.

• RDBMS has the capability to retrieve data from different related tables conveniently, to

produce the answers to questions that cannot be answered from individual tables alone.

Chapter 9: Starting with LibreOffice Base

 Answers
A. Select the correct option.

1. c. Char 2. b. Date [DATE] 3. a. Float [FLOAT] 4. a. Date

5. b. Database wizard 6. a. Database 7. c. Both a and b

8. a. Edit > Delete Record 9. c. Sort Dialog Box 10. c. Float

11. b. It is free and open source software 12. a. Length

B. Fill in the blanks.

1. Field Type 2. Tab 3. Two 4. Ctrl+O 5. Date

C. Answer the following questions.

1. Data types define the type of data you can enter into a field. Examples of data types

include text, number, date, time, boolean, etc.

2. The Text [VARCHAR] data type is used to store variable length field type character or string

values, such as names, addresses, and descriptions.

3. The Table Data view is the default view of LibreOffice Base. In this view, you can enter
 and navigate the records. In Table Design view, you can create a table by defining the field
names and field types. This view also allows you to edit the structure of the created tables.

4. Tables are the easiest way to store, organise, and present a large amount of information.
They are the building blocks of a database.

5. To sort the records of a table in descending order, first select a field according to which
you wantto sort the data. Click on the Sort in Descending Order button on the Table Data
toolbar

Chapter 10: Working with Multiple Tables

 Answer

A. Select the correct option.

1. c. Set Value 2. d. All of the above 3. b. One-to-many

4. c. Drag and Drop a field

B. Fill in the blanks.

1. Primary key 2. Relationships 3. One-to-one 4. Many-to-many

5. Field property

C. Answer the following questions.

1. Referential Integrity (RI) is a rule in RDBMS. It states that a foreign key must have a

matching primary key, i.e., all its references must be valid and the users cannot

accidentally delete or amend the data. It ensures the accuracy and consistency of the

data within a relationship, and prevents the users to enter the inconsistent data.

2. Following are different types of relationships:

• One-to-One

• One-to-Many

• Many-to-Many

3. Students and Courses tables are best example of a many-to many relationship. A student

can register for many courses, and a same course can be opted by many students.

4. Prevents data redundancy: Relating tables avoids duplicate data by storing it in a single

table and referencing it elsewhere.

Maintains data integrity: Changes in a master table automatically reflect in related tables,

ensuring consistency and preventing invalid data entry.

Chapter 11: Queries in Base
 Answers

A. Select the correct option.

1. a. Add Table or Query 2. b. Criteria 3. b. Two 4. a. Like

5. b. * 6. d. All of These 7. a. [] 8. d. A query can run multiple times

B. Fill in the blanks.

1. Query Wizard 2. Alias 3. F5 4. Wildcards 5. Wizard

C. Answer the following questions.

1. A query is a database object that enables you to retrieve records from one or more tables

of the database or different databases that meet a specific condition or criteria. Queries

can also be used to summarize, analyze, update, or delete records in a database.

2. Following are the queries views:

• Query Design View

• SQL View

3. This property allows the user to specify an alternative name for any field. For example, if

the field name is Reg_No and you want to give it an alternate name, say,

Registration_No, then you can enter Registration_No in the Alias field.

4. The Query Wizard guides you to create a query based on selected table. It is the easiest

method for beginners. The Query Design View gives you more control over a query. It

allows you to create a query from the scratch.

5. Wildcards are special characters that are used as substitutes for one or more characters in
a string (text value). These are helpful for locating multiple items on a specified pattern
match, but not identical data.

6. The three ways of creating a query in LibreOffice Base are query wizard, query design

view and SQL view.

 Chapter 12: Forms and Reports

Answers

A. Select the correct option.

1. a. Form 2. d. Run Query button 3. d. Report 4. a. Page header

5. b. Tool Tip 6. b. Standard (long) 7. b. Static 8. d. All of these

B. Fill in the blanks.

1. T 2. F 3. T 4. T 5. T

C. Answer the following questions.

1. A form holds different fields of a table that you use to enter and modify the data in the

database. Using form, you can add or edit one record at a time. It is a convenient and an

interactive way of entering data, but not an appropriate tool for every data entry.

2. To launch the Form Wizard, click on the Forms in the Database Objects pane. Then, select

the Use Wizard to Create Form option in the Database Tasks pane.

3. Yes. To change the name of labels, follow these steps:

• Right-click on the created form and select Edit. You will switch into the Design Mode

of the form. Choose a label that you wish to modify.

• Double-click on it. The Properties: Label Field dialog box opens. Here, enter a new

name in the Name property.

4. A report is a summary of your database. It is an effective way to organise and summarise

the data for viewing and printing. It consists of information obtained from tables or

queries, and presented as per the user's requirements.

5. A static report always displays the same data from the time when the static report was

created. A dynamic report generates the result of the report from the current table data.

This means that if you have some updated data in the table that feeds the report, then

the report will change accordingly.

6. The From Control Toolbar contains various controls that can be added to the form such

as labels, text boxes, and buttons. It also sets the properties of a form control.