Brainscape's Knowledge GenomeTM

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


See full index

database > chapter 2 review > Flashcards

chapter 2 review Flashcards

1
Q

what provides for data collection, storage, and retrieval?

A

the information system

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

the information system is composed of six components which are?

A

people
hardware
software
programs
procedures
databases

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

the process that establishes the need for and extent of an information system?

A

system analysis

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

process of creating an information system?

A

system development

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

transforms data into information that forms the basis for decision-making?

A

applications

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

usually, applications produce the following three components?

A

formal reports
tabulations
graphic displays

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

applications are composed of the following two parts

A

data
code

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

program instructions?

A

code

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

performance depends on three factor?
d
a
a

A

database design and implementation

application design and implementation

administrative procedures

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

process of database design and implementation

A

db development

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

implementation phase include?
c
L
p

A

creating database storage and structure

loading data into database storage structure

providing for data management

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

DB design and application development mapped out and evaluated. is the def of?

A

SDLC
system development life cycle

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

SDLC is divided into the following five phases:

A

planning
analysis
detailed system design
implementation
and maintenance

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

general overview of company objectives?

A

planning

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

assessments of flow and extent requirements?
C
M
R

A

should the existing system be continued
should the existing system be modified
should the existing system be replaced

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

study and evaluate alternate solutions by?
T
S
O

A

technical aspects of hardware and software requirements

system costs

operational cost

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

problems defined during the planning phase are examined in greater detail in which stage?

A

analysis

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

t or f : thorough audit of user requirements in the analysis phase

A

true

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

t or f: only hardware systems are being studied

A

false

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

goals of the analysis phase are the understanding of?
S
A
O

A

system function area

actual and potential problems

oppertunities

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

the designer completes the design of the system process in which stage?

A

detailed system design

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

t or f: the designing phase include all necessary technical specification?

A

true

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

hardware, software, DBMS software, and application programs are being installed at which stage?

A

implementation

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

t or f: the cycle of coding, testing, and debugging continues until DB is ready for delivery in the planning phase?

A

false

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

DB is created and the system is customized by?
C
U

A

creating of tables and views

user authorization

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

three types of maintenance activity?
C
A
P

A

corrective maintenance

adaptive maintenance

perfective maintenance

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

produce better systems within a reasonable amount of time and cost?

A

CASE
computer aided systems engineering

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

t or f: CASE produced applications that are unstructured,undocumented, and not standarized?

A

false

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

what are the six phases in the DBLC?
I
D
i L
t e
o
m

A

initial study
design
implementation and loading
testing and evaluation
operation
maintenance and evolution

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

DB initial study overall purpose:
A
D
D
D

A

analyze company situation
define problems and constraints
define objectives
define scope and boundaries

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

t or f: interactive and iterative processes required to complete the first phase of DBLC?

A

True

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

general conditions in which the company operates, its organizational structure, and its mission. is in which stage?

A

initial study

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

t or f: in the initial study, discover what the company’s components are, and how they function, and how they interact.

A

true

34
Q

in the initial study. defining problems and constraints by?
F
F
A

A

formal and informal information sources,

finding precise answers is important ,

accurate problem definition does not always yield a solution.

35
Q

t or f: DB system objectives must correspond to those envisioned by end users?

A

true

36
Q

extent of design according to operational requirements?

A

scope

37
Q

limits external to the system

A

boundaries

38
Q

necessary to concentrate on data characteristics required to build a database model. this is which phase?

A

DB design

39
Q

two views of data within the system:

A

business view

designer view

40
Q

this view described data as an information source.

A

business view

41
Q

this view describes data structure, access, and activities required to transform data into information.

A

designer view

42
Q

actually, implement all design specifications from the previous phase. this phase is?

A

implementation and loading

43
Q

the implementation phase consists of:
i
c
L

A

install DBMS

create the DB

load and converts data

44
Q

creates logical representations of computing resources independent of physical resources?

