Database Fundamentals Exercise Chapter 1

Which one is the correct order of hierarchical data?

• Bits - Bytes- Files - Fields - Records - Database

• Bits - Bytes- Records - Fields - Files - Database

• Bytes - Bits- Files - Fields - Database - Records

• Bytes - Bits- Records - Files - Fields - Database

• Bits - Bytes - Fields - Records - Files - Database

5 components of database system environment are as follows, EXCEPT:

• Procedure

• User

• Run Time

• Hardware

• Software

DBMS is

• the instructions and rules to design and use the database

• a collection of programs that enable users to create and maintain a database

• is used to present information in a database in an attractive way

• an application components that are developed using the design tools

• physical device to control the process of input and output

The disadvantages of file processing approach are as follows, EXCEPT:

• Information is entered many times in many formats due to the output, which is required

• Takes time to manipulate data

• Takes time to execute complex calculations

• Duplication of data

• Sharing of data

Define the following terms:

i) Database -

ii) Data -

iii) Information -

What are the advantages of database approach?

________________________ approach store the data in individual files, where each one is uniquely designed for one particular application.

Function of the database application is to ____________________________________, ___________________________ and _______________________.

Why we need database?