Database Systems In The Organization

Question 1

Database

Answer 1

A collection of interrelated, shared, and controlled data

Question 2

Data Integration

Answer 2

Combining data for common use.

Question 3

Electronic data processing

Answer 3

Computer automation of paperwork at the operational level of an organization.

Question 4

Decision support system

Answer 4

Automated system providing strategic information to senior managment.

Question 5

Distributed database system

Answer 5

A database system is made of several systems at local sites connected by communication lines.

Question 6

Database planning

Answer 6

Strategic effort to determine information needs for an extended period.

Question 7

Database development life cycle(DDLC)

Answer 7

A process for designing implementing and maintaining a database.

Question 8

Database administration

Answer 8

Personnel with responsibility for controlling and protecting the database.

Question 9

Conceptual database design

Answer 9

Identification of data elements, relationships, and constraints for a database.

Question 10

Value constraint

Answer 10

A rule defining the permissible values for a specific data item

Question 11

Physical database design

Answer 11

Determination of storage devices, access methods, and indexes for using a database.

Question 12

View

Answer 12

A definition of a restricted portion of the database is also called a data view.

Question 13

Schema

Answer 13

A definition of the logical structure of the entire database.

Question 14

Information center

Answer 14

An area where users have facilities to do their computing

Question 15

Retrieve only access

Answer 15

Database access with no update allowed

Question 16

Data integrity

Answer 16

Accuracy and consistency of data values in the database.

Question 17

Three level architecture

Answer 17

Standard database structure consisting of conceptual, external and internal levels

Question 18

Conceptual level

Answer 18

Database structural level defining the logical schema of the database.

Question 19

External level

Answer 19

Database structural level defining user views.

Question 20

Internal level

Answer 20

Database structural level defining physical view of the database.

Question 21

Database development life cycle(DDLC)

Answer 21

A process for designing implementing and maintaining a database system.

Question 22

System development life cycle(SDLC)

Answer 22

A process for system development.

Question 23

Function-oriented approach

Answer 23

Views a system from the perspective of the functions it should perform

Question 24

Data-oriented approach

Answer 24

Focuses on the analysis of data used by functions.

Question 25

Preliminary planning

Answer 25

Planning for a database that occurs during the strategic database planning process.

Question 26

Feasibility study

Answer 26

A portion of the DDLC that determines the technological operational and economic feasibility of the database.

Question 27

Technological feasibility

Answer 27

Determination of hardware and software availability for database system.

Question 28

Operational feasibility

Answer 28

Determination of availability of expertise and personnel needed for the database system.

Question 29

Economic feasibility

Answer 29

Cost-benefit study of proposed database system.

Question 30

Requirements definition

Answer 30

Determination of management and fun

Question 31

Conceptual Design

Answer 31

Creation of conceptual level schema for database

Question 32

Database Implementation

Answer 32

The steps required to change a conceptual design to a functioning database.