Brainscape's Knowledge GenomeTM

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


See full index

C175 Data Management Foundations > Lesson 1 > Flashcards

Lesson 1 Flashcards

1
Q

Database

A

A shared, integrated computer structure that stores a collection of related data.

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

Data Management

A

A process that focuses on data collection, storage, and retrieval. Common data management functions include addition, deletion, modification, and listing

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

What are the two types of data in a database?

A
  • end-user data (raw facts)

- Metadata

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

Metadata

A

Data about data; that is, data about data characteristics and relationships

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

Database Management Systems (DBMS)

A

The collection of programs that manages the database structure and controls access to the data stored in the database.

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

What are the advantages of a DBMS?

A
  • Improved data security
  • Better data integration
  • Minimized data inconsistency
  • Improved data access
  • Improved decision making
  • Increased end-user productivity
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Data inconsistency

A

A condition in which different versions of the same data yield different (inconsistent) results.

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

Query

A

A question or task asked by an end user of a database in the form of SQL code. A specific request for data manipulation issued by the end user or the application to the DBMS.

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

Ad hoc query

A

A “spur-of-the-moment” question

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

Query result set

A

The collection of data rows returned by a query.

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

Data quality

A

A comprehensive approach to ensuring the accuracy, validity, and timeliness of data.

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

Single-user database

A

A database that supports only one user at a time

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

Desktop database

A

A single-user database that runs on a personal computer.

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

Multiuser database

A

A database that supports multiple concurrent users

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

Workgroup database

A

A multiuser database that usually supports fewer than 50 users or is used for a specific department in an organization.

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

Enterprise database

A

The overall company data representation, which provides support for present and expected future needs.

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

Centralized database

A

A database located at a single site

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

Distributed database

A

A logically related database that is stored in two or more physically independent sites.

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

Cloud database

A

A database that is created and maintained using cloud services, such as Microsoft Azure or Amazon AWS

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

General-purpose database

A

A database that contains a wide variety of data used in multiple disciplines.

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

Discipline-specific database

A

A database that contains data focused on specific subject areas

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

Operational database

A

A database designed primarily to support a company’s day-to-day operations.

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

An operational database is also known as:

A
  • online transaction processing database (OLTP)
  • Transactional database
  • production database
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Data warehouse

A

A specialized database that stores historical and aggregated data in a format optimized for decision support.

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

Online analytical processing (OLAP)

A

A set of tools that provide advanced data analysis for retrieving, processing, and modeling data from the data warehouse

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

Business intelligence

A

A set of tools and processes used to capture, collect, integrate, store, and analyze data to support business decision making

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

Unstructured data

A

Data that exists in its original, raw state; that is, in the format in which it was collected

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

Structured data

A

Data that has been formatted to facilitate storage, use, and information generation.

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

Digital data

A

It represents other forms of data using specific machine language systems that can be interpreted by various technologies

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

Semistructured data

A

Data that has already been processed to some extent

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

Extensible Markup Language (XML)

A

A metalanguage used to represent and manipulate data elements. Unlike other markup languages, XML permits the manipulation of a document’s data elements.

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

XML database

A

A database system that stores and manages semistructured XML data.

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

NoSQL

A

A new generation of database management systems that is not based on the traditional relational database model

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

Database design

A

The process that yields the description of the database structure and determines the database components. The second phase of the Database Life Cycle

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

Analytical Database

A

A database focused primarily on storing historical data and business metrics used for tactical or strategic decision making

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

Data processing (DP) specialist

A

The person responsible for developing and managing a computerized file processing system

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

Record

A

Contains a set of fields that describes a person, place, or thing. It is a collection of data items arranged for processing by a program.

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

Field

A

Contains all the information within the table appropriate to a particular entity. It is a data structure for a single piece of data.

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

File

A

Stores data, information, settings, or commands that are used in computation. It is a collection of related records.

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

What are the two file systems?

A
  • Manual

- Computerized

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

Manual file system

A

Includes paper-and-pencil system to facilitate the expected use of data

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

Computerized file system

A
  • Stores and organizes computer files and makes data easy to find and access them
  • Generates reports and keeps track of complex data
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
43
Q

Structural dependence

A

A data characteristic in which a change in the database schema affects data access, thus requiring changes in all access programs

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

Structural independence

A

A data characteristic in which changes in the database schema do not affect data access

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

Data dependence

A

A data condition in which data representation and manipulation are dependent on the physical data storage characteristics

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

Data independence

A

A condition in which data access is unaffected by changes in the physical data storage characteristics

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

Logical data format

A

The way a person views data within the context of a problem domain

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

Physical data format

A

