Brainscape's Knowledge GenomeTM

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


See full index

INTE 1000 > INTE 1000 Ch03 SG > Flashcards

INTE 1000 Ch03 SG Flashcards

1
Q

Bits, characters, fields, records, files, and databases.

H______ of D______

A

Hierarchy of Data

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

An approach to data management where multiple information systems share a pool of related data

D______________ A____________ to D_______ M_______________

A

Database Approach to Data Management

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

A climate-controlled building or set of buildings that house database servers and the systems that delivers mission-critical information and services.

D________ C___________

A

Data Center

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

Data modeling done at the level of the entire enterprise

E____________ D_______ M__________

A

Enterprise Data Modeling

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

A database model that describes data in which all data elements are placed in two-dimensional tables, called relations, which are the logical equivalent of files
R___________ M__________

A

Relational Model

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

A skilled IS professional who directs all activities related to an organizations database

D____________ A___________

A

Database Administrator (DBA)

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

A general class of people, places, or things for which data is collected, stored, and maintained

E_______

A

Entity

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

A characteristic of an entity

A______________

A

Attribute

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

The specifics value of an attribute

D____ I____

A

Data Item

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

A diagram of data entities and their relationship

D_____ M_____

A

Data Model

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

Data models that use basic graphical symbols to show the organization of relationships between data.

E_______-R_______ D________

A

Entity-Relationship Diagrams

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

The process of looking for and fixing inconsistencies to ensure that data is accurate and complete

D____ C________

A

Data Cleanup

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

A collection of instructions and commands used to define and describe data and relationships in a specific database

D_____ D_________ L_________

A

Data Definition Language (DDL)

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

A specific language, provided with a DBMS, which allows users to access and modify the data, to make queries, and to generate reports

A

D____ M________ L__________ (DML)

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

A method of dealing with a situation in which two or more users or applications need to access the same record at the same time.

C__________ C_______

A

Concurrentcy Control

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

A nontechnical position responsible for defining and implementing consistent principles for a variety of data issues.

D____ A_____________

A

Data Administrator

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

A detailed description of all the data used in the database

D______ D___________

A

Data Dictionary

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

A description of the entire database

S______

A

Scheme

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

An approach to data management whereby each distinct operational system uses data files dedicated to that system

T________ A_______ to D____ M_________

A

Traditional Approach to Data Management

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q 
TF
An attribute is a general class of people, places, or things for which data is collected, stored, and maintained.
A

F

Entity

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

TF
Today, a few organizations use the database approach to data management, where multiple information systems share a pool of related data

A

F

Many?

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

TF
Business and technology vendors are working to develop blue data centers that run more efficiently and require less energy for processing and cooling

A

F

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

TF
Microsoft built a data center taking up 16 football fields of space filled with 220 shipping containers packed with servers

A

T

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

TF

A data model is a diagram of data attributes and their relationships

A

F

Relational?

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

TF
Oracle is currently the market leader in general purpose databases, with about three-fourths of the multimillion dollar database market

A

F

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

TF

The relational database model is by far the most widely used

A

T

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

TF
The Database Administrator is an important non-technical position responsible for defining and implementing consistent principles for a variety of data issues, including setting data standards and data definitions that apply across all the databases in an organization

A

F

Data administrator

28
Q

TF
Business intelligence is gained through industrial espionage and the gathering of this information often includes illegal or unethical means

A

F

29
Q

TF

Online Analytical Processing and data mining are essentially the same thing

A

F

30
Q

Without a well-designed, accurate _________, executives, managers, and others do not have access to the information they need to make good decisions.

A

_database

31
Q

A collection of related records is called a(n) ___________

A

-file

32
Q

A(n) __________ is a field or set of fields that uniquely identifies a record.

A

-primary field

33
Q

Traditional data centers consist of warehouses filled with row upon row of ___________ racks and powerful cooling systems to compensate for the heat generated by the processors.

A

-server

34
Q

When creating backup databases, some companies use software to eliminate any duplicated data to save capacity and reduce costs, an approach some call data __________

A

-deduplication

35
Q

_________ use basic graphical symbols to show the organization of and relationships between data.

A

-entity-relationship diagrams

36
Q

The _____ data model has become the most popular database model

A

-relational

37
Q

___________ involves eliminating columns in a table

A

-projecting

38
Q

The purpose of ____________ is to develop data that is accurate, complete, economical, flexible, reliable, relevant, simple, timely, verifiable, accessible, and secure

A

-data cleanup

39
Q

The ____________ is a collection of instructions and commands used to describe the logical an physical structure of the data and the relationships among the data for each user

A

-data definition language

40
Q

___________ control can be used to avoid potential problems when two or more users attempt to access the same record at the same time

A

-concurrency

41
Q

______________ lets programmers learn one powerful query language and use it on systems ranging from PCs to the largest mainframe computers

A

-SQL

42
Q

A(n) ___________ is an individual who is expected to have a clear understanding of the fundamental business of the organization, be proficient in the use of selected database management systems, and stay abreast of emerging technologies and new design approaches.

