Question 1

Which of the following is true when implementing a one-to-many relationship?

Accepted Answer

A)  The file on the one end has a foreign key consisting of the primary key of the many end. 
B)  The file on the one end has a concatenated key of its primary key and the many end key. 
C)  The file on the many end has a foreign key consisting of the primary key on the one end. 
D)  The file on the many end has a concatenated key of its primary key and the one end key. 
A)  The file on the one end has a foreign key consisting of the primary key of the many end. 
B)  The file on the one end has a concatenated key of its primary key and the many end key. 
C)  The file on the many end has a foreign key consisting of the primary key on the one end. 
D)  The file on the many end has a concatenated key of its primary key and the one end key.

Question 2

Which is not an effectiveness objective of the database?

Accepted Answer

A)  ensuring that data can be shared among users for a variety of applications 
B)  ensuring all data required for current and future applications will be readily available 
C)  allowing the database to evolve and the needs of the users to grow 
D)  allowing users to construct their personal view of the data without concern for the way the data are physically stored 
E)  maintaining data that are both accurate and inconsistent 
A)  ensuring that data can be shared among users for a variety of applications 
B)  ensuring all data required for current and future applications will be readily available 
C)  allowing the database to evolve and the needs of the users to grow 
D)  allowing users to construct their personal view of the data without concern for the way the data are physically stored 
E)  maintaining data that are both accurate and inconsistent

Question 3

The process of taking a logical data model and transforming it into a physical model that is efficient for the most often used tasks is called:

Accepted Answer

A)  referential integrity. 
B)  normalization. 
C)  denormalization. 
D)  data warehousing. 
E)  online analytic processing. 
A)  referential integrity. 
B)  normalization. 
C)  denormalization. 
D)  data warehousing. 
E)  online analytic processing.

Question 4

Which word is used interchangeably with the term data item?

Accepted Answer

A)  attribute 
B)  record 
C)  key 
D)  tuple 
A)  attribute 
B)  record 
C)  key 
D)  tuple

Question 5

Table files are used to update master files.

Accepted Answer

A) True 
 B)False

Question 6

A well-designed ________ can be more flexible than separate files.

Accepted Answer

A)  data dictionary 
B)  data warehouse 
C)  data model 
D)  database 
A)  data dictionary 
B)  data warehouse 
C)  data model 
D)  database

Question 7

Which order is correct for the analyst to normalize a data structure?
I. Remove all repeating groups and identify the primary key.
II. Remove any transitive dependencies.
III. All partial dependencies are removed and placed in another relation.

Accepted Answer

A)  III - II - I 
B)  I - II - III 
C)  III - I - II 
D)  II - I - III 
E)  I - III - II 
A)  III - II - I 
B)  I - II - III 
C)  III - I - II 
D)  II - I - III 
E)  I - III - II

Question 8

A many-to-many relationship may be implemented using three tables.

Accepted Answer

A) True 
 B)False

Question 9

A(n) ________ represents additional attributes of an entity that may not be present on every record of the entity.

Accepted Answer

A)  entity subtype 
B)  entity type 
C)  primary entity 
D)  secondary entity 
A)  entity subtype 
B)  entity type 
C)  primary entity 
D)  secondary entity

Question 10

________ are associations between entities.

Accepted Answer

A)  Relationships 
B)  Subtypes 
C)  Types 
D)  Entities 
A)  Relationships 
B)  Subtypes 
C)  Types 
D)  Entities

Question 11

An insert anomaly results when a change to one attribute value either causes the database to contain inconsistent data or causes multiple records to need changing.

Accepted Answer

A) True 
 B)False

Question 12

REMOVE is the logical ordering of rows in a relation according to some key.

Accepted Answer

A) True 
 B)False

Question 13

An attribute is some characteristic of a(n):

Accepted Answer

A)  entity. 
B)  relationship. 
C)  reality. 
D)  record definition. 
A)  entity. 
B)  relationship. 
C)  reality. 
D)  record definition.

Question 14

A ________ represents more than one of the other entity.

Accepted Answer

A)  crow's foot 
B)  single line 
C)  double line 
D)  dotted line 
A)  crow's foot 
B)  single line 
C)  double line 
D)  dotted line

Question 15

An alternative to building conventional files is building a:

Accepted Answer

A)  data dictionary. 
B)  data warehouse. 
C)  database. 
D)  data model. 
A)  data dictionary. 
B)  data warehouse. 
C)  database. 
D)  data model.

Which of the following is true when implementing a one-to-many relationship?

Which is not an effectiveness objective of the database?

The process of taking a logical data model and transforming it into a physical model that is efficient for the most often used tasks is called:

Which word is used interchangeably with the term data item?

Table files are used to update master files.

A well-designed ________ can be more flexible than separate files.

Which order is correct for the analyst to normalize a data structure? I. Remove all repeating groups and identify the primary key. II. Remove any transitive dependencies. III. All partial dependencies are removed and placed in another relation.

A many-to-many relationship may be implemented using three tables.

A(n) ________ represents additional attributes of an entity that may not be present on every record of the entity.

________ are associations between entities.

An insert anomaly results when a change to one attribute value either causes the database to contain inconsistent data or causes multiple records to need changing.

REMOVE is the logical ordering of rows in a relation according to some key.

An attribute is some characteristic of a(n):

A ________ represents more than one of the other entity.

An alternative to building conventional files is building a:

Systems, Roles, and Development Methodologies

Understanding and Modeling Organizational Systems

Project Management

Information Gathering: Interactive Methods

Information Gathering: Unobtrusive Methods

Agile Modeling, Prototyping, and Scrum

Using Data Flow Diagrams

Analyzing Systems Using Data Dictionaries

Process Specifications and Structured Decisions

Object-Oriented Systems Analysis and Design Using Uml

Designing Effective Output

Designing Effective Input

Human-Computer Interaction and Ux Design

Designing Accurate Data Entry Procedures

Quality Assurance and Implementation

Filters

Exam 13: Designing Databases

Which of the following is true when implementing a one-to-many relationship?

Which is not an effectiveness objective of the database?

The process of taking a logical data model and transforming it into a physical model that is efficient for the most often used tasks is called:

Which word is used interchangeably with the term data item?

Table files are used to update master files.

A well-designed ________ can be more flexible than separate files.

Which order is correct for the analyst to normalize a data structure? I. Remove all repeating groups and identify the primary key. II. Remove any transitive dependencies. III. All partial dependencies are removed and placed in another relation.

A many-to-many relationship may be implemented using three tables.

A(n) ________ represents additional attributes of an entity that may not be present on every record of the entity.

________ are associations between entities.

An insert anomaly results when a change to one attribute value either causes the database to contain inconsistent data or causes multiple records to need changing.

REMOVE is the logical ordering of rows in a relation according to some key.

An attribute is some characteristic of a(n):

A ________ represents more than one of the other entity.

An alternative to building conventional files is building a:

Systems, Roles, and Development Methodologies

Understanding and Modeling Organizational Systems

Project Management

Information Gathering: Interactive Methods

Information Gathering: Unobtrusive Methods

Agile Modeling, Prototyping, and Scrum

Using Data Flow Diagrams

Analyzing Systems Using Data Dictionaries

Process Specifications and Structured Decisions

Object-Oriented Systems Analysis and Design Using Uml

Designing Effective Output

Designing Effective Input

Human-Computer Interaction and Ux Design

Designing Accurate Data Entry Procedures

Quality Assurance and Implementation

Filters