Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Info Systems > Chapter 6 > Flashcards

Chapter 6 Flashcards

1
Q

Problem

A

Explosive growth created information management challenges

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Solutions

A

Use MDM to create an enterprise-wide set of data, preventing unnecessary data duplication

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Master data management

A

enables companies like R.R. Donnelley to eliminate outdated, incomplete or incorrectly formatted data.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Information must be

A

Accurate, Timely, and relevant

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

ATTRIBUTE

A

Each characteristic, or quality, describing entity

E.g., Attributes Date or Grade belong to entity COURSE

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

DATA REDUNDANCY

A

Presence of duplicate data in multiple files

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

data inconsistency

A

Same attribute has different values

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

flexibility

A

can deliver routine scheduled reports but cannot deliver ad hoc reports or respond to unanticipated information requirements in a timely fashion

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

security

A

little control or management of data, access to and dissemination of information may be out of control

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

DATABASE MANAGEMENT SYSTEM

A

Separates logical and physical views of data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Logical view

A

how a user sees the data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

RELATIONAL DBMS

A

Represent data as two-dimensional tables called relations or files
Each table contains data on entity and attributes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Rows (tuples)

A

Records for different entities

Information for a single customer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Key field

A

Field used to uniquely identify each record

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Primary key

A

Field in table used for key fields

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

SELECT

A

Creates subset of data of all records that meet stated criteria in a table (file)

17
Q

JOIN

A

Combines relational tables to provide user with more information than available in individual tables

18
Q

PROJECT

A

Creates subset of columns in table, creating tables with only the information specified

19
Q

Object-Oriented DBMS (OODBMS)

A

Objects can be graphics, multimedia, Java applets Hybrid object-relational DBMS: Provide capabilities of both OODBMS and relational DBMS

20
Q

DATA DICTIONARY

A

Automated or manual file storing definitions of data elements and their characteristics

21
Q

Many DBMS have report generation capabilities for creating polished reports (CRYSTAL REPORTS)

A

Displays data in an easier-to-read format

22
Q

Normalization

A

Streamlining complex groupings of data to minimize redundant data elements and awkward many-to-many relationships

23
Q

Entity-relationship diagram

A

Used by database designers to document the data model

Illustrates relationships between entities

24
Q

Data warehouse

A

Stores current and historical data from many core operational transaction systems
Consolidates and standardizes information for use across enterprise, but data cannot be altered
Data warehouse system will provide query, analysis, and reporting tools

25
Q

Data marts

A

Subset of data warehouse
Summarized or highly focused portion of firm’s data for use by specific population of users
Typically focuses on single subject or line of business

26
Q

Business Intelligence

A

Tools for consolidating, analyzing, and providing access to vast amounts of data to help users make better business decisions

27
Q

Online analytical processing

A

OLAP enables rapid, online answers to ad hoc queries

28
Q

Data mining

A

Finds hidden patterns, relationships in large databases and infers rules to predict future behavior

29
Q

Establishing an information policy

A

Firm’s rules, procedures, roles for sharing, managing, standardizing data

30
Q

Data administration

A

Firm function responsible for specific policies and procedures to manage data

31
Q

Database administration

A

Defining, organizing, implementing, maintaining database; performed by database design and management group

32
Q

Data cleansing (Data Scrubbing)

A

Software to detect and correct data that are incorrect, incomplete, improperly formatted, or redundant
Enforces consistency among different sets of data from separate information systems

33
Q

Field

A

A grouping of characters into a word, a group of words or a complete number

34
Q

A group of related fields

A

Record

35
Q

A group of related records

A

File

36
Q

Person place thing or event on which we store information

A

Entity

37
Q

Group of related files

A

Database

38
Q

Coupling of data stored in files and the specific programs required to update and maintain those files

A

Program data dependence

Info Systems (3 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions