Database Design_Topic 1_Formative 2

Identify Database Management System.

• A shared collection of logically related data, and a description of this data, designed to meet the information needs of an organization.

• An arrangement of data in computer memory.

• Software that define a database, store the data, produce the reports and create data entry screens.

• Procedure used for solving problem orperforming a computation.

Which of the following is NOT various common of

DBMS?

• MySQL

• Oracle

• Microsoft Access

• Powerpoint

Collection of file folders, each properly tagged and

kept in a filing cabinet refers to ............................ approach of

information processing

The data stored can be easily accessible and hence it

is not secure refers to disadvantages of traditional

information processing in ...............................

• Data Redundancy

• Data Security

• Data Isolation

• Data Dependence

Data is scattered in various files having different

formats refers to disadvantages of traditional

information processing in ...............................

• Data Security

• Data Isolation

• Data Dependence

• Data Redundancy

The same information may get duplicated in two or

more files refers to disadvantages of traditional

information processing in ...............................

• Data Dependence

• Data Security

• Data Isolation

• Data Redundancy

There is no centralized execution of the data

management functions refers to disadvantages of traditional

information processing in ...............................

• Data Security

• Data Dependence

• Data Isolation

• Data Redundancy

Importance of Database Management System EXCEPT ............

• Reduce data sharing

• Reduced

  data

  redundancy

• Increase

  end user

  productivity

• Improved

  data

  security

Database architecture consists of ................................

• Centralised & Distributed

• Centralised & Sequence

• Distributed & Synchronization

• Static & Dynamic

Database architecture that consists two or more files located at different sites of a network.

• Distributed

• Centralised

• Synchronization

• Static