Valuing and Storing Organizational Information - Databases

Question 1

data stewardship

Answer 1

The management and oversight of an organization’s data assets to help provide business users with high-quality data that is easily accessible in a consistent manner.

Question 2

data gap analysis

Answer 2

Occurs when a company examines its data to determine if it can meet business expectations, while identifying possible data gaps or where missing data might exist.

Question 3

data steward

Answer 3

Responsible for ensuring the policies and procedures are implemented across the organization and acts as a liaison between the MIS department and the business.

Question 4

data governance

Answer 4

Refers to the overall management of the availability, usability, integrity, and security of company data

Question 5

data validation

Answer 5

Includes the tests and evaluations used to determine compliance with data governance polices to ensure correctness of data.

Question 6

database

Answer 6

Maintains information about various types of objects (inventory), events (transactions), people (employees), and places (warehouses)

Question 7

database management system (DBMS)

Answer 7

Creates, reads, updates, and deletes data in a database while controlling access and security.

Question 8

query-by-example (QBE) tool

Answer 8

Helps users graphically design the answer to a question against a database

Question 9

structured query language

Answer 9

Users write lines of code to answer questions against a database.

Question 10

data model

Answer 10

Logical data structures that detail the relationships among data elements using graphics or pictures.

Question 11

metadata

Answer 11

Details about data.

Question 12

relational database model

Answer 12

A type of database that stores information in the form of logically related two-dimensional tables

Question 13

relational database management system

Answer 13

Allows users to create, read, update, and delete data in a relational database.

Question 14

entity

Answer 14

Stores information about a person, place, thing, transaction, or event.

Question 15

attribute

Answer 15

The data elements associated with an entity.

Question 16

record

Answer 16

A collection of related data elements.

Question 17

primary key

Answer 17

A field (or group of fields) that uniquely identifies a given entity in a table.

Question 18

foreign key

Answer 18

A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.

Question 19

physical view of information

Answer 19

The physical storage of information on a storage device such as a hard disk.

Question 20

logical view of information

Answer 20

Focuses on how users logically access information to meet their particular business needs.

Question 21

data latency

Answer 21

The time it takes for data to be stored or retrieved.

Question 22

information redundancy

Answer 22

The duplication of data, or the storage of the same data in multiple places.

Question 23

information integrity

Answer 23

A measure of the quality of information.

Question 24

integrity constraint

Answer 24

The rules that help ensure the quality of information.

Question 25

relational integrity constraint

Answer 25

The rules that enforce basic and fundamental information-based constraints.

Question 26

business rule

Answer 26

Defines how a company performs a certain aspect of its business and typically results in either a yes/no or true/false answer.

Question 27

business-critical integrity constraint

Answer 27

Enforces business rules vital to an organization’s success and often requires more insight and knowledge than relational integrity constraints.

Question 28

identity management

Answer 28

A broad administrative area that deals with identifying individuals in a system (such as a country, a network, or an enterprise) and controlling their access to resources within that system by associating user rights and restrictions with the established identity.

Question 29

data-driven website

Answer 29

An interactive website kept constantly updated and relevant to the needs of its customers through the use of a database.

Question 30

static information

Answer 30

Includes fixed data that are not capable of change in the event of a user action.

Question 31

dynamic information

Answer 31

Includes data that change based on user actions.

Question 32

dynamic catalog

Answer 32

An area of a website that stores information about products in a database.

Question 33

forward integration

Answer 33

Takes information entered into a given system and sends it automatically to all downstream systems and processes.

Question 34

backward integration

Answer 34

Takes information entered into a given system and sends it automatically to all upstream systems and processes.

Question 35

data element (or data field)

Answer 35

The smallest or basic unit of information.

Question 36

data dictionary

Answer 36

Compiles all of the metadata about the data elements in the data model.

Question 37

content creator

Answer 37

The person responsible for creating the original website content.

Question 38

content editor

Answer 38

The person responsible for updating and maintaining website content.

Question 39

integration

Answer 39

Allows separate systems to communicate directly with each other, eliminating the need for manual entry into multiple systems.