Question 1

In defining the data characteristics of Universal Product Codes,we might describe them as twelve characters made up of digits - numeric only.

Accepted Answer

A) True 
 B)False

Question 2

You have entities of ITEM,SOLD-ITEM,SALE and PAYMENT.Which most likely is NOT a relationship?

Accepted Answer

A) SALE is paid by PAYMENT 
B) PAYMENT pays for ITEM 
C) ITEM is included in SOLD-ITEM 
D) SALE involves SOLD-ITEM 
E) PAYMENT pays for SALE 
A) SALE is paid by PAYMENT 
B) PAYMENT pays for ITEM 
C) ITEM is included in SOLD-ITEM 
D) SALE involves SOLD-ITEM 
E) PAYMENT pays for SALE

Question 3

Andrew,an analyst for PaxMedia Inc,has just learned that the business rules for a system he has been working on have changed.This means that _____.

Accepted Answer

A) Nothing - once the ERD data models have been drawn, they are 'frozen' for the system 
B) Andrew will be reassigned to a different project that is in its beginning stages 
C) The ERD components will have to be changed 
D) The ERD data model will have to be put on hold while new DFD diagrams are created 
E) The project will have to be scrapped and restarted 
A) Nothing - once the ERD data models have been drawn, they are 'frozen' for the system 
B) Andrew will be reassigned to a different project that is in its beginning stages 
C) The ERD components will have to be changed 
D) The ERD data model will have to be put on hold while new DFD diagrams are created 
E) The project will have to be scrapped and restarted

Question 4

The first step to building an Entity Relationship Diagram is to _____

Accepted Answer

A) Identify data flows from the level 0 DFD diagram 
B) draw the relationships between the entities 
C) identify the attributes for each entity 
D) identify the entities 
E) identify the processes, data flows and data stores 
A) Identify data flows from the level 0 DFD diagram 
B) draw the relationships between the entities 
C) identify the attributes for each entity 
D) identify the entities 
E) identify the processes, data flows and data stores

Question 5

A(n)_____ entity is an entity at the "1" end of a relationship or an entity with an identifier that describes only the entity.

Accepted Answer

A) dependent 
B) incomplete 
C) independent 
D) intersection 
E) non-identifying 
A) dependent 
B) incomplete 
C) independent 
D) intersection 
E) non-identifying

Question 6

Relationships are some type of information that is captured about entities.

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) Customer 
B) Policy 
C) Agent 
D) Zip code 
E) Car 
A) Customer 
B) Policy 
C) Agent 
D) Zip code 
E) Car

Question 8

How do you validate an ERD?

Accepted Answer

Creating and validating ERD's can be tou

Question 9

ERwin,a CASE tool with data modeling features,was created by:

Accepted Answer

A) Oracle 
B) Microsoft 
C) Platinum Technology 
D) Sun Systems 
E) United Technologies 
A) Oracle 
B) Microsoft 
C) Platinum Technology 
D) Sun Systems 
E) United Technologies

Question 10

ERD is an acronym for Enterprise Reliability Diagrams.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

ERD's can be quite complex and might have hundreds or thousands of entities.

Accepted Answer

A) True 
 B)False

Question 13

Data modeling is an iterative process.

Accepted Answer

A) True 
 B)False

Question 14

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 15

A data model can __________:

Accepted Answer

A) Illustrate return-on-investment, break-even point, and economic feasibility 
B) Represent actions or processes that occur in the to-be system 
C) Be used as a logical data model in analysis and as a physical data model in design 
D) Only be used in BPR situations 
E) Only be used with JAD sessions 
A) Illustrate return-on-investment, break-even point, and economic feasibility 
B) Represent actions or processes that occur in the to-be system 
C) Be used as a logical data model in analysis and as a physical data model in design 
D) Only be used in BPR situations 
E) Only be used with JAD sessions

Question 16

When depicting the inter-realationship between process and data models it can be useful to refer to the CRUDE matrix (create,relate,update,define,edit).

Accepted Answer

A) True 
 B)False

Question 17

ERD is an acronym for:

Accepted Answer

