Question 1

When the analyst is evaluating a data model to ensure that all fields in a record depend fully on the entire primary key,which step of normalization is being performed?

Accepted Answer

A) base normal form 
B) first normal form 
C) second normal form 
D) third normal form 
E) cannot tell from this information 
A) base normal form 
B) first normal form 
C) second normal form 
D) third normal form 
E) cannot tell from this information

Question 2

In adding attributes to an ERD,which of the following might NOT be a good resource for attributes?

Accepted Answer

A) From the CASE tool 
B) Data flows from DFD's 
C) Requirements documents 
D) The system proposal document 
E) Through interviews (what users need for reports and processing) 
A) From the CASE tool 
B) Data flows from DFD's 
C) Requirements documents 
D) The system proposal document 
E) Through interviews (what users need for reports and processing)

Question 3

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 4

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

Accepted Answer

A) True 
 B)False

Question 5

Relationships are drawn with lines showing cardinality and plurality.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following is NOT true about ERDs?

Accepted Answer

A) Special symbols are added to show high-level business rules 
B) The diagrams are drawn in a sequential order - from top to bottom 
C) Similar kinds of information are listed together in entities 
D) ERD's are data modeling techniques 
E) Lines are drawn to show relationships among the data 
A) Special symbols are added to show high-level business rules 
B) The diagrams are drawn in a sequential order - from top to bottom 
C) Similar kinds of information are listed together in entities 
D) ERD's are data modeling techniques 
E) Lines are drawn to show relationships among the data

Question 7

Entities are a person,place,or thing.

Accepted Answer

A) True 
 B)False

Question 8

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 9

Data modeling is an iterative process.

Accepted Answer

A) True 
 B)False

Question 10

When validating ERD's you should balance ERD entities with the data flows and data stores from the DFD process diagrams.

Accepted Answer

A) True 
 B)False

Question 11

You have a student registration system (simplified)with three entities: Student,Professor,and Class.Assume standard attributes for the three entities.What might be the relationships,cardinality and modality between the three?

Accepted Answer

anss will vary;but something like:
Profe

Question 12

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 13

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 14

In the sample data for the STUDENT entity,there are repeating values for class and semester attributes.For example Adam Murphy took CIS 370 section 2 in fall 2008;Brenda Olson took CIS 370 section 2 in fall 2008;Jing Zhang took CIS 370 section 2 in fall 2008;etc.What is the process to modify this entity so that there are no attributes with multiple values?

Accepted Answer

This is to put the entity into First Nor

Question 15

How do you validate an ERD?

Accepted Answer

Creating and validating ERD's can be tou

Question 16

What are the three primary components of an ERD diagram?

Accepted Answer

Entity,att

Question 17

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 18

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 19

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 20

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:

Accepted Answer

A) O normal form to 1st normal form (1NF) 
B) 1st normal form (1NF)to 2nd normal form (2NF) 
C) 2nd normal form (2NF)to 3rd normal form (3NF) 
D) Generalized normal form (GNF)to fully normalized form (FNF) 
E) Dependent normal form (DNF)to Independent normal form (INF) 
A) O normal form to 1st normal form (1NF) 
B) 1st normal form (1NF)to 2nd normal form (2NF) 
C) 2nd normal form (2NF)to 3rd normal form (3NF) 
D) Generalized normal form (GNF)to fully normalized form (FNF) 
E) Dependent normal form (DNF)to Independent normal form (INF)

When the analyst is evaluating a data model to ensure that all fields in a record depend fully on the entire primary key,which step of normalization is being performed?

In adding attributes to an ERD,which of the following might NOT be a good resource for attributes?

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

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

Relationships are drawn with lines showing cardinality and plurality.

Which of the following is NOT true about ERDs?

Entities are a person,place,or thing.

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

Data modeling is an iterative process.

When validating ERD's you should balance ERD entities with the data flows and data stores from the DFD process diagrams.

You have a student registration system (simplified)with three entities: Student,Professor,and Class.Assume standard attributes for the three entities.What might be the relationships,cardinality and modality between the three?

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 _____.

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

How do you validate an ERD?

What are the three primary components of an ERD diagram?

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

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

A data model can __________:

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:

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

When the analyst is evaluating a data model to ensure that all fields in a record depend fully on the entire primary key,which step of normalization is being performed?

In adding attributes to an ERD,which of the following might NOT be a good resource for attributes?

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

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

Relationships are drawn with lines showing cardinality and plurality.

Which of the following is NOT true about ERDs?

Entities are a person,place,or thing.

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

Data modeling is an iterative process.

When validating ERD's you should balance ERD entities with the data flows and data stores from the DFD process diagrams.

You have a student registration system (simplified)with three entities: Student,Professor,and Class.Assume standard attributes for the three entities.What might be the relationships,cardinality and modality between the three?

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 _____.

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

How do you validate an ERD?

What are the three primary components of an ERD diagram?

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

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

A data model can __________:

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:

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