Question 1

The last step in creating basic ERD's is to:

Accepted Answer

A) Identify relationships 
B) Define attributes and assign identifiers 
C) Recognize entities 
D) Test them with users 
E) Compile them with Java 
A) Identify relationships 
B) Define attributes and assign identifiers 
C) Recognize entities 
D) Test them with users 
E) Compile them with Java A

Question 2

The two methods to validate that an ERD is well formed are _____.

Accepted Answer

A) Balancing with process models and following design guidelines created by Chen 
B) Normalization and balancing with process models 
C) Renaming theory 
D) Balancing with process models and renaming theory 
E) Normalization and following design guidelines created by Chen 
A) Balancing with process models and following design guidelines created by Chen 
B) Normalization and balancing with process models 
C) Renaming theory 
D) Balancing with process models and renaming theory 
E) Normalization and following design guidelines created by Chen B

Question 3

You have an entity called STUDENT.What attributes might you have?

Accepted Answer

Ans:wers will vary,most likely most (or all)of the following:
Student-id-number (primary key);Lastname;firstname;birthdate;social security number;home address;home phone;SAT (ACT)scores;credits completed;courses taken;advisor;major;minor;GPA;local address;local phone;cell/mobile phone;gender;financial aid information (or link to a financial aid entity);etc.

Question 4

If the logical data model contains attribute values that depend on an attribute that is not the identifier,then 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 
A) base normal form 
B) first normal form 
C) non-normal form 
D) second normal form 
E) third normal form

Question 5

On an ERD,similar kinds of information are listed together and placed inside boxes called data containers.

Accepted Answer

A) True 
 B)False

Question 6

Independent entities are:

Accepted Answer

A) When a child requires attributes from the parent 
B) When there is only one entity for a data process model 
C) When an entity can exist without the help of another entity 
D) Where the entity identifier is also the primary key 
E) When a entity comes from an external source (aka 'external entity') 
A) When a child requires attributes from the parent 
B) When there is only one entity for a data process model 
C) When an entity can exist without the help of another entity 
D) Where the entity identifier is also the primary key 
E) When a entity comes from an external source (aka 'external entity')

Question 7

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)

Question 8

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') 
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 9

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 
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 10

Most novice analysts understand quickly how to create ERD's.

Accepted Answer

A) True 
 B)False

Question 11

The three major parts of an ERD diagram are:

Accepted Answer

A) Process, data flow, data store 
B) Attribute, modularity, cardinality 
C) Relationship, data flow, entity 
D) Relationship, attribute, entity 
E) Process, entity and relationship 
A) Process, data flow, data store 
B) Attribute, modularity, cardinality 
C) Relationship, data flow, entity 
D) Relationship, attribute, entity 
E) Process, entity and relationship

Question 12

In defining LAST-NAME in the data dictionary,we might describe it as a character field having from 1 to 15 alphabetic characters.

Accepted Answer

A) True 
 B)False

Question 13

An ERD is a picture that shows how data and information is processed and transformed by a business system.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following software packages does NOT provide data modeling capabilities?

Accepted Answer

A) ERwin 
B) Visual Basic 
C) Oracle Designer 
D) Visible Analyst Workbench 
E) Visio 
A) ERwin 
B) Visual Basic 
C) Oracle Designer 
D) Visible Analyst Workbench 
E) Visio

Question 15

Michele has an entity called "client" and an entity called "customer" and an entity called "shopper".All three names seem to refer to the same data in the business system.It is acceptable to use different names for an entity as it helps clarify the purpose of the entity.

Accepted Answer

A) True 
 B)False

Question 16

A data model is a formal way of representing the data that are used and created by a business system.

Accepted Answer

A) True 
 B)False

Question 17

An attribute:

Accepted Answer

A) Is some type of information that is captured about an entity 
B) Is the basic building block for a data model 
C) Is the association between entities 
D) Is the identification of parent and child entities 
E) Is drawn as a line between processes 
A) Is some type of information that is captured about an entity 
B) Is the basic building block for a data model 
C) Is the association between entities 
D) Is the identification of parent and child entities 
E) Is drawn as a line between processes

Question 18

CASE tools have a(n)__________________ where information about entities,attributes and relationships on the ERD are stored.

Accepted Answer

A) Information space 
B) Data store 
C) Meta file 
D) Data flow 
E) Data dictionary 
A) Information space 
B) Data store 
C) Meta file 
D) Data flow 
E) Data dictionary

Question 19

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 
A) base normal form 
B) first normal form 
C) non-normal form 
D) second normal form 
E) third normal form

Question 20

A textbook-provided example of a 'full-service CASE' tool is Visible Analyst Workbench.

Accepted Answer

A) True 
 B)False

The last step in creating basic ERD's is to:

The two methods to validate that an ERD is well formed are _____.

You have an entity called STUDENT.What attributes might you have?

If the logical data model contains attribute values that depend on an attribute that is not the identifier,then it is in _____.

On an ERD,similar kinds of information are listed together and placed inside boxes called data containers.

Independent entities are:

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:

Modality refers to:

An entity relationship diagram (ERD):

Most novice analysts understand quickly how to create ERD's.

The three major parts of an ERD diagram are:

In defining LAST-NAME in the data dictionary,we might describe it as a character field having from 1 to 15 alphabetic characters.

An ERD is a picture that shows how data and information is processed and transformed by a business system.

Which of the following software packages does NOT provide data modeling capabilities?

Michele has an entity called "client" and an entity called "customer" and an entity called "shopper".All three names seem to refer to the same data in the business system.It is acceptable to use different names for an entity as it helps clarify the purpose of the entity.

A data model is a formal way of representing the data that are used and created by a business system.

An attribute:

CASE tools have a(n)__________________ where information about entities,attributes and relationships on the ERD are stored.

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

A textbook-provided example of a 'full-service CASE' tool is Visible Analyst Workbench.

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

The last step in creating basic ERD's is to:

The two methods to validate that an ERD is well formed are _____.

You have an entity called STUDENT.What attributes might you have?

If the logical data model contains attribute values that depend on an attribute that is not the identifier,then it is in _____.

On an ERD,similar kinds of information are listed together and placed inside boxes called data containers.

Independent entities are:

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:

Modality refers to:

An entity relationship diagram (ERD):

Most novice analysts understand quickly how to create ERD's.

The three major parts of an ERD diagram are:

In defining LAST-NAME in the data dictionary,we might describe it as a character field having from 1 to 15 alphabetic characters.

An ERD is a picture that shows how data and information is processed and transformed by a business system.

Which of the following software packages does NOT provide data modeling capabilities?

Michele has an entity called "client" and an entity called "customer" and an entity called "shopper".All three names seem to refer to the same data in the business system.It is acceptable to use different names for an entity as it helps clarify the purpose of the entity.

A data model is a formal way of representing the data that are used and created by a business system.

An attribute:

CASE tools have a(n)__________________ where information about entities,attributes and relationships on the ERD are stored.

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

A textbook-provided example of a 'full-service CASE' tool is Visible Analyst Workbench.

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