Question 1

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 2

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

Question 3

A logical data model that does not lead to repeating fields and that the data models leads to tables containing fields that are dependent on the whole identifier is in _____ normal form.

Accepted Answer

A) balanced 
B) first 
C) primary 
D) second 
E) third

Question 4

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

The answer of In the sample data for the STUDENT...

Question 5

Sanjay is identifying relationships as he draws ERD's.He will need to:

Accepted Answer

A) Determine originality and functionality 
B) Include cardinality and crows feet 
C) Add modality and functionality 
D) Determine modality and cardinality 
E) Include 1:1, 1:N and M:N relationships

Question 6

Which is NOT an element of an Entity Relationship Diagram?

Accepted Answer

A) Cardinality 
B) Modality 
C) Attribute 
D) Relationship 
E) Data stores

Question 7

An entity is described by an action verb.

Accepted Answer

A) True 
 B)False

Question 8

What are the rules covering the layout of ERD components?

Accepted Answer

A) Items that are related must be grouped into subject areas 
B) Items that are not related must be drawn on the bottom of the page 
C) They must be placed in alphabetical order 
D) They must be placed in numerical order 
E) There are no rules

Question 9

If an ERD gets too complex,it can be broken down into related subject areas.

Accepted Answer

A) True 
 B)False

Question 10

ERD's are drawn in several levels: Context ERD diagrams;Level 0 ERD diagrams;Level 1 ERD diagrams.

Accepted Answer

A) True 
 B)False

Question 11

The processes of creating process models,data models and using CASE tools are interrelated.

Accepted Answer

A) True 
 B)False

Question 12

Discuss what should be done to ensure that the entity relationship diagrams balance with the data flow diagrams.What is the consequence of failing to balance these models?

Accepted Answer

The answer of Discuss what should be done to ensure...

Question 13

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 the above information

Question 14

A graphical illustration that shows the information that is created,stored and used by a business system would be an ERD.

Accepted Answer

A) True 
 B)False

Question 15

Anthony is working on the cardinality of doctors and patients in a large urban hospital.With the large number of doctors with varying specialties and patients that may have more than one aliment,he thinks the relationship might be noted as:

Accepted Answer

A) 1 to 1 
B) 1 to 2 
C) 1 to many 
D) Many to many 
E) Many to 1

Question 16

Which would NOT likely be an attribute of an entity called "Student"?

Accepted Answer

A) Age 
B) Student identification number 
C) Class room number 
D) Home phone 
E) Gender

Question 17

An illustration of the transformation of data into business value is an ERD.

Accepted Answer

A) True 
 B)False

Question 18

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

Question 19

Looking at external entities can be helpful with creating entities.

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 6: Data Modeling

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 of the following is NOT true about ERDs?

A logical data model that does not lead to repeating fields and that the data models leads to tables containing fields that are dependent on the whole identifier is in _____ normal form.

Sanjay is identifying relationships as he draws ERD's.He will need to:

Which is NOT an element of an Entity Relationship Diagram?

An entity is described by an action verb.

What are the rules covering the layout of ERD components?

If an ERD gets too complex,it can be broken down into related subject areas.

ERD's are drawn in several levels: Context ERD diagrams;Level 0 ERD diagrams;Level 1 ERD diagrams.

The processes of creating process models,data models and using CASE tools are interrelated.

Discuss what should be done to ensure that the entity relationship diagrams balance with the data flow diagrams.What is the consequence of failing to balance these models?

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?

A graphical illustration that shows the information that is created,stored and used by a business system would be an ERD.

Anthony is working on the cardinality of doctors and patients in a large urban hospital.With the large number of doctors with varying specialties and patients that may have more than one aliment,he thinks the relationship might be noted as:

Which would NOT likely be an attribute of an entity called "Student"?

An illustration of the transformation of data into business value is an ERD.

Looking at external entities can be helpful with creating entities.

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