Question 1

Lines on an ERD diagram indicate:

Accepted Answer

A) Hierarchies between processes 
B) Relationships among the data 
C) Plurality of data items 
D) Uniqueness of data items 
E) Primary keys 
A) Hierarchies between processes 
B) Relationships among the data 
C) Plurality of data items 
D) Uniqueness of data items 
E) Primary keys

Question 2

Jack is developing an ERD for a small dental practice office patient record system.The dental practice has three dentists,six hygienists,and many patients.A patient is always assigned to the same dentist for all appointments.In particular,he is working on the relationship between dentists and patients.Should it be:

Accepted Answer

A) 1 to 1,with a modality of null 
B) 1 to many with a modality of not null 
C) Many to many with a modality of null 
D) Many to many with a modality of not null 
E) 1 to many with a modality of null 
A) 1 to 1,with a modality of null 
B) 1 to many with a modality of not null 
C) Many to many with a modality of null 
D) Many to many with a modality of not null 
E) 1 to many with a modality of null

Question 3

The last step in creating basic ERD's is to:

Accepted Answer

A) Identify relationships 
B) Define attributes and assign identifiers 
C) Recognize entities 
D) Test them with users 
E) Compile them with Java 
A) Identify relationships 
B) Define attributes and assign identifiers 
C) Recognize entities 
D) Test them with users 
E) Compile them with Java

Question 4

The three major parts of an ERD diagram are:

Accepted Answer

A) Process,data flow,data store 
B) Attribute,modularity,cardinality 
C) Relationship,data flow,entity 
D) Relationship,attribute,entity 
E) Process,entity and relationship 
A) Process,data flow,data store 
B) Attribute,modularity,cardinality 
C) Relationship,data flow,entity 
D) Relationship,attribute,entity 
E) Process,entity and relationship

Question 5

An ERD is a picture that shows how data and information is processed and transformed by a business system.

Accepted Answer

A) True 
 B)False

Question 6

An analyst can read an ERD to discover the individual pieces of information in a system and how they are organized and related to each other.

Accepted Answer

A) True 
 B)False

Question 7

During the analysis phase,analysts create programming models to represent how the business system will operate.

Accepted Answer

A) True 
 B)False

Question 8

ERD's and DFD's are two techniques for process modeling.

Accepted Answer

A) True 
 B)False

Question 9

On an ERD,similar kinds of information are listed together and placed inside boxes called data containers.

Accepted Answer

A) True 
 B)False

Question 10

The three steps in creating an ERD are: (1)identify the entities;(2)identify the attributes;(3)identify the relationships

Accepted Answer

A) True 
 B)False

Question 11

An entity:

Accepted Answer

A) Is the association between two related processes 
B) Has cardinality (1:1,1:N,or M:N) 
C) Shows if it can be null or no null 
D) Is a person,place or thing 
E) Is described with a verb phrase 
A) Is the association between two related processes 
B) Has cardinality (1:1,1:N,or M:N) 
C) Shows if it can be null or no null 
D) Is a person,place or thing 
E) Is described with a verb phrase

Question 12

What is true about creating an entity relationship diagram?

Accepted Answer

A) There will be at most seven entities 
B) There will be at most seven relationships 
C) If you identify more than seven entities,analyze and combine until you have seven or less 
D) It is an iterative process 
E) Entities will have at most seven attributes 
A) There will be at most seven entities 
B) There will be at most seven relationships 
C) If you identify more than seven entities,analyze and combine until you have seven or less 
D) It is an iterative process 
E) Entities will have at most seven attributes

Question 13

Information in the data dictionary is called: _______________

Accepted Answer

A) Metadata 
B) Cached information 
C) Compiled data 
D) Data repository 
E) File silo 
A) Metadata 
B) Cached information 
C) Compiled data 
D) Data repository 
E) File silo

Question 14

What type of process is creating an ERD?

Accepted Answer

A) Well defined process 
B) Sequential process 
C) Process defined by five steps 
D) Iterative process 
E) User defined process 
A) Well defined process 
B) Sequential process 
C) Process defined by five steps 
D) Iterative process 
E) User defined process

Question 15

Independent entities are:

Accepted Answer

