Question 1

Denormalization is the process of splitting or combining normalized relations into physical tables based on EFFICIENCY of use of rows and fields.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following is a purpose of logical model and physical database design?

Accepted Answer

A)  Structure the data in unstable structures that are likely to change over time and that have extensive redundancy. 
B)  Develop a logical database to help identify a steering committee. 
C)  Develop a logical database design from which we can do physical database design. 
D)  Translate a relational database model into network database models. 
E)  Develop a marketing plan for both logical and physical database design. 
A)  Structure the data in unstable structures that are likely to change over time and that have extensive redundancy. 
B)  Develop a logical database to help identify a steering committee. 
C)  Develop a logical database design from which we can do physical database design. 
D)  Translate a relational database model into network database models. 
E)  Develop a marketing plan for both logical and physical database design.

Question 3

The selection of data-storage technologies is made during the systems implementation and operation phase.

Accepted Answer

A) True 
 B)False

Question 4

The Agile Software Development anarchists value:

Accepted Answer

A)  contract negotiation over customer collaboration. 
B)  processes and tools over individuals and interactions. 
C)  following a plan over responding to change. 
D)  working software over comprehensive documentation. 
E)  joint application development over rapid application design. 
A)  contract negotiation over customer collaboration. 
B)  processes and tools over individuals and interactions. 
C)  following a plan over responding to change. 
D)  working software over comprehensive documentation. 
E)  joint application development over rapid application design.

Question 5

In a class diagram, a multiplicity specification of 0..1 indicates optional one.

Accepted Answer

A) True 
 B)False

Question 6

According to the Agile Software Development Manifesto, the seventeen anarchists agreed that their highest priority is to satisfy the customer through early and continuous delivery of valuable software.

Accepted Answer

A) True 
 B)False

Question 7

Which of the following properties should be satisfied when the identifier of the entity type becomes the primary key of the corresponding relation?

Accepted Answer

A)  The value of the key must uniquely identify every row in the relation. 
B)  The key should serve as a foreign key in at least two other relations. 
C)  The key must be a composite of a primary key and a secondary key. 
D)  The key should be an intelligent key. 
E)  The key should allow for null values. 
A)  The value of the key must uniquely identify every row in the relation. 
B)  The key should serve as a foreign key in at least two other relations. 
C)  The key must be a composite of a primary key and a secondary key. 
D)  The key should be an intelligent key. 
E)  The key should allow for null values.

Question 8

A recursive foreign key is a foreign key in a relation that references the primary key value of the same relation.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following properties of a relation states that an entry at the intersection of each row and column is single-valued?

Accepted Answer

A)  Entries in cells are simple. 
B)  Entries in columns are from the same set of values. 
C)  Each row is unique. 
D)  The sequence of rows is insignificant. 
E)  The sequence of columns can be interchanged. 
A)  Entries in cells are simple. 
B)  Entries in columns are from the same set of values. 
C)  Each row is unique. 
D)  The sequence of rows is insignificant. 
E)  The sequence of columns can be interchanged.

Question 10

The use-case model is developed during the requirements analysis phase.

Accepted Answer

A) True 
 B)False

Question 11

Referencing use-case modeling, an external entity that interacts with the system best defines:

Accepted Answer

A)  player. 
B)  actor. 
C)  source. 
D)  target. 
E)  event. 
A)  player. 
B)  actor. 
C)  source. 
D)  target. 
E)  event.

Question 12

Which of the following is NOT associated with logical and physical database design?

Accepted Answer

A)  Structure the data in stable structures that are not likely to change over time and that have minimal redundancy. 
B)  The preparation of a final conceptual model and the implementation of the database. 
C)  Develop a logical database design from which we can do physical database design. 
D)  Develop a logical database design that reflects the actual data requirements that exist in the forms and reports of an information system. 
E)  Translate a relational database model into a technical file and database design. 
A)  Structure the data in stable structures that are not likely to change over time and that have minimal redundancy. 
B)  The preparation of a final conceptual model and the implementation of the database. 
C)  Develop a logical database design from which we can do physical database design. 
D)  Develop a logical database design that reflects the actual data requirements that exist in the forms and reports of an information system. 
E)  Translate a relational database model into a technical file and database design.

Question 13

When classes are generalized, the classes that are generalized are called superclasses.

Accepted Answer

A) True 
 B)False

Question 14

On a use-case diagram, a linking relationship arises when one use case references another use case.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following is NOT a key step in logical database design?

Accepted Answer

