Chapter 8. Introduction to Database Management System

Unit 3. Database Management System using LibreOffice Base

A. Multiple-choice questions.

Question 1:
Which of the following can not be considered as an example of a database?
(a) Dictionary
(b) Telephone directory
(c) Marks Register
(d) Newspaper

Answer: (d) Newspaper

Question 2:
Which of the following is NOT a DBMS?
(a) MS Access
(b) Open Office Base
(c) MS Excel
(d) MySQL

Answer: (c) MS Excel

Question 3:
DBMS stands for __________.
(a) Data and Books Management System
(b) Database Management System
(c) Duplicate Books Management System
(d) Data Management Multi System

Answer: (b) Database Management System

Question 4:
Which of the following data models sets a relation between the two or more tables?
(a) Relational Data Model
(b) Network Data Model
(c) Hierarchical Data Model
(d) Connection Data Model

Answer: (a) Relational Data Model

Question 5:
The details associated with an entity are called ________.
(a) Table
(b) Attributes
(c) Records
(d) Primary key

Answer: (b) Attributes

Question 6:
A ________ is represented as rows in a table.
(a) field
(b) attribute
(c) record
(d) candidate key

Answer: (c) record

Question 7:
In which of the following forms can a data value be represented?
(a) Numeric
(b) Character
(c) Alphanumeric
(d) All of the above

Answer: (d) All of the above

Question 8:
Which of the following uniquely identifies a row in a table?
(a) Primary key
(b) Alternate key
(c) Foreign key
(d) Candidate key

Answer: (a) Primary key

Question 9:
A ___________is a feature of a database using which we can enter data in a table in an easy and user friendly manner.
(a) query
(b) report
(c) form
(d) field

Answer: (c) form

Question 10:
A _______ is a question asked from a database.
(a) query
(b) report
(c) form
(d) field

Answer: (a) query

Chapter 8 Introduction to Database Management System IT Code 402 Book Solution

B. State whether the following statements are True or False.

Question 1:
A database cannot be organised.

Answer: False

Question 2:
Data is the collection of raw facts.

Answer: True

Question 3:
A table can be created without a primary key.

Answer: False

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

Answer: False

Question 5:
MS Access is an example of a database.

Answer: False

Chapter 8 Introduction to Database Management System IT Code 402 Book Solution

C. Fill in the blanks.

Question 1:
The raw facts constitutes ________.

Answer: Data

Question 2:
An ________ is a real world object about which information is to be stored in a database.

Answer: Entity

Question 3:
The output of a query may be displayed in the form of ________.

Answer: Report

Question 4:
The data values for all the fields related to a person or object is called a ______.

Answer: Record

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

Answer: Candidate

Chapter 8 Introduction to Database Management System IT Code 402 Book Solution

D. Answer the following questions.

Question 1:
Define the terms:
(a) Database (b) Data redundancy (c) Report

Answer:

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

(b) Data Redundancy: Duplication of data is called Data Redundancy. Same data is stored multiple times either in same table or different table is known as Data Redundancy.

(c) Report: The result of the query which is presented in the proper format, is known as Report.

A report is a document that presents data in a structured and easily readable format, often used for summarizing and analyzing data stored in a database.

Question 2:
Give one point of difference between
(a) Data and Information,
(b) Form and Query,
(c) Network and hierarchical data model

Answer: One point of difference between

(a) Data and Information:

(i) Data is an unprocessed data, while information is a processed data.
(ii) Data is the collection of raw facts, figures, and symbols, while information is the meaningful collection of data.

(b) Form and Query:
A form is a feature of a database using which we can enter data in a table in an easy and user-friendly manner.

A query is used to retrieve the desired information from the database. In simple terms, it is a question asked from the database.

(c) Network and hierarchical data model

In the Network model, multiple records are linked to same master file. It is also considered as an inverted tree.

In the Hierarchical model, the data is organized into a tree like structure.

Question 3:
Give any four advantages of a DBMS.

Answer: Advantages of a DBMS are:-

• Organised Storage: The data in the database is stored in an organised manner.
• Data Sharing: If the same data set is required for different applications then the database can be shared with other applications.
• Minimal Data Redundancy: Database reduce the duplication of data, i.e. data redundancy.
• Data Consistency: By minimising data redundancy, chances of inconsistent data being stored is reduced. Inconsistent means the mobile number of one student is changed in one table and not changed in another table.

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

Table: Library

Book_Id	BookName	AuthorName	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

(a) Name the fields in the given table.
(b) Which field should be made the primary key?
(c) Is there any alternate key in the table?
(d) How is primary key different from foreign key? Explain with example.

Answer:
(a) Book_Id, BookName, AuthorName, Price, Publisher
(b) Book_Id
(c) BookName
(d) The primary key is a key, which uniquely identifies the record in a table. While the foreign key is used to make the relationship between two tables. A foreign key is a non-key, whose value is derived from the primary key of the master table.