Exam 9: Designing Databases

Which of the following is a stylized approach to development used during eXtreme Programming that seeks to maximize fruitful interaction between those who need a new system and those who build it?

When each nonprimary key attribute is identified by the whole key, the relation is said to be in at least:

File restoration can be achieved through backup copies of a file, audit trails, and row image files.

A relation is said to be in second normal form when there are no transitive dependencies.

Something that takes place at a certain point in time best defines:

eXtreme Programming uses simple design and refactoring to continually improve the quality of the design as developers continue to iterate through the analysis-design-code-test cycle.

Object-oriented database models are the most frequently used database technologies for new information systems development.

One of the purposes of logical and physical database design is to choose data-storage technologies that will efficiently, accurately, and securely process database activities.

Agile Methodologies promote a self-adaptive software development process.

During the Iteration Planning Game's exploration phase:

The selection of the appropriate data types of attributes from the logical database model is made during physical database design.

Agile software development values working software over documentation.

An entity that has a well-defined role in the application domain and has state, behavior, and identity defines:

A type of use-case relationship that adds new behaviors or actions is a(n):

Use cases show the static structure of data and the operations that act on data.

Types of interaction diagrams include:

A subclass inherits all the features from its superclass.

For a binary one-to-one relationship between two entities, A and B, the primary key of A becomes a foreign key in B and the primary key in B becomes a foreign key in A.

Identify four advantages to using pair programming.

A key can be redundant.