The way a computer “sees” (stores) data.

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

Data redundancy

A

Exists when the same data is stored unnecessarily at different places

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

Uncontrolled data redundancy sets the stage for the following:

A
  • Poor data security
  • Data inconsistency
  • Data-entry errors
  • Data integrity problems
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
51
Q

Data integrity

A

In a relational database, a condition in which the data in the database complies with all entity and referential integrity constraints.

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

Data anomaly

A

A data abnormality in which inconsistent changes have been made to a database. For example, an employee moves, but the address change is not corrected in all files in the database.

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

Database system

A

An organization of components that defines and regulates the collection, storage, management, and use of data in a database environment

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

From a general management point of view, the database system is composed of the five major parts:

A
  • Hardware
  • Software
  • People
  • Procedures
  • Data
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
55
Q

Data dictionary

A

The data dictionary contains data definitions as well as data characteristics and relationships. May also include data that is external to the DBMS

56
Q

Performance tuning

A

Activities that make a database perform more efficiently in terms of storage and access speed

57
Q

Query language

A

A nonprocedural language that is used by a DBMS to manipulate its data. An example of a query language is SQL.

58
Q

DBMS function: Security Management

A

Sets rules that determine specific users that are allowed to access the database. This function also sets restraints on what specific data any user can see or manage.

59
Q

DBMS function: Data transformation and presentation

A

Exists to transform any data entered into required data structures. By using this function, the DBMS can determine the difference between logical and physical data formats.

60
Q

DBMS function: data dictionary management

A

Removes structural and data dependency and provides the user with data abstraction. The DBMS uses this function to look up the required data component structures and relationships.

61
Q

DBMS software

A

manages the database within the database system. Some examples of DBMS software include Microsoft’s SQL Server, Oracle Corporation’s Oracle, Oracle’s MySQL, and IBM’s DB2

62
Q

Application programs and utility software

A

used to access and manipulate data in the DBMS and to manage the computer environment in which data access and manipulation take place

63
Q

System analysts and programmers

A

design and implement the application programs. They design and create the data-entry screens, reports, and procedures through which end users access and manipulate the database’s data

64
Q

End Users

A

the people who use the application programs to run the organization’s daily operations

65
Q

DBMS function: Multiuser access control

A

To provide data integrity and data consistency, the DBMS uses sophisticated algorithms to ensure that multiple users can access the database concurrently without compromising its integrity.

66
Q

DBMS function: data integrity management

A

promotes and enforces integrity rules, thus minimizing data redundancy and maximizing data consistency.

67
Q

DBMS function: Database communication interfaces

A

A current-generation DBMS accepts end-user requests via multiple, different network environments.
For example web browsers like Mozilla Firefox

68
Q

____ ____ exists when different and conflicting versions of the same data appear in different places.

A

Data inconsistency

69
Q

One disadvantage of the DBMS is that it increases the risk of data security breaches (T/F)

A

True

70
Q

Data processing can be as simple as organizing data to reveal patterns (T/F)

A

True

71
Q

The database structure itself is stored as a collection of files, and the only way to access the data in those files is through the DBMS. (T/F)

A

True

72
Q

Accurate, relevant, and timely information is the key to _______.

A

Data Management

73
Q

Data is said to be verifiable if:

A

The data always yields consistent results

74
Q

A(n) ______ database is used by an organization and supports many users across many departments.

A

Enterprise

75
Q

A _____ contains at least all of the attribute names and characteristics for each table in the system.

A

Data dictionary

76
Q

A(n) ____ _____ develops when all required changes in the redundant data are not made successfully

A

Data anormaly

77
Q

Raw data must be properly ______ for storage, processing, and presentation

A

formatted

78
Q

_______ are the result of formatting disorganized data in order to facilitate storage, use and generation of information.

A

Structured data

79
Q

An XML database supports the storage and management of _____ XML data.

A

Semistructured

80
Q

The term ______ __ _______ refers to scattered locations storing the same basic data.

A

Islands of information

81
Q

Which of the following is true of spreadsheet applications?

A

They enhance the user’s ability to understand the data.

82
Q

One advantage of a database system over previous data management approaches is that the database system is considerably less complex. (T/F)

A

False

83
Q

The DBMS uses the _____ ____ to look up the required data component structures and relationships, thus relieving programmers from having to code such complex relationships in each program.

A

Data dictionary

84
Q

Corporations use only structured data. (T/F)

A

False

85
Q

An operational database is sometimes referred to as an enterprise database. (T/F)

A

False

86
Q

The organization of data within folders in a manual file system is determined by _____.

A

its expected use

87
Q

Most data that can be encountered are best classified as _____ .

