Question 1

What is the relationship between ERDs,DFDs and CASE tools?

Accepted Answer

They are inter-related.The Dat

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

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

Ans:wers will vary;but something like:
P

Question 4

Which of the following is NOT illustrated by a data model?

Accepted Answer

A) People 
B) Places 
C) Things 
D) Actions 
E) Nouns 
A) People 
B) Places 
C) Things 
D) Actions 
E) Nouns

Question 5

Entity relationship diagramming (ERD)is a graphical drawing technique developed by:

Accepted Answer

A) Cole and Weston 
B) Thomas Barton 
C) Peter Chen 
D) Alan Dennis 
E) Martin and Chang 
A) Cole and Weston 
B) Thomas Barton 
C) Peter Chen 
D) Alan Dennis 
E) Martin and Chang

Question 6

Which would most likely NOT be an entity on an ERD?

Accepted Answer

A) Student 
B) Professor 
C) Class 
D) Practice 
E) Enroll 
A) Student 
B) Professor 
C) Class 
D) Practice 
E) Enroll

Question 7

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 8

Which is NOT true about using Visible Analyst Workbench?

Accepted Answer

A) It can be used with many different databases 
B) It integrates the data model with other parts of the project 
C) It is a full-service CASE tool 
D) Data modeling is one of many capabilities 
E) It can generate Java code when the data modeling is done 
A) It can be used with many different databases 
B) It integrates the data model with other parts of the project 
C) It is a full-service CASE tool 
D) Data modeling is one of many capabilities 
E) It can generate Java code when the data modeling is done

Question 9

Data models can be either logical or physical.

Accepted Answer

A) True 
 B)False

Question 10

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 11

Normalizing data models is a five step process: not-normalized;create first normal form (1NF);create second normal form (2NF);create third normal form (3NF);create fourth normal form (4NF)and finally create the fully normalized form (5NF).

Accepted Answer

A) True 
 B)False

Question 12

One of the most commonly used techniques for data modeling is ERD's.

Accepted Answer

A) True 
 B)False

Question 13

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 14

CASE tools have 'data repositories'.

Accepted Answer

A) True 
 B)False

Question 15

In an entity called STUDENT,you might find attributes of Student-ID,Last-Name,First-Name and cell-phone.

Accepted Answer

A) True 
 B)False

Question 16

Project teams can use packages like ERwin or Oracle Designer or Visible Analyst Workbench to draw data models.

Accepted Answer

A) True 
 B)False

Question 17

Target stores have bridal registries.This registry keeps information about customers (the couple that is to be wed)prior to the wedding and keeps the data for a period of two years after the wedding (for returns or late purchasers),the products that the store carries,and the products that each couple has included in the registry.Couples typically register for a large number of products and many couples register for the same products.Draw an entity relationship diagram for Target's bridal registry:

Accepted Answer

Couple(has)Registered Product(

Question 18

Entities are further designed with attributes.

Accepted Answer

A) True 
 B)False

Question 19

CRUD stands for create,read,update and delete and can be used to verify DFDs and ERDs.

Accepted Answer

A) True 
 B)False

Question 20

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

What is the relationship between ERDs,DFDs and CASE tools?

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

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?

Which of the following is NOT illustrated by a data model?

Entity relationship diagramming (ERD)is a graphical drawing technique developed by:

Which would most likely NOT be an entity on an ERD?

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

Which is NOT true about using Visible Analyst Workbench?

Data models can be either logical or physical.

Information in the data dictionary is called: _______________

Normalizing data models is a five step process: not-normalized;create first normal form (1NF);create second normal form (2NF);create third normal form (3NF);create fourth normal form (4NF)and finally create the fully normalized form (5NF).

One of the most commonly used techniques for data modeling is ERD's.

What is true about creating an entity relationship diagram?

CASE tools have 'data repositories'.

In an entity called STUDENT,you might find attributes of Student-ID,Last-Name,First-Name and cell-phone.

Project teams can use packages like ERwin or Oracle Designer or Visible Analyst Workbench to draw data models.

Entities are further designed with attributes.

CRUD stands for create,read,update and delete and can be used to verify DFDs and ERDs.

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.

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

What is the relationship between ERDs,DFDs and CASE tools?

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

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?

Which of the following is NOT illustrated by a data model?

Entity relationship diagramming (ERD)is a graphical drawing technique developed by:

Which would most likely NOT be an entity on an ERD?

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

Which is NOT true about using Visible Analyst Workbench?

Data models can be either logical or physical.

Information in the data dictionary is called: _______________

Normalizing data models is a five step process: not-normalized;create first normal form (1NF);create second normal form (2NF);create third normal form (3NF);create fourth normal form (4NF)and finally create the fully normalized form (5NF).

One of the most commonly used techniques for data modeling is ERD's.

What is true about creating an entity relationship diagram?

CASE tools have 'data repositories'.

In an entity called STUDENT,you might find attributes of Student-ID,Last-Name,First-Name and cell-phone.

Project teams can use packages like ERwin or Oracle Designer or Visible Analyst Workbench to draw data models.

Entities are further designed with attributes.

CRUD stands for create,read,update and delete and can be used to verify DFDs and ERDs.

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.

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