Question 1

If the logical data model does not contain attributes that have repeating values it is in _____.

Accepted Answer

A)  base normal form
B)  first normal form
C)  non-normal form
D)  second normal form
E)  third normal form B

Question 2

On an ERD _________________:

Accepted Answer

A)  Processes are listed alphabetically with relationship connections drawn between processes
B)  Data elements are listed alphabetically with a cross listing to the processes that manipulate them
C)  Data elements are described as singular (1:1) ;plurals (1:N) ;or didactic (M:N) 
D)  Data elements are grouped in a hierarchical structure that is uniquely identified by number
E)  Data elements are listed together and place inside boxes called entities. E

Question 3

Entities are further designed with attributes.

Accepted Answer

A) True 
 B)False  True

Question 4

Metadata is data about data.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Department 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

The answer of Department stores have bridal registries.This registry keeps...

Question 7

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 8

An entity is the basic building block for a data model.

Accepted Answer

A) True 
 B)False

Question 9

Entity Relationship Diagrams show relationships between entities that are _____.

Accepted Answer

A)  Outputs from JAD sessions
B)  Consistent with the ACM guidelines
C)  In line with the business rules and processing
D)  Defined by the project sponsor
E)  Extensions of the process models

Question 10

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

Question 11

An entity relationship diagram (ERD):

Accepted Answer

A)  Is a use-case diagram enhanced graphically to show data and process modeling
B)  Is a high-level CASE diagram of data modeling used in business systems
C)  Is an illustration of external data flows to and from a business systems
D)  Is a picture that shows the information that is created,stored and used by a business system
E)  Is a graphical display of the processes in a business system

Question 12

Relationships are associations between entities.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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 16

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

Accepted Answer

A) True 
 B)False

Question 17

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 18

An ERD is a picture which shows the information that is ________ by a business system?

Accepted Answer

A)  created
B)  stored
C)  used
D)  all of these

Question 19

Modality refers to:

Accepted Answer

A)  Relationships of one-to-one;one-to-many;or many-to-many
B)  Whether a child entity can exist with or without a related instance in the parent entity
C)  The hierarchical structure that was developed in process models applied to data models
D)  The number of attributes generated by an entity
E)  Whether the entity has a unique identifier (aka 'primary key') or a concatenated identifier (aka 'composite key')

Question 20

CASE tools have 'data repositories'.

Accepted Answer

A) True 
 B)False

Exam 6: Data Modeling

If the logical data model does not contain attributes that have repeating values it is in _____.

On an ERD _________________:

Entities are further designed with attributes.

Metadata is data about data.

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

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:

An entity is the basic building block for a data model.

Entity Relationship Diagrams show relationships between entities that are _____.

Which is NOT true about using Visible Analyst Workbench?

An entity relationship diagram (ERD) :

Relationships are associations between entities.

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

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

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.

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

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?

An ERD is a picture which shows the information that is ________ by a business system?

Modality refers to:

CASE tools have 'data repositories'.