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