A) When a child requires attributes from the parent 
B) When there is only one entity for a data process model 
C) When an entity can exist without the help of another entity 
D) Where the entity identifier is also the primary key 
E) When an entity comes from an external source (aka 'external entity') 
A) When a child requires attributes from the parent 
B) When there is only one entity for a data process model 
C) When an entity can exist without the help of another entity 
D) Where the entity identifier is also the primary key 
E) When an entity comes from an external source (aka 'external entity')

Question 16

In creating ERD's,which would most likely NOT be a source for entities?

Accepted Answer

A) Use cases 
B) Level 0 DFD diagrams 
C) External entities 
D) Data flows 
E) Cost / benefit reports 
A) Use cases 
B) Level 0 DFD diagrams 
C) External entities 
D) Data flows 
E) Cost / benefit reports

Question 17

The three steps in creating an ERD are: (1)identify the entities;(2)identify the processes;(3)identify the relationships

Accepted Answer

A) True 
 B)False

Question 18

In defining LAST-NAME in the data dictionary,we might describe it as a character field having from 1 to 15 alphabetic characters.

Accepted Answer

A) True 
 B)False

Question 19

One of the first places to start developing Entity Relationship Diagrams is by looking at the level 0 process models (DFD)and the use cases for data flows and data stores.

Accepted Answer

A) True 
 B)False

Question 20

Which would likely be an entity on a car insurance ERD?

Accepted Answer

A) date 
B) Gender 
C) company 
D) fire district 
E) Car 
A) date 
B) Gender 
C) company 
D) fire district 
E) Car

Lines on an ERD diagram indicate:

The last step in creating basic ERD's is to:

The three major parts of an ERD diagram are:

An ERD is a picture that shows how data and information is processed and transformed by a business system.

An analyst can read an ERD to discover the individual pieces of information in a system and how they are organized and related to each other.

During the analysis phase,analysts create programming models to represent how the business system will operate.

ERD's and DFD's are two techniques for process modeling.

On an ERD,similar kinds of information are listed together and placed inside boxes called data containers.

The three steps in creating an ERD are: (1)identify the entities;(2)identify the attributes;(3)identify the relationships

An entity:

What is true about creating an entity relationship diagram?

Information in the data dictionary is called: _______________

What type of process is creating an ERD?

Independent entities are:

In creating ERD's,which would most likely NOT be a source for entities?

The three steps in creating an ERD are: (1)identify the entities;(2)identify the processes;(3)identify the relationships

In defining LAST-NAME in the data dictionary,we might describe it as a character field having from 1 to 15 alphabetic characters.

One of the first places to start developing Entity Relationship Diagrams is by looking at the level 0 process models (DFD)and the use cases for data flows and data stores.

Which would likely be an entity on a car insurance ERD?

The Systems Analyst and Information Systems Development

Project Selection and Management

Requirements Determination

Use Case Analysis

Process Modeling

Moving Into Design

Rchitecture Design

User Interface Design

Program Design

Data Storage Design

Moving Into Implementation

Transition to the New System

The Movement to Objects

Filters

Exam 6: Data Modeling

Lines on an ERD diagram indicate:

The last step in creating basic ERD's is to:

The three major parts of an ERD diagram are:

An ERD is a picture that shows how data and information is processed and transformed by a business system.

An analyst can read an ERD to discover the individual pieces of information in a system and how they are organized and related to each other.

During the analysis phase,analysts create programming models to represent how the business system will operate.

ERD's and DFD's are two techniques for process modeling.

On an ERD,similar kinds of information are listed together and placed inside boxes called data containers.

The three steps in creating an ERD are: (1)identify the entities;(2)identify the attributes;(3)identify the relationships

An entity:

What is true about creating an entity relationship diagram?

Information in the data dictionary is called: _______________

What type of process is creating an ERD?

Independent entities are:

In creating ERD's,which would most likely NOT be a source for entities?

The three steps in creating an ERD are: (1)identify the entities;(2)identify the processes;(3)identify the relationships

In defining LAST-NAME in the data dictionary,we might describe it as a character field having from 1 to 15 alphabetic characters.

One of the first places to start developing Entity Relationship Diagrams is by looking at the level 0 process models (DFD)and the use cases for data flows and data stores.

Which would likely be an entity on a car insurance ERD?

The Systems Analyst and Information Systems Development

Project Selection and Management

Requirements Determination

Use Case Analysis

Process Modeling

Moving Into Design

Rchitecture Design

User Interface Design

Program Design

Data Storage Design

Moving Into Implementation

Transition to the New System

The Movement to Objects

Filters