Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

database > chapter 2 review > Flashcards

chapter 2 review Flashcards

(81 cards)

Start Studying
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
DB is created and the system is customized by? C U
creating of tables and views user authorization
26
three types of maintenance activity? C A P
corrective maintenance adaptive maintenance perfective maintenance
27
produce better systems within a reasonable amount of time and cost?
CASE computer aided systems engineering
28
t or f: CASE produced applications that are unstructured,undocumented, and not standarized?
false
29
what are the six phases in the DBLC? I D i L t e o m
initial study design implementation and loading testing and evaluation operation maintenance and evolution
30
DB initial study overall purpose: A D D D
analyze company situation define problems and constraints define objectives define scope and boundaries
31
t or f: interactive and iterative processes required to complete the first phase of DBLC?
True
32
general conditions in which the company operates, its organizational structure, and its mission. is in which stage?
initial study
33
t or f: in the initial study, discover what the company's components are, and how they function, and how they interact.
true
34
in the initial study. defining problems and constraints by? F F A
formal and informal information sources, finding precise answers is important , accurate problem definition does not always yield a solution.
35
t or f: DB system objectives must correspond to those envisioned by end users?
true
36
extent of design according to operational requirements?
scope
37
limits external to the system
boundaries
38
necessary to concentrate on data characteristics required to build a database model. this is which phase?
DB design
39
two views of data within the system:
business view designer view
40
this view described data as an information source.
business view
41
this view describes data structure, access, and activities required to transform data into information.
designer view
42
actually, implement all design specifications from the previous phase. this phase is?
implementation and loading
43
the implementation phase consists of: i c L
install DBMS create the DB load and converts data
44
creates logical representations of computing resources independent of physical resources?
virtualization
45
occurs in parallel with applications programming?
testing and evaluation
46
if implementation fails to meet some of the system's evaluation criteria: F m u
fine-tune specific system and DBMS configuration parameters modify physical or logical design upgrade hardware or software platforms
47
enforced via proper use of primary, and foreign key rules
integrity
48
types of backup recovery: f d t
full differential transactional
49
once DB passed the evaluation stage, it is considered....
operational
50
problems not foreseen during testing surface, the solutions may include: L i
load-balancing software to distribute transactions among multiple computers increasing available cache
51
required periodic maintenance include: P C A G P P
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
data modeling creates an abstract DB structure, this is the def of?
conceptual design
53
t or f: conceptual design embodies a clear understanding of business and its functional area?
true
54
how many steps are required in the conceptual design?
4
55
discovers data element characteristics and obtains characteristics from different sources?
data analysis and requirements
56
t or f: data analysis requires a thorough understanding of the company's data types and their extent and uses.
true
57
designer enforces standards in design documentation in the?
entity relationship modeling and normalization
58
t or f: designers use diagrams and symbols, documentation writing style, layout, and other conventions?
true
59
is a communication tool as well as design blueprint?
ER model
60
verified against proposed system processes?
data modeling verification
61
revision of original design consists of: C D
careful reevaluation of entities detailed examination of attributes describing entities
62
information system components that handle specific function
module
63
subset of a DB stored at a given location
DB fragment
64
t or f: portions of DB reside in the same physical location?
false
65
t or f: processes accessing the database are the same from one location to another?
false
66
common factors affecting purchasing decisions: C D U P D
cost DBMS features and tools underlying model portability DBMS hardware requirements
67
translates software independent conceptual model into software dependant model?
logical design
68
mapping steps involve: s s w b h
strong entity supertype relationship weak entity binary relationships higher degree relationships
69
t or f: all defined constraints must be supported by the logical data model?
true
70
special attention should be placed at this stage to ensure security.....
is enforced
71
validate logical model integrity constraints ensures that: A s
all views can be resolved security is enforced to ensure the privacy of the data
72
validate all logical model definitions against all end-user data, transaction, and security requirements is the....
final step in the logical design process
73
process of selecting data storage and data access charactereistics of DB?
physical design
74
storage characteristics are a function of: D T D
device types supported by hardware types of data access method supported by system DBMS
75
t or f: physical design is more complex when data are distributed?
true
76
the designer must determine several attributes: V U
data volume data usage patterns
77
data storage influence: L W W
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
set of database privileges that could be assigned as a unit to a user or group
database role
79
assign security controls by: S c
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
performance can be affected by characteristics: s s s a
storage media seek time sector and block size and more
81
t or f: fine tuning the DBMS and queries to ensure that they will meet end-user performance requirements
true

database (7 decks)

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