Question 1

If OrderNumber serves as the primary key in the ORDER relation and also appears as a nonkey attribute in the INVOICE relation, then OrderNumber is said to be a:

Accepted Answer

A)  foreign key. 
B)  candidate key. 
C)  pointer. 
D)  relationship key. 
E)  marker. 
A)  foreign key. 
B)  candidate key. 
C)  pointer. 
D)  relationship key. 
E)  marker. A

Question 2

When modeling a many-to-many unary relationship, the primary key of the relation representing the relationship is always singular.

Accepted Answer

A) True 
 B)False  False

Question 3

Sequence diagrams represent dynamic models of how objects change their states in response to events.

Accepted Answer

A) True 
 B)False  False

Question 4

Discuss the rules for normalization.

Accepted Answer

Although the first normal form was not d

Question 5

The three phases associated with the Planning game include:

Accepted Answer

A)  exploration, commitment, and steering. 
B)  exploration, initiation, and design. 
C)  initiation, analysis, and design. 
D)  analysis, design, and implementation. 
E)  exploration, design, and implementation. 
A)  exploration, commitment, and steering. 
B)  exploration, initiation, and design. 
C)  initiation, analysis, and design. 
D)  analysis, design, and implementation. 
E)  exploration, design, and implementation.

Question 6

The creation of a separate relation is sometimes required to represent a relationship.

Accepted Answer

A) True 
 B)False

Question 7

A relation is said to be in second normal form if the primary key consists of a combination key, and the nonkey attributes are partially dependent on the primary key.

Accepted Answer

A) True 
 B)False

Question 8

An Agile Methodology is recommended for each of the following EXCEPT:

Accepted Answer

A)  unpredictable or dynamic requirements. 
B)  responsible and motivated developers. 
C)  customers who understand and will get involved. 
D)  a large development team, exceeding 100 or more people. 
E)  small development projects. 
A)  unpredictable or dynamic requirements. 
B)  responsible and motivated developers. 
C)  customers who understand and will get involved. 
D)  a large development team, exceeding 100 or more people. 
E)  small development projects.

Question 9

On a use-case diagram, the type of relationship that arises when one use case references another use case is called a(n):

Accepted Answer

A)  extends relationship. 
B)  working relationship. 
C)  include relationship. 
D)  definitive relationship. 
E)  recursive relationship. 
A)  extends relationship. 
B)  working relationship. 
C)  include relationship. 
D)  definitive relationship. 
E)  recursive relationship.

Question 10

A class that can have direct instances best defines:

Accepted Answer

A)  abstract class. 
B)  complete class. 
C)  concrete class. 
D)  superclass. 
E)  complex class. 
A)  abstract class. 
B)  complete class. 
C)  concrete class. 
D)  superclass. 
E)  complex class.

Question 11

A default value is a value a field will assume unless an explicit value is entered for that field.

Accepted Answer

A) True 
 B)False

Question 12

During the Iteration Planning Game's steering phase:

Accepted Answer

A)  programmers write the code for a feature, test it, and if it works, they integrate the feature into the product being developed. 
B)  business creates a Story Card for something it wants the new system to do. 
C)  programmers convert Story Cards into Task Cards. 
D)  business sees how the development process is progressing and works with Development to adjust the plan accordingly. 
E)  programmers accept responsibility for tasks and balance their workloads. 
A)  programmers write the code for a feature, test it, and if it works, they integrate the feature into the product being developed. 
B)  business creates a Story Card for something it wants the new system to do. 
C)  programmers convert Story Cards into Task Cards. 
D)  business sees how the development process is progressing and works with Development to adjust the plan accordingly. 
E)  programmers accept responsibility for tasks and balance their workloads.

Question 13

Two different names used for the same attribute is called a synonym.

Accepted Answer

A) True 
 B)False

Question 14

At the end of eXtreme Programming's coding phase, all code written to that point is tested.

Accepted Answer

A) True 
 B)False

Question 15

What is meant by Agile Methodologies? Identify the three key principles that the Agile Methodologies share.

Accepted Answer

Agile Methodologies are a response to th

Question 16

In the Planning Game, which of the following refers to the individuals who are actually designing and constructing the system?

Accepted Answer

A)  Facilitator 
B)  Business 
C)  Development 
D)  Constructor 
E)  Scribe 
A)  Facilitator 
B)  Business 
C)  Development 
D)  Constructor 
E)  Scribe

Question 17

Sequential files are practical for random row retrievals.

Accepted Answer

A) True 
 B)False

Question 18

For a binary many-to-many relationship existing between entity types A and B:

Accepted Answer

