1What is another name for a data dictionary?
data repository
2What does a data dictionary serve as?
a reference work of data about data (metadata)
3What is the central storehouse of information about the system’s data called?
data dictionary
4What is the purpose of a data dictionary document in an organisation?
to collect and coordinate specific data terms and confirm their meaning
5What is one use of a data dictionary related to documentation?
provide documentation
6How does a data dictionary help with redundancy?
eliminates redundancy
7How does a data dictionary support a Data Flow Diagram?
validates the DFD for completeness and accuracy
8What can a data dictionary help develop at the beginning of design?
screens and reports
9What does a data dictionary determine about stored files?
the contents of data stored in files
10What process logic can be developed using a data dictionary?
data flow diagram processes
11What does the “Name” in an external entity describe?
as it appears on the DFDs
12What does the “Description” of an external entity explain?
the entity and its purpose
13What are “Input data flows” of an external entity?
DFD names for data flows into the entity
14What are “Output data flows” of an external entity?
DFD names for data flows from the entity
15What does the “Name” in a process describe?
process name and number as on the DFDs
16What does the “Description” of a process explain?
brief statement of the process’s purpose
17What are “Input data flows” of a process?
DFD names for data flows entering the process
18What are “Output data flows” of a process?
DFD names for data flows leaving the process
19What is a “Process description” used for?
documents detailed steps using structured English (pseudocode)
20What does the “Name” in a data flow represent?
as it appears on the DFDs
21What does the “Description” of a data flow explain?
the data flow and its purpose
22What is the “Origin” of a data flow?
the DFD beginning or source of the data flow
23What is the “Destination” of a data flow?
the DFD ending point for the data flow
24What is another name for a data structure in a data flow?
record
25What does the “Name” in a data store describe?
as it appears on the DFDs
26What does the “Description” of a data store explain?
the data store and its purpose
27What are “Input data flows” of a data store?
DFD names for data flows entering the store
28What are “Output data flows” of a data store?
DFD names for data flows leaving the store
29What is another name for a data structure in a data store?
record
30What does “=” mean in algebraic notation?
is composed of
31What does “+” mean in algebraic notation?
and
32What do { } indicate in algebraic notation?
repetitive elements, repeating groups, or tables
33What do \[ ] represent in algebraic notation?
either/or situation
34What do ( ) represent in algebraic notation?
optional element
35What is a data element name?
a unique identifier for the element
36What does the description of a data element explain?
its purpose
37What does the “Type” of a data element describe?
whether it is alphanumeric, numeric, etc.
38What does the “Length” of a data element specify?
the size of the element
39What does the “Output format” of a data element define?
the form in which the element is displayed
40What does an Entity Relationship Diagram (ERD) show?
the logical relationship and interaction among system entities
41What does an ERD provide overall?
a view of the system and a blueprint for creating physical structures
42What is the first step in drawing an ERD?
list identified entities and consider their relationships
43How are entities labelled in an ERD?
with singular nouns
44How are relationships labelled in an ERD?
with verbs
45What does a One-to-One (1:1) relationship mean?
one instance of the second entity occurs for each instance of the first
46What does a One-to-Many (1\:M) relationship mean?
one occurrence of the first entity can relate to many of the second
47What does a Many-to-Many (M\:N) relationship mean?
instances of both entities can relate to many of each other
48What is often used to link two entities in an M\:N relationship?
an associative entity with attributes
49What does cardinality describe in ER modelling?
the numeric relationship between two entities
50What notation is commonly used to represent cardinality?
Crow’s foot notation
51What does Crow’s Foot notation use to show possibilities?
circles, bars, symbols