Question 1

When performing narrative problem analysis,besides identifying primary keys,you should also identify other ____________ (candidate keys).

Accepted Answer

The answer of When performing narrative problem analysis,besides identifying primary...

Question 2

Figuer:  
-Assuming that we use the rule(s)that avoid null values in tables in converting the ERD diagram to a relational database,the number of tables will be:

Accepted Answer

A)  3 
B)  4 
C)  5 
D)  6 
A)  3 
B)  4 
C)  5 
D)  6

Question 3

When converting a narrative problem into an ERD,the narrative usually is a good source from which to derive relationships between entity types.

Accepted Answer

A) True 
 B)False

Question 4

Figuer:  
-In converting the ERD diagram to a relational database,SS# will appear as a key attribute the following number of times:

Accepted Answer

A)  3 
B)  4 
C)  5 
D)  6 
A)  3 
B)  4 
C)  5 
D)  6

Question 5

In converting an ERD into a set of relational table specifications the M-N Relationship Rule specifies that each M-N relationship becomes a separate table.The primary key of the table is a combined key consisting of the ________ of the entity types participating in the M-N relationship.

Accepted Answer

The answer of In converting an ERD into a set...

Question 6

When refining a data model,__________ attributes (attributes that contain multiple kinds of data)should be split into smaller attributes.

Accepted Answer

The answer of When refining a data model,__________ attributes (attributes...

Question 7

The Unified Modeling Language:

Accepted Answer

A)  Emphasizes processes rather than objects 
B)  Has supported generalization since its inception 
C)  Is the standard notation for object-oriented modeling 
D)  Both B and C 
A)  Emphasizes processes rather than objects 
B)  Has supported generalization since its inception 
C)  Is the standard notation for object-oriented modeling 
D)  Both B and C

Question 8

A common design problem in an ERD might be:

Accepted Answer

A)  Inappropriate use of generalization hierarchies 
B)  Missing or misplaced relationships 
C)  Inappropriate use of M-way relationships 
D)  All of the above 
A)  Inappropriate use of generalization hierarchies 
B)  Missing or misplaced relationships 
C)  Inappropriate use of M-way relationships 
D)  All of the above

Question 9

Redundant relationships in a database design:

Accepted Answer

A)  Can be derived from other relationships 
B)  Cannot be identified by reviewing the ERD 
C)  Should always be removed from the database design 
D)  None of the above 
A)  Can be derived from other relationships 
B)  Cannot be identified by reviewing the ERD 
C)  Should always be removed from the database design 
D)  None of the above

Question 10

Figuer:  
-Assuming that we do not use the rule(s)that avoid null values in tables,converting the ERD diagram to a relational database will produce the following number of tables:

Accepted Answer

A)  3 
B)  4 
C)  5 
D)  6 
A)  3 
B)  4 
C)  5 
D)  6

Question 11

Which of the following ERD conversion rules should be applied before the others:

Accepted Answer

A)  1-M Relationship Rule 
B)  M-N Relationship Rule 
C)  Identification Dependency Rule 
D)  Generalization Hierarchy Rule 
A)  1-M Relationship Rule 
B)  M-N Relationship Rule 
C)  Identification Dependency Rule 
D)  Generalization Hierarchy Rule

Question 12

Figuer:  
-Assuming that we do not use the rule(s)that avoid null values in tables in converting the ERD diagram to a relational database:

Accepted Answer

A)  Cname appears as a foreign key in the table Author 
B)  Cname may have null values in the table Author 
C)  Both of the above 
D)  None of the above 
A)  Cname appears as a foreign key in the table Author 
B)  Cname may have null values in the table Author 
C)  Both of the above 
D)  None of the above

Question 13

Figuer:  
-In converting the ERD diagram to a relational database,the table RN has the following number of attributes:

Accepted Answer

A)  3 
B)  4 
C)  5 
D)  6 
A)  3 
B)  4 
C)  5 
D)  6

Question 14

Stable means that a primary key should ___________ after it has been assigned to an entity.

Accepted Answer

The answer of Stable means that a primary key should...

Question 15

In object-oriented modeling,which is defined first:

Accepted Answer

A)  Objects 
B)  Classes 
C)  Features of objects 
D)  Interaction among objects 
A)  Objects 
B)  Classes 
C)  Features of objects 
D)  Interaction among objects

Question 16

Figuer:  
-Assuming that we do not use the rule(s)that avoid null values in tables,the table BOOK obtained in converting the ERD diagram to a relational database will contain the following number of attributes:

Accepted Answer

A)  3 
B)  4 
C)  5 
D)  6 
A)  3 
B)  4 
C)  5 
D)  6

Question 17

In order to enforce referential integrity constraints when converting a generalization hierarchy,the ON DELETE CASCAED option should be specified for actions on referenced rows.

Accepted Answer

A) True 
 B)False

Question 18

A common design error that occurs when you do not consider all of the queries that a database should support is to omit relationships between entities that map an important business rule.These omitted relationships are known as ______________.

Accepted Answer

misplaced

Question 19