A

virtualization

45
Q

occurs in parallel with applications programming?

A

testing and evaluation

46
Q

if implementation fails to meet some of the system’s evaluation criteria:
F
m
u

A

fine-tune specific system and DBMS configuration parameters

modify physical or logical design

upgrade hardware or software platforms

47
Q

enforced via proper use of primary, and foreign key rules

A

integrity

48
Q

types of backup recovery:
f
d
t

A

full
differential
transactional

49
Q

once DB passed the evaluation stage, it is considered….

A

operational

50
Q

problems not foreseen during testing surface, the solutions may include:
L
i

A

load-balancing software to distribute transactions among multiple computers

increasing available cache

51
Q

required periodic maintenance include:
P
C
A
G
P
P

A

preventing maintenance (backup)

corrective maintenance(recovery)

adaptive maintenance

assignment of access permissions and their maintenance for new and old users

generation of DB access statistics

periodic security audits

periodic system usage summaries

52
Q

data modeling creates an abstract DB structure, this is the def of?

A

conceptual design

53
Q

t or f: conceptual design embodies a clear understanding of business and its functional area?

A

true

54
Q

how many steps are required in the conceptual design?

A

4

55
Q

discovers data element characteristics and obtains characteristics from different sources?

A

data analysis and requirements

56
Q

t or f: data analysis requires a thorough understanding of the company’s data types and their extent and uses.

A

true

57
Q

designer enforces standards in design documentation in the?

A

entity relationship modeling and normalization

58
Q

t or f: designers use diagrams and symbols, documentation writing style, layout, and other conventions?

A

true

59
Q

is a communication tool as well as design blueprint?

A

ER model

60
Q

verified against proposed system processes?

A

data modeling verification

61
Q

revision of original design consists of:
C
D

A

careful reevaluation of entities

detailed examination of attributes describing entities

62
Q

information system components that handle specific function

A

module

63
Q

subset of a DB stored at a given location

A

DB fragment

64
Q

t or f: portions of DB reside in the same physical location?

A

false

65
Q

t or f: processes accessing the database are the same from one location to another?

A

false

66
Q

common factors affecting purchasing decisions:
C
D
U
P
D

A

cost
DBMS features and tools
underlying model
portability
DBMS hardware requirements

67
Q

translates software independent conceptual model into software dependant model?

A

logical design

68
Q

mapping steps involve:
s
s
w
b
h

A

strong entity
supertype relationship
weak entity
binary relationships
higher degree relationships

69
Q

t or f: all defined constraints must be supported by the logical data model?

A

true

70
Q

special attention should be placed at this stage to ensure security…..

A

is enforced

71
Q

validate logical model integrity constraints ensures that:
A
s

A

all views can be resolved

security is enforced to ensure the privacy of the data

72
Q

validate all logical model definitions against all end-user data, transaction, and security requirements is the….

A

final step in the logical design process

73
Q

process of selecting data storage and data access charactereistics of DB?

A

physical design

74
Q

storage characteristics are a function of:
D
T
D

A

device types supported by hardware

types of data access method supported by system

DBMS

75
Q

t or f: physical design is more complex when data are distributed?

A

true

76
Q

the designer must determine several attributes:
V
U

A

data volume

data usage patterns

77
Q

data storage influence:
L
W
W

A

locations and physical storage organizations for each table

what indexes and the type of indexes to be used for each table

what views and the type of views to be used on each table

78
Q

set of database privileges that could be assigned as a unit to a user or group

A

database role

79
Q

assign security controls by:
S
c

A

specific access rights on DB objects to a user or group of users

can also revoke during operation to assist with backups or maintenance events

80
Q

performance can be affected by characteristics:
s
s
s
a

A

storage media
seek time
sector and block size
and more

81
Q

t or f: fine tuning the DBMS and queries to ensure that they will meet end-user performance requirements

A

true

database (7 decks)

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