Question: What is true about creating an entity relationship diagram?
Answer Choices: There will be at most seven entities
There will be at most seven relationships
It is an iterative process
Entities will have at most seven attributes
If you identify more than seven entities, analyze and combine until you have seven or less
Answer: It is an iterative process
Question: The two methods to validate that an ERD is well formed are _______.
Answer Choices: Balancing with process models and renaming theory
Balancing with process models and following design guidelines created by Chen
Renaming theory
Normalization and balancing with process models
Normalization and following design guidelines created by Chen
Answer: Normalization and balancing with process models
Question: Tom is trying to change his Use Case into a Data Flow Diagram. He has found that a use case step generally is the same as a __________ on the Level 1 Data Flow diagram.
Answer Choices: Data flow
Data store
Internal Entity
Process
External Entity
Answer: Process
Question: Processes in data flow diagramming are represented by:
Answer Choices: Rounded boxes
Arrows
Circles
Enclosed rectangles
Rectangles that is open on the right end
Answer: Rounded boxes
Question: The first step in creating a data model is to:
Answer Choices: Identify the relationships between entities
Identify the data flows from the level 0 DFD diagram
Identify the entities
Identify the processes, data flows, and data stores
Identify the attributes for each entity
Answer: Identify the entities
Question: Carlos has a Level 0 DFD diagram where one of the external entities is the “Internal Revenue Service” – and he has a data store called “Tax Rate Table”. He has drawn a data flow arrow from the Internal Revenue Service to the data store as the data has been loaded into the Tax Rate Table prior to the processing. What would be true?
Answer Choices: This is incorrect, ‘data at rest stays at rest until moved by a process’ so he needs a process (like ‘load Tax Rate Table’) first in this system
This is almost correct. The context diagram would be a shed line indicating that the loading of the data was implied prior to the start of this process
This is incorrect – he doesn’t need a data flow as the data was loaded into the Tax Rate Table someplace else (within the payroll system someplace, but not in this process)
This is incorrect. What should happen is an ‘external process’ should be called at the start of the process – like “Call IRS for data load”
This is correct
Answer: This is incorrect, ‘data at rest stays at rest until moved by a process’ so he needs a process (like ‘load Tax Rate Table’) first in this system
Question: Charuria is balancing her DFD. This means she is:
Answer Choices: Making sure that each data store has at least one input data flow and at least one output data flow
Making sure that all information presented at one level is accurately represented in the next level
Making sure that all data flows have noun names
Making sure that each process has at least one input data flow and at least one output data flow
Making sure that all processes start with action verb phrases
Answer: Making sure that all information presented at one level is accurately represented in the next level
Question: When normalizing data models, if you take attributes that have multiple values for a single instance of an entity and create separate entities for those attributes you are moving from:
Answer Choices: Dependent normal form (DNF) to Independent normal form (INF)
2nd normal form (2NF) to 3rd normal form (3NF)
0 normal form (0NF) to 1st normal form (1NF)
Generalized normal form (GNF) to fully normalized form (FNF)
1st normal form (1NF) to 2nd normal form (2NF)
Answer: 0 normal form (0NF) to 1st normal form (1NF)
Question: The last step in creating basic ERD’s is to:
Answer Choices: Define attributes and assign identifiers
Identify relationships
Compile them with Java
Recognize entities
Test them with users
Answer: Identify relationships
Question: Logical process models are:
Answer Choices: Models based upon implementing the if-then-else programming structure
Created in the system walkthrough
Models that describe processes without regard to how they are conducted
Developed by the infrastructure analyst
Coded logic models
Answer: Models that describe processes without regard to how they are conducted
Question: The MOST important reason for creating process models is to:
Answer Choices: Provide consistency in the design and implementation
Reduce errors in programming
Reduce cost of programming
Gain a better understanding of the functional requirements of the system
Gain management approval
Answer: Gain a better understanding of the functional requirements of the system
Question: The context diagram shows:
Answer Choices: All data stores used in the system
All major steps in a process model
All steps of a particular process
The system and how it interacts with external entities
All functions of the system
Answer: The system and how it interacts with external entities