Database Systems

Question 1

Efficient data management typically requires the use of a _________________.

Answer 1

COMPUTER DATABASE

Question 2

Organized collection of logically related data

Answer 2

DATABASE

Question 3

Data about data, through which the end-user data are integrated and managed

Answer 3

METADATA

Question 4

Raw facts of interest to the end user

Answer 4

END-USER DATA

Question 5

A collection of hardware, software, people, procedures and data

Answer 5

INFORMATION SYSTEM

Question 6

What are the levels of management in an information system?

Answer 6

Corporate
Team, Division Unit
Individual

Question 7

Level of management that comprises of information useful for the whole organization

Answer 7

CORPORATE

Question 8

Also known as “global” information

Answer 8

CORPORATE

Question 9

Policies and procedures, HR information, online forms, phone directory

Answer 9

CORPORATE

Question 10

Level of management that covers all the information shared within teams, divisions, business units

Answer 10

TEAM DIVISION, BUSINESS UNIT

Question 11

Project documentation, business unit specific content, meeting minutes

Answer 11

TEAM DIVISION, BUSINESS UNIT

Question 12

Level of management that handles personal information needs of staff

Answer 12

INDIVIDUAL

Question 13

Email, internal and external correspondence and reports

Answer 13

INDIVIDUAL

Question 14

Collection of programs that manages the data base structure and controls access to the data stored in the database

Answer 14

DATABASE MANAGEMENT SYSTEM

Question 15

Resembles a very well-organized electronic filing cabinet

Answer 15

DATABASE

Question 16

If database is the very well-organized electronic filing cabinet. What helps manage the cabinet’s contents?

Answer 16

DATABASE MANAGEMENT SYSTEM

Question 17

This role of DBMS helps create an environment in which end users have better access to more and better-managed data

Answer 17

IMPROVED DATA SHARING

Question 18

This role of DBMS provides a framework for better enforcement of data privacy and security policies

Answer 18

IMPROVED DATA SECURITY

Question 19

This role of DBMS promotes an integrated view of the organization’s operations and a clearer view of the big picture

Answer 19

BETTER DATA INTEGRATION

Question 20

Exists when different versions of the same data appear in different places

Answer 20

DATA INCONSISTENCY

Question 21

This role of DBMS makes it possible to produce quick answers to ad hoc queries

Answer 21

IMPROVED DATA ACCESS

Question 22

A specific request issued to the DBMS for data manipulation

Answer 22

QUERY

Question 23

A spur-of-the-moment question

Answer 23

AD HOC
QUERY

Question 24

Comprehensive approach to promoting the accuracy, validity, and timeliness of the data

Answer 24

DATA QUALITY

Question 25

Refers to the activities that focus on the design of the database structure that will be used to store and manage end-user data

Answer 25

DATABASE DESIGN

Question 26

How the database structure will be used to store and manage end-user data

Answer 26

DATABASE DESIGN

Question 27

First step in designing a database

Answer 27

DATA MODELING

Question 28

Process of creating a specific data model for a determined problem domain

Answer 28

DATA MODELING

Question 29

A clearly defined area within the real world environment

Answer 29

PROBLEM DOMAIN

Question 30

Well-defined scope and boundaries that are to systematically addressed

Answer 30

PROBLEM DOMAIN

Question 31

Simple representation, usually graphical, of more complex real-world data structures

Answer 31

DATA MODEL