Chapter 8 - Components of a database system

Question 1

is a collection of interrelated data that can be process by one or more application system

Answer 1

Database

Question 2

is information that is set up for easy access, management and updating. Computer databases typically store aggregations of data records or files that contain information, such as sales transactions, customer data, financials and product information.

Answer 2

Database

Question 3

Reasons why is it necessary to have centralized customer database

Answer 3

Data independence
Shareability and Non redundancy
Integrity
relatability
Access flexibility
Security
performance and efficiency
Administration and control

Question 4

the application program or users is protected from changes in the way that data is organized, stored, and accessed.

Answer 4

Data independence

Question 5

all qualified users are assured access to required data via database.

Answer 5

Shareability and Non redundancy

Question 6

the accuracy of the data must be ensured

Answer 6

Integrity

Question 7

a records contains of information about an individual. Just as the data items on a single record are related to one another.

Answer 7

relatability

Question 8

being able to easily and efficiently access the data in variety ways suited to the needs of the users.

Answer 8

Access flexibility

Question 9

the database must be protected against unauthorized or malicious access and actions.

Answer 9

Security

Question 10

the system must function smoothly at a level of cost that is acceptable to users.

Answer 10

performance and efficiency

Question 11

there must be centralized authority and responsibility for the management of the system.

Answer 11

Administration and control

Question 12

Components of Database System

Answer 12

Data-base management system
Users
database administrator
directory
Database

Question 13

-is the heart of the system
-is software handles the request for data and performs other functions for user and system administrator.

Answer 13

Data-base management system

Question 14

• represents the all the Individuals or groups who have access to data.
  -users may access all or only a specific portion of data.

Answer 14

Users

Question 15

• is the highly skilled technical specialist who acts as the main interface between the system and users.
  -is responsible for the technical performance of the system, cooperating with the major user groups, for defining the data needs of organization and specifying how the data is configured to meet those need.

Answer 15

database administrator

Question 16

• catalog all the data on the database. it stores definition each of data entity in the database
• it defines each item in terms of names, its length, and the form which is it stored.it stores data about relationship among data entities. (Data about data is called metadata) and also keeps track of a great deal of other data that enables users to access data quickly.

Answer 16

directory

Question 17

• is a software system where the data are stored.
• there are several types of true database system, and also system that predate actual database system. there are also application programs, especially spreadsheet that have some of functionality but actually are not databases.

Answer 17

Database

Question 18

3 primary types of database system

Answer 18

Hierarchical
Network
relational

Question 19

• this database follows the progression of data being categorized in ranks or levels, wherein data is categorized based on a common point of linkage.

Answer 19

Hierarchical

Question 20

• A database organized according to ownership of records, allowing records to have multiple owners and thus providing multiple access paths to the data.

Answer 20

Network

Question 21

In this database, every piece of information has a relationship with every other piece of information. This is on account of every data value in the database having a unique identity in the form of a record.

Answer 21

relational