A

Semistructured

88
Q

_____ refer to a type of database that stores most of its data in RAM rather than in hard disks.

A

In-memory databases

89
Q

To reveal meaning, information requires ______

A

context

90
Q

____ _____ is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions.

A

Data integrity

91
Q

________ is the result of processing raw data to reveal its meaning

A

Information

92
Q

Raw data must be properly ______ for storage, processing and presentation.

A

formatted

93
Q

A _____ is a logically connected set of one or more fields that describes a person, place, or thing.

A

Record

94
Q

A data warehouse can store data derived from many sources. (T/F)

A

True

95
Q

Metadata describe the data characteristics and the set of relationships that links the data found within the database. (T/F)

A

True

96
Q

End-user data is ______.

A

Raw facts of interest to the end user

97
Q

A(n) _____ database supports a relatively small number of users (usually fewer than 50) or a specific department within an organization.

A

Workgroup

98
Q

Data processing can be as simple as organizing data to reveal patterns. (T/F)

A

True

99
Q

_____ exists when different versions of the same data appear in different places.

A

Data inconsistency

100
Q

_____ is the result of revealing the meaning of raw facts.

A

Information

101
Q

________ ________ relates to activities that make a database operate more efficiently in terms of storage and access speed.

A

Performance Tuning

102
Q

A ______ is a specific request issued to the DBMS for data manipulation.

A

Query

103
Q

_____ relates to the activities that make the database execute transactions more efficiently in terms of storage and access speed.

A

Performance Tuning

104
Q

________ is data about data through which the end-user data are integrated and managed.

A

Metadata

105
Q

The DBMS reveals much of the database’s internal complexity to the application programs and users. (T/F)

A

False

106
Q

Field refers to a collection of related records. (T/F)

A

False

107
Q

Which of the following refers to the situation where the same data is stored unnecessarily at different places?

A

Data redundancy

108
Q

________ is the result of processing raw data to reveal its meaning

A

information

109
Q

________ is a special language used to represent and manipulate data elements in a textual format.

A

Extensible Markup Language (XML)

110
Q

Database programming languages receive all application requests and translate them into the complex operations required to fulfill those requests. (T/F)

A

False

111
Q

Data constitute the building blocks of information. (T/F)

A

True

112
Q

The same data might be simultaneously structured and unstructured depending on the intended processing. (T/F)

A

True

113
Q

An advantage of database systems is that you don’t need to perform frequent updates and apply the latest patches. (T/F)

A

False

114
Q

The database structure in a DBMS is stored as a ______.

A

collection of files

115
Q

The response of the DBMS to a query is the ______.

A

query result set

116
Q

_____ data exist in the format in which they were collected.

A

Unstructured

117
Q

_____ data exist in a format that does not lend itself to processing that yields information.

A

Unstructured

118
Q

A _______ ________ ______ is a collection of programs that manages the database structure and controls access to the data stored in the database.

A

database management system

119
Q

Structural dependence exists when it is possible to make changes in the file structure without affecting the application program’s ability to access the data. (T/F)

A

False

120
Q

An ________ is a spur-of-the-moment question

A

ad hoc query

121
Q

________ exists when it is possible to make changes in the data storage characteristics without affecting an application program’s ability to access data.

A

data independence

122
Q

__________ exists when the same data are stored unnecessarily at different places.

A

Data redundancy

123
Q

A desktop database is a _____ database

A

single-user

124
Q

_____ serve as the intermediary between the user and the database.

A

DBMSs

125
Q

Data warehouse contains historical data obtained from the_____.

A

Operational Databases

126
Q

A _____ is a collection of related records.

A

File

127
Q

A(n) _______ _______ develops when all required changes in the redundant data are not made successfully.

A

Data anomaly

128
Q

____ ________ exists when different and conflicting versions of the same data appear in different places.

A

Data inconsistency

129
Q

The term _____ refers to an organization of components that define and regulate the collection, storage, management and use of data within a database environment.

A

Database system

130
Q

Data anomaly is defined as the condition in which all of the data in the database are consistent with the real-world events and conditions. (T/F)

A

False

131
Q

A _____ is a character or group of characters that has a specific meaning.

A

Field

132
Q

_______ databases focus primarily on storing data used to generate information required to make tactical or strategic decisions.

A

Analytical

133
Q

______ provide a description of the data characteristics and the set of relationships that link the data found within the database.

A

Metadata

134
Q

A(n) _____ might be written by a programmer or it might be created through a DBMS utility program.

A

application

135
Q

A workgroup database is a(n) _____ database.

A

multiuser

C175 Data Management Foundations (8 decks)

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