Bmgt402-Umd

Front 1

Data redundancy

Back 1

occurs when data is stored in multiple locations

Front 2

Which of the following statements related to the event-driven approach is false?

Back 2

It focuses on how users interact with business events and processes.

Front 3

A record layout depicts:

Back 3

the fields comprising a record

Front 4

Grouping or categorizing data according to common attributes is called:

Back 4

classifying data

Front 5

Another name for sequential coding is:

Back 5

serial coding

Front 6

The uniform product codes (UPC) used in supermarkets is a type of:

Back 6

block code

Front 7

A company uses a 7-digit number to identify customers. For example, the customer 1532789indicates the following information: digits1-2, state, 15 = Georgiadigit3, type of organization, 3 = government agencydigit4, credit terms, 2 = 2/10, n/30digits5-7, unique customer identifier, 789

Thistype of coding scheme is:

Back 7

significant digit

Front 8

A postal ZIP code is an example of which of the following coding schemes?

Back 8

hierarchical code

Front 9

The coding system that is most understandable by human information processors is:

Back 9

mnemonic coding

Front 10

Which of the following is the most likely coding scheme for college courses?

Back 10

mnemonic coding

Front 11

An extracharacter added to a numeric code as a device to test the accuracy of dataentered into a computer system is called a:

Back 11

check digit

Front 12

Assigningnumbers to objects in chronological sequence is known as:

Back 12

sequential coding

Front 13

The ____concentrates on the process being performed with data playing a secondary orsupporting role.

Back 13

applications approach

Front 14

Whichof the following statements regarding the centralized database approach to datamanagement is false?

Back 14

In this approach, data and applications are dependent on each other.

Front 15

The computersoftware needed to implement a database approach to data management that is notneeded with the applications approach to data management is:

Back 15

database management system (DBMS) software

Front 16

Which of thefollowing is not a database model discussed in Chapter 5:

Back 16

Physical

Front 17

The featureof a database management system that enables nontechnical users to access adatabase and to produce inquiry reports is the:

Back 17

query language

Front 18

database approachand the applications approach and is known as:

Back 18

data independence

Front 19

Withthe centralized database approach to data management, we expect to have:

Back 19

improved data integrity

Front 20

Whichof the following advantages of the centralized database approach does notoccur because of a reduction in data redundancy?

Back 20

reduced user and programmer training

Front 21

Which of thefollowing is not a function that a database management system performs?

Back 21

Coordinating access to data stored in theapplications programs.

Front 22

Theexploration, aggregation, and analysis of large quantities of varied data fromacross the organization is known as:

Back 22

data mining

Front 23

Whichof the following statements related to events-driven systems is false?

Back 23

Organizations adopting an events-driven systemare focused on capturing data for the purpose of generating reports.

Front 24

A(n)____ reflects a system's key entities and the relationship among them.

Back 24

entity-relationship diagram

Front 25

Aresource, event, or agent about which data are collected is called:

Back 25

an entity

Front 26

Inan entity-relationship diagram, ____ are used to show the characteristics ofrelationships

Back 26

diamonds

Front 27

Adata model depicts the requirements for data as specified by the:

Back 27

user

Front 28

Ina(n) ____ database model, records are organized in a pyramid structure.

Back 28

hierarchical

Front 29

The ____database model works well for simple data structures, but falls apart quicklywhen the data becomes more complex.

Back 29

Hierarchical

Front 30

In a(n) ____database model, a child record may have more than one parent.

Back 30

network

Front 31

____ databases include abstract data types thatallow users to define characteristics of the data to be stored when developingan application.

Back 31

Object-oriented

Front 32

Ina(n) ____ database model, data are logically organized into two-dimensionaltables.

Back 32

relational

Front 33

Theuse of information systems facilities to focus on the collection, organization,integration, and long-term storage of entity-wide data is known as:

Back 33

data warehousing

Front 34

In anobject-oriented database model, what types of objects can be stored through useof abstract data types, inheritance, and encapsulation?

Back 34

both simple and complex

Front 35

Object-orienteddatabases

Back 35

include abstract data types

Front 36

If attributeA determines a single value for attribute B at any time, we say that attributeB is ____.

Back 36

functionally dependent on attribute A

Front 37

Arelation that is in ____ form contains repeating attributes within each row orrecord

Back 37

unnormalized

Front 38

Arelation is in second normal form (2NF) if it is in first normal form (1NF)and:

Back 38

no non-key attribute is dependent on only aportion of the primary key

Front 39

Ofthe following options, a database that is in ____ form has the best design

Back 39

third normal (3NF)

Front 40

Theapplications approach to business event processing:

Back 40

has data redundancy

Front 41

Runningan applications approach to sales and inventory programs leads to:

Back 41

data redundancy

Front 42

Data flowsthat mirror and monitor business operations are called ____ flows.

Back 42

horizontal information

Front 43

Dataflows that provide a basis for managerial decisions are called ____ informationflows

Back 43

vertical

Front 44

Theapproach to business event processing in which facts are stored in a relationaldatabase is

Back 44

the centralized database approach

Front 45

Ina DBMS, a complete description of the configuration of record types, data itemsand the relationships among them is known as:

Back 45

Schema

Front 46

A ____describes a portion of a DBMS' configuration of record types and data items andthe relationships among them.

Back 46

Subschema

Front 47

Theway a user thinks of the data in a database is called the user's:

Back 47

logical view

Front 48

Whichof the following statements is true of a hierarchical DBMS?

Back 48

parent records can have many child records

Front 49

Whichof the following statements is true of a network database model?

Back 49

both a and b

Front 50

Themodel that only works well for simple data structures is the:

Back 50

hierarchical database model

Front 51

Themodel that logically organizes data into two-dimensional tables is the:

Back 51

relational database model

Front 52

The modelthat includes abstract types that allow users to define data to be stored inthe database is the:

Back 52

object-oriented database model

Front 53

Aunique identifier that serves as an address for each row in a database iscalled:

Back 53

the primary key

Front 54

In theapplications approach to business event processing, a data change in oneapplication before updating another application could lead to:

Back 54

inconsistent data

Front 55

A(n)____ depicts user requirements for data stored in a database.

Back 55

data model

entity-relationship model

E-R diagram

Front 56

Increating an entity-relationship diagram, the correct sequence of steps is

Back 56

identify entities, identify relationships,create tables

Front 57

Forthe following diagram, which item is the entity?

Back 57

Students

Front 58

Themapping of the relationships between entities would be used in the developmentof a(n):

Back 58

E-R diagram

Front 59

Whichof the following is not a relationship type?

Back 59

one-to-few

Front 60

Whichof the following database types has dominance in organizations?

Back 60

relational

Front 61

Each relationship in an E-R diagram has a ____that shows the degree to which each entity participates in the relationship.

Back 61

cardinality

Front 62

A decisionmaker prepares a presentation in a suitable format for a given decision at agiven point in time when using a(n):

Back 62

decision support system (DSS)

Front 63

Theprincipal difference between an executive information system (EIS) and adecision support system (DSS) is that an EIS:

Back 63

is primarily about collecting and presentinginformation without doing additional processing or calculations

Front 64

Theinformation system which emulates the problem-solving techniques of humans iscalled a(n):

Back 64

expert system (ES)

Front 65

Whichof the following statements about expert systems (ES) is false:

Back 65

They only work well for simple decisions

Front 66

Thecomputer-based system of hardware and software that mimics the human brain'sability to recognize patterns or predict outcomes using less-than-completeinformation is referred to as:

Back 66

neural networks

Front 67

Asoftware program that may be integrated into DSS or other software tools isa(n):

Back 67

intelligent agent