A)  Combine normalized data requirements from all user interfaces into one consolidated logical database model. 
B)  Compare the consolidated logical database design with the translated E-R model and produce, through view integration, one final logical database design for the application. 
C)  Model how data flow through an information system, the relationships among the data flows, and how data come to be stored at specific locations. 
D)  Translate the conceptual E-R data model for the application into normalized data requirements. 
E)  Using normalization principles, develop a logical data model for each known user view for the application. 
A)  Combine normalized data requirements from all user interfaces into one consolidated logical database model. 
B)  Compare the consolidated logical database design with the translated E-R model and produce, through view integration, one final logical database design for the application. 
C)  Model how data flow through an information system, the relationships among the data flows, and how data come to be stored at specific locations. 
D)  Translate the conceptual E-R data model for the application into normalized data requirements. 
E)  Using normalization principles, develop a logical data model for each known user view for the application.

Question 16

The relation state specifying that nonprimary key attributes do not depend on other nonprimary key attributes is:

Accepted Answer

A)  first normal form. 
B)  second normal form. 
C)  Boyce-Codd normal form. 
D)  third normal form. 
E)  fifth normal form. 
A)  first normal form. 
B)  second normal form. 
C)  Boyce-Codd normal form. 
D)  third normal form. 
E)  fifth normal form.

Question 17

The primary deliverable from logical database design is a conceptual model.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following focuses on the frequent production of working versions of a system that have a subset of the total number of required features?

Accepted Answer

A)  Use-case modeling 
B)  Structured analysis 
C)  Iterative development 
D)  Structured programming 
E)  Limited production 
A)  Use-case modeling 
B)  Structured analysis 
C)  Iterative development 
D)  Structured programming 
E)  Limited production

Question 19

On a use-case diagram, an actor is shown using a stick figure with its name below.

Accepted Answer

A) True 
 B)False

Question 20

Referential integrity specifies that the value of an attribute of one relation depends on the existence of the same attribute in another relation.

Accepted Answer

A) True 
 B)False

Denormalization is the process of splitting or combining normalized relations into physical tables based on EFFICIENCY of use of rows and fields.

Which of the following is a purpose of logical model and physical database design?

The selection of data-storage technologies is made during the systems implementation and operation phase.

The Agile Software Development anarchists value:

In a class diagram, a multiplicity specification of 0..1 indicates optional one.

According to the Agile Software Development Manifesto, the seventeen anarchists agreed that their highest priority is to satisfy the customer through early and continuous delivery of valuable software.

Which of the following properties should be satisfied when the identifier of the entity type becomes the primary key of the corresponding relation?

A recursive foreign key is a foreign key in a relation that references the primary key value of the same relation.

Which of the following properties of a relation states that an entry at the intersection of each row and column is single-valued?

The use-case model is developed during the requirements analysis phase.

Referencing use-case modeling, an external entity that interacts with the system best defines:

Which of the following is NOT associated with logical and physical database design?

When classes are generalized, the classes that are generalized are called superclasses.

On a use-case diagram, a linking relationship arises when one use case references another use case.

Which of the following is NOT a key step in logical database design?

The relation state specifying that nonprimary key attributes do not depend on other nonprimary key attributes is:

The primary deliverable from logical database design is a conceptual model.

Which of the following focuses on the frequent production of working versions of a system that have a subset of the total number of required features?

On a use-case diagram, an actor is shown using a stick figure with its name below.

Referential integrity specifies that the value of an attribute of one relation depends on the existence of the same attribute in another relation.

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

Denormalization is the process of splitting or combining normalized relations into physical tables based on EFFICIENCY of use of rows and fields.

Which of the following is a purpose of logical model and physical database design?

The selection of data-storage technologies is made during the systems implementation and operation phase.

The Agile Software Development anarchists value:

In a class diagram, a multiplicity specification of 0..1 indicates optional one.

According to the Agile Software Development Manifesto, the seventeen anarchists agreed that their highest priority is to satisfy the customer through early and continuous delivery of valuable software.

Which of the following properties should be satisfied when the identifier of the entity type becomes the primary key of the corresponding relation?

A recursive foreign key is a foreign key in a relation that references the primary key value of the same relation.

Which of the following properties of a relation states that an entry at the intersection of each row and column is single-valued?

The use-case model is developed during the requirements analysis phase.

Referencing use-case modeling, an external entity that interacts with the system best defines:

Which of the following is NOT associated with logical and physical database design?

When classes are generalized, the classes that are generalized are called superclasses.

On a use-case diagram, a linking relationship arises when one use case references another use case.

Which of the following is NOT a key step in logical database design?

The relation state specifying that nonprimary key attributes do not depend on other nonprimary key attributes is:

The primary deliverable from logical database design is a conceptual model.

Which of the following focuses on the frequent production of working versions of a system that have a subset of the total number of required features?

On a use-case diagram, an actor is shown using a stick figure with its name below.

Referential integrity specifies that the value of an attribute of one relation depends on the existence of the same attribute in another relation.

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