Single purpose means that a primary key attribute should have no purpose other than ____________.

Accepted Answer

entity ide

Question 20

An associative entity type should be used whenever combinations of three or more objects must be recorded.

Accepted Answer

A) True 
 B)False

When performing narrative problem analysis,besides identifying primary keys,you should also identify other ____________ (candidate keys).

Figuer: -Assuming that we use the rule(s)that avoid null values in tables in converting the ERD diagram to a relational database,the number of tables will be:

When converting a narrative problem into an ERD,the narrative usually is a good source from which to derive relationships between entity types.

Figuer: -In converting the ERD diagram to a relational database,SS# will appear as a key attribute the following number of times:

In converting an ERD into a set of relational table specifications the M-N Relationship Rule specifies that each M-N relationship becomes a separate table.The primary key of the table is a combined key consisting of the ________ of the entity types participating in the M-N relationship.

When refining a data model,__________ attributes (attributes that contain multiple kinds of data)should be split into smaller attributes.

The Unified Modeling Language:

A common design problem in an ERD might be:

Redundant relationships in a database design:

Figuer: -Assuming that we do not use the rule(s)that avoid null values in tables,converting the ERD diagram to a relational database will produce the following number of tables:

Which of the following ERD conversion rules should be applied before the others:

Figuer: -Assuming that we do not use the rule(s)that avoid null values in tables in converting the ERD diagram to a relational database:

Figuer: -In converting the ERD diagram to a relational database,the table RN has the following number of attributes:

Stable means that a primary key should ___________ after it has been assigned to an entity.

In object-oriented modeling,which is defined first:

Figuer: -Assuming that we do not use the rule(s)that avoid null values in tables,the table BOOK obtained in converting the ERD diagram to a relational database will contain the following number of attributes:

In order to enforce referential integrity constraints when converting a generalization hierarchy,the ON DELETE CASCAED option should be specified for actions on referenced rows.

A common design error that occurs when you do not consider all of the queries that a database should support is to omit relationships between entities that map an important business rule.These omitted relationships are known as ______________.

Single purpose means that a primary key attribute should have no purpose other than ____________.

An associative entity type should be used whenever combinations of three or more objects must be recorded.

Introduction to Database Management

Introduction to Database Development

The Relational Data Model

Query Formulation With SQL

Understanding Entity Relations

Normalization of Relational Tables

Physical Database Design

Advanced Query Formulation With SQL

Application Development With Views

Stored Procedures and Triggers

View Design and Integration

Data and Database Administration

Transaction Management

Data Warehouse Technology and Management

Client-Server Processing and Distributed Databases

Object Database Management Systems

Filters

Exam 6: Developing Data Models for Business Databases

When performing narrative problem analysis,besides identifying primary keys,you should also identify other ____________ (candidate keys).

Figuer: -Assuming that we use the rule(s)that avoid null values in tables in converting the ERD diagram to a relational database,the number of tables will be:

When converting a narrative problem into an ERD,the narrative usually is a good source from which to derive relationships between entity types.

Figuer: -In converting the ERD diagram to a relational database,SS# will appear as a key attribute the following number of times:

In converting an ERD into a set of relational table specifications the M-N Relationship Rule specifies that each M-N relationship becomes a separate table.The primary key of the table is a combined key consisting of the ________ of the entity types participating in the M-N relationship.

When refining a data model,__________ attributes (attributes that contain multiple kinds of data)should be split into smaller attributes.

The Unified Modeling Language:

A common design problem in an ERD might be:

Redundant relationships in a database design:

Figuer: -Assuming that we do not use the rule(s)that avoid null values in tables,converting the ERD diagram to a relational database will produce the following number of tables:

Which of the following ERD conversion rules should be applied before the others:

Figuer: -Assuming that we do not use the rule(s)that avoid null values in tables in converting the ERD diagram to a relational database:

Figuer: -In converting the ERD diagram to a relational database,the table RN has the following number of attributes:

Stable means that a primary key should ___________ after it has been assigned to an entity.

In object-oriented modeling,which is defined first:

Figuer: -Assuming that we do not use the rule(s)that avoid null values in tables,the table BOOK obtained in converting the ERD diagram to a relational database will contain the following number of attributes:

In order to enforce referential integrity constraints when converting a generalization hierarchy,the ON DELETE CASCAED option should be specified for actions on referenced rows.

A common design error that occurs when you do not consider all of the queries that a database should support is to omit relationships between entities that map an important business rule.These omitted relationships are known as ______________.

Single purpose means that a primary key attribute should have no purpose other than ____________.

An associative entity type should be used whenever combinations of three or more objects must be recorded.

Introduction to Database Management

Introduction to Database Development

The Relational Data Model

Query Formulation With SQL

Understanding Entity Relations

Normalization of Relational Tables

Physical Database Design

Advanced Query Formulation With SQL

Application Development With Views

Stored Procedures and Triggers

View Design and Integration

Data and Database Administration

Transaction Management

Data Warehouse Technology and Management

Client-Server Processing and Distributed Databases

Object Database Management Systems

Filters