A

-database administrator

43
Q

A(n) __________ is an individual responsible for defining and implementing consistent principles for a variety of data issues

A

-data administrator

44
Q

Developing a seamless integration of databases with the Internet is sometimes called a _____________

A

-semantic web

45
Q

A group of program that manipulate the database and provide an interface between the database and the user of the database and other application programs

D___________ M___________ S____________ (DBMS)

A

Database Management System (DBMS)

46
Q
  1. A database _____.
    a.
    is accessed primarily for use by the organization’s database administrator and data administrator
    c.
    is a collection of unstructured data
    b.
    provides an essential foundation for an organization’s knowledge management and artificial intelligence systems
    d.
    helps companies reduce costs, increase profits, track past business activities, and open new market opportunities
A

D

47
Q

DATABASE MANAGEMENT SYSTEM (DBMS): A group of programs that m___________ the database and provide an i_________ between the database and the user of the database and other application programs.

A

DATABASE MANAGEMENT SYSTEM (DBMS): A group of programs that manipulate the database and provide an interface between the database and the user of the database and other application programs.

48
Q

HIERARHY OF DATA: B____, c__________, f______, r______, f_______, and d__________

A

HIERARHY OF DATA: Bits, characters, fields, records, files, and databases

49
Q

DATABASE APPROACH TO DATA MANAGEMENT: An approach to data management where m_________ i___________ s_________ share a pool of related data

A

DATABASE APPROACH TO DATA MANAGEMENT: An approach to data management where multiple information systems share a pool of related data

50
Q

D____ C_______: A climate-controlled building or set of buildings that house database servers and the systems that delivers mission-critical information and services.

A

DATA CENTER: A climate-controlled building or set of buildings that house database servers and the systems that delivers mission-critical information and services.

51
Q

ENTERPRISE DATA MODELING: Data modeling done at the level of the entire e___________.

A

ENTERPRISE DATA MODELING: Data modeling done at the level of the entire enterprise.

52
Q

RELATIONAL MODEL: A database model that describes data in which all data elements are placed in two-dimensional tables, called r_________, which are the logical equivalent of files.

A

RELATIONAL MODEL: A database model that describes data in which all data elements are placed in two-dimensional tables, called relations, which are the logical equivalent of files.

53
Q

DATABASE ADMINISTRATOR (DBA): A skilled IS professional who directs a__ activities related to an organizations database.

A

DATABASE ADMINISTRATOR (DBA): A skilled IS professional who directs all activities related to an organizations database.

54
Q

E______: A general class of people, places, or things for which data is collected, stored, and maintained.

A

ENTITY: A general class of people, places, or things for which data is collected, stored, and maintained.

55
Q

A__________: A characteristic of an entity.

A

ATTRIBUTE: A characteristic of an entity.

56
Q

DATA I____: The specific value of an attribute.

A

DATA ITEM: The specific value of an attribute.

57
Q

D_____ M_____: A diagram of data entities and their relationship

A

DATA MODEL: A diagram of data entities and their relationship

58
Q

E______-R____________(ER) D__________: Data models that use basic graphical symbols to show the organization of relationships between data.

A

ENTITY-RELATIONSHIP(ER) DIAGRAMS: Data models that use basic graphical symbols to show the organization of relationships between data.

59
Q

DATA C________: The process of looking for and fixing inconsistencies to ensure that data is accurate and complete.

A

DATA CLEANUP: The process of looking for and fixing inconsistencies to ensure that data is accurate and complete.

60
Q

DATA D___________ L__________ (DDL): A collection of instructions and commands used to define and describe data and relationships in a specific data base.

A

DATA DEFINITION LANGUAGE (DDL): A collection of instructions and commands used to define and describe data and relationships in a specific data base.

61
Q

D____ M_____________ L___________ (DML): A specific language, provided with a DBMS, which allows users to access and modify the data, to make queries, and to generate reports.

A

DATA MANIPULATION LANGUAGE (DML): A specific language, provided with a DBMS, which allows users to access and modify the data, to make queries, and to generate reports.

62
Q

C______________ CONTROL: A method of dealing with a situation in which tow or more users or applications need to access the same record at the same time.

A

CONCURRENTCY CONTROL: A method of dealing with a situation in which tow or more users or applications need to access the same record at the same time.

63
Q

D_____ A________________: A nontechnical position responsible for defining and implementing consistent principles for a variety of data issues.

A

DATA ADMINISTRATOR: A nontechnical position responsible for defining and implementing consistent principles for a variety of data issues.

64
Q

DATA L_____________: A detailed description of all the data used in the database.

A

DATA LANGUAGE: A detailed description of all the data used in the database.

65
Q

S________: A description of the entire database.

A

SCHEMA: A description of the entire database.

66
Q

T_____________ APPROACH TO D____ M__________: An approach to data management whereby each distinct operational system uses data files dedicated to that system.

A

TRADITIONAL APPROACH TO DATA MANAGEMENT: An approach to data management whereby each distinct operational system uses data files dedicated to that system.

INTE 1000 (3 decks)

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