A) Enterprise Relationship Diagramming 
B) Entity Relationship Diagramming 
C) Electronic Repository Diagramming 
D) Enhanced Relationship Diagramming 
E) Entity Repository Design 
A) Enterprise Relationship Diagramming 
B) Entity Relationship Diagramming 
C) Electronic Repository Diagramming 
D) Enhanced Relationship Diagramming 
E) Entity Repository Design

Question 18

A data model is a:

Accepted Answer

A) The mathematical model of formulas and logic used in a system 
B) The abstract creating of an ideal system transformation 
C) The model that is produced by extreme programming 
D) The expanded, thoroughly balanced and normalized use case for a system 
E) A formal way of representing the data that are used and created by a business system 
A) The mathematical model of formulas and logic used in a system 
B) The abstract creating of an ideal system transformation 
C) The model that is produced by extreme programming 
D) The expanded, thoroughly balanced and normalized use case for a system 
E) A formal way of representing the data that are used and created by a business system

Question 19

In an entity called STUDENT,you might find attributes of PROFESSOR-ID,Last-Name,First-Name and CLASSROOM.

Accepted Answer

A) True 
 B)False

Question 20

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

In defining the data characteristics of Universal Product Codes,we might describe them as twelve characters made up of digits - numeric only.

You have entities of ITEM,SOLD-ITEM,SALE and PAYMENT.Which most likely is NOT a relationship?

Andrew,an analyst for PaxMedia Inc,has just learned that the business rules for a system he has been working on have changed.This means that _____.

The first step to building an Entity Relationship Diagram is to _____

A(n)_____ entity is an entity at the "1" end of a relationship or an entity with an identifier that describes only the entity.

Relationships are some type of information that is captured about entities.

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

How do you validate an ERD?

ERwin,a CASE tool with data modeling features,was created by:

ERD is an acronym for Enterprise Reliability Diagrams.

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

ERD's can be quite complex and might have hundreds or thousands of entities.

Data modeling is an iterative process.

Lines on an ERD diagram indicate:

A data model can __________:

When depicting the inter-realationship between process and data models it can be useful to refer to the CRUDE matrix (create,relate,update,define,edit).

ERD is an acronym for:

A data model is a:

In an entity called STUDENT,you might find attributes of PROFESSOR-ID,Last-Name,First-Name and CLASSROOM.

An entity:

The Systems Analyst and Information Systems Development

Project Selection and Management

Requirements Determination

Systems Analysis and Design

Process Modeling

Moving Into Design

Architecture Design

Dennis/wixom/roth

Program Design

Data Storage Design

Moving Into Implementation

Transition to the New System

the Movement to Objects

Filters

Exam 6: Data Modeling

In defining the data characteristics of Universal Product Codes,we might describe them as twelve characters made up of digits - numeric only.

You have entities of ITEM,SOLD-ITEM,SALE and PAYMENT.Which most likely is NOT a relationship?

Andrew,an analyst for PaxMedia Inc,has just learned that the business rules for a system he has been working on have changed.This means that _____.

The first step to building an Entity Relationship Diagram is to _____

A(n)_____ entity is an entity at the "1" end of a relationship or an entity with an identifier that describes only the entity.

Relationships are some type of information that is captured about entities.

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

How do you validate an ERD?

ERwin,a CASE tool with data modeling features,was created by:

ERD is an acronym for Enterprise Reliability Diagrams.

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

ERD's can be quite complex and might have hundreds or thousands of entities.

Data modeling is an iterative process.

Lines on an ERD diagram indicate:

A data model can __________:

When depicting the inter-realationship between process and data models it can be useful to refer to the CRUDE matrix (create,relate,update,define,edit).

ERD is an acronym for:

A data model is a:

In an entity called STUDENT,you might find attributes of PROFESSOR-ID,Last-Name,First-Name and CLASSROOM.

An entity:

The Systems Analyst and Information Systems Development

Project Selection and Management

Requirements Determination

Systems Analysis and Design

Process Modeling

Moving Into Design

Architecture Design

Dennis/wixom/roth

Program Design

Data Storage Design

Moving Into Implementation

Transition to the New System

the Movement to Objects

Filters