A)  a separate relation C is created; the primary key of relation C is a composite key consisting of the primary key for each of the two entities in the relationship. 
B)  the primary keys of relation A and relation B become foreign keys in a new relation C. 
C)  secondary keys are used to establish the relationship. 
D)  place the primary key of either entity in the relation for the other entity or do this for both entities. 
E)  Entity A and B are merged into one. 
A)  a separate relation C is created; the primary key of relation C is a composite key consisting of the primary key for each of the two entities in the relationship. 
B)  the primary keys of relation A and relation B become foreign keys in a new relation C. 
C)  secondary keys are used to establish the relationship. 
D)  place the primary key of either entity in the relation for the other entity or do this for both entities. 
E)  Entity A and B are merged into one.

Question 19

On a use-case diagram, use cases are shown as:

Accepted Answer

A)  squares with their names written inside. 
B)  rounded rectangles with their names written inside. 
C)  stickmen symbols with their names written below the symbol. 
D)  ellipses with their names inside. 
E)  circles with their names written inside. 
A)  squares with their names written inside. 
B)  rounded rectangles with their names written inside. 
C)  stickmen symbols with their names written below the symbol. 
D)  ellipses with their names inside. 
E)  circles with their names written inside.

Question 20

An entity whose primary key depends on the primary key of another entity is called a:

Accepted Answer

A)  referential entity. 
B)  candidate entity. 
C)  transitive entity. 
D)  dependent entity. 
E)  weak entity. 
A)  referential entity. 
B)  candidate entity. 
C)  transitive entity. 
D)  dependent entity. 
E)  weak entity.

If OrderNumber serves as the primary key in the ORDER relation and also appears as a nonkey attribute in the INVOICE relation, then OrderNumber is said to be a:

When modeling a many-to-many unary relationship, the primary key of the relation representing the relationship is always singular.

Sequence diagrams represent dynamic models of how objects change their states in response to events.

Discuss the rules for normalization.

The three phases associated with the Planning game include:

The creation of a separate relation is sometimes required to represent a relationship.

A relation is said to be in second normal form if the primary key consists of a combination key, and the nonkey attributes are partially dependent on the primary key.

An Agile Methodology is recommended for each of the following EXCEPT:

On a use-case diagram, the type of relationship that arises when one use case references another use case is called a(n):

A class that can have direct instances best defines:

A default value is a value a field will assume unless an explicit value is entered for that field.

During the Iteration Planning Game's steering phase:

Two different names used for the same attribute is called a synonym.

At the end of eXtreme Programming's coding phase, all code written to that point is tested.

What is meant by Agile Methodologies? Identify the three key principles that the Agile Methodologies share.

In the Planning Game, which of the following refers to the individuals who are actually designing and constructing the system?

Sequential files are practical for random row retrievals.

For a binary many-to-many relationship existing between entity types A and B:

On a use-case diagram, use cases are shown as:

An entity whose primary key depends on the primary key of another entity is called a:

The Systems Development Environment

The Sources of Software

Managing the Information Systems Project

Systems Planning and Selection

Determining System Requirements

Structuring System Requirements: Process Modeling

Structuring System Requirements: Conceptual Data Modeling

Designing the Human Interface

Systems Implementation and Operation

Filters

Exam 9: Designing Databases

If OrderNumber serves as the primary key in the ORDER relation and also appears as a nonkey attribute in the INVOICE relation, then OrderNumber is said to be a:

When modeling a many-to-many unary relationship, the primary key of the relation representing the relationship is always singular.

Sequence diagrams represent dynamic models of how objects change their states in response to events.

Discuss the rules for normalization.

The three phases associated with the Planning game include:

The creation of a separate relation is sometimes required to represent a relationship.

A relation is said to be in second normal form if the primary key consists of a combination key, and the nonkey attributes are partially dependent on the primary key.

An Agile Methodology is recommended for each of the following EXCEPT:

On a use-case diagram, the type of relationship that arises when one use case references another use case is called a(n):

A class that can have direct instances best defines:

A default value is a value a field will assume unless an explicit value is entered for that field.

During the Iteration Planning Game's steering phase:

Two different names used for the same attribute is called a synonym.

At the end of eXtreme Programming's coding phase, all code written to that point is tested.

What is meant by Agile Methodologies? Identify the three key principles that the Agile Methodologies share.

In the Planning Game, which of the following refers to the individuals who are actually designing and constructing the system?

Sequential files are practical for random row retrievals.

For a binary many-to-many relationship existing between entity types A and B:

On a use-case diagram, use cases are shown as:

An entity whose primary key depends on the primary key of another entity is called a:

The Systems Development Environment

The Sources of Software

Managing the Information Systems Project

Systems Planning and Selection

Determining System Requirements

Structuring System Requirements: Process Modeling

Structuring System Requirements: Conceptual Data Modeling

Designing the Human Interface

Systems Implementation and Operation

Filters