Exam 14: Database Design

Master files or tables contain records that are relatively permanent. Thus, once a record has been added to a master file, it remains in the system indefinitely. The values of fields for the record will change over its lifetime, but the individual records are retained indefinitely.

(True/False)

4.9/5

(33)

Question 101

Appropriate controls must be designed to ensure that no field takes on a value that is outside of the range of legal values. This refers to:

(Multiple Choice)

4.8/5

(35)

Question 102

A collection of similar records is known as:

(Multiple Choice)

4.9/5

(36)

Question 103

The primary key for a record can have a NULL value. This defines a template record.

(True/False)

4.8/5

(47)

Question 104

______________________________________ files contain relatively static data that can be shared by applications to maintain consistency and improve performance.

(Short Answer)

4.9/5

(33)

Question 105

Database design should proceed only if the underlying logical data model is in at least _____________________ normal form.

(Short Answer)

4.9/5

(35)

Question 106

When entire tables are duplicated and stored in multiple locations or file servers, it is known as:

(Multiple Choice)

4.9/5

(45)

Question 107

The physical, relational database implementation of the data model is known as the scenario.

(True/False)

4.7/5

(44)

Question 108

Most organizations build several databases leading to significant and uncontrolled redundancy between databases.

(True/False)

4.9/5

(36)

Question 109

A primary key is a field whose values identify one and only one record in a file.

(True/False)

4.8/5

(34)

Question 110

A role name is an alternate name for a foreign key that clearly distinguishes the purpose that the foreign key serves in the table.

(True/False)

4.9/5

(42)

Question 111

Files that are special records of updates to other files, especially master and transaction files, are known as:

(Multiple Choice)

4.7/5

(35)

Question 112

Database technology is ______________________ (simpler or more complex) than file technology.

(Short Answer)

4.9/5

(41)

Question 113

A database management system (DBMS) is specialized computer software available from computer vendors that is used to create, access, control, and manage the database.

(True/False)

4.9/5

(33)

Question 114

Some database systems can compress unused fields and values to conserve disk storage space.

(True/False)

4.9/5

(39)

Question 115

Which of the following are not criteria for producing a quality data model?

(Multiple Choice)

4.9/5

(44)

Question 116

Foreign keys are pointers to the records of a different file in a database.

(True/False)

4.7/5

(35)

Question 117

A(n) _____________________________ is a collection of similar records.

(Short Answer)

4.9/5

(38)

Question 118

A single file in a database may only have one _ key, but it may have several ______keys.

(Short Answer)

4.9/5

(32)

Question 119

_________________________________ record structures allow different records in the same file to have different lengths.

(Short Answer)

4.8/5

(33)

Question 120

Showing 101 - 120 of 268

Master files or tables contain records that are relatively permanent. Thus, once a record has been added to a master file, it remains in the system indefinitely. The values of fields for the record will change over its lifetime, but the individual records are retained indefinitely.

Appropriate controls must be designed to ensure that no field takes on a value that is outside of the range of legal values. This refers to:

A collection of similar records is known as:

The primary key for a record can have a NULL value. This defines a template record.

______________________________________ files contain relatively static data that can be shared by applications to maintain consistency and improve performance.

Database design should proceed only if the underlying logical data model is in at least _____________________ normal form.

When entire tables are duplicated and stored in multiple locations or file servers, it is known as:

The physical, relational database implementation of the data model is known as the scenario.

Most organizations build several databases leading to significant and uncontrolled redundancy between databases.

A primary key is a field whose values identify one and only one record in a file.

A role name is an alternate name for a foreign key that clearly distinguishes the purpose that the foreign key serves in the table.

Files that are special records of updates to other files, especially master and transaction files, are known as:

Database technology is ______________________ (simpler or more complex) than file technology.

A database management system (DBMS) is specialized computer software available from computer vendors that is used to create, access, control, and manage the database.

Some database systems can compress unused fields and values to conserve disk storage space.

Which of the following are not criteria for producing a quality data model?

Foreign keys are pointers to the records of a different file in a database.

A(n) _____________________________ is a collection of similar records.

A single file in a database may only have one _ key, but it may have several ______keys.

_________________________________ record structures allow different records in the same file to have different lengths.

The Context of Systems Analysis and Design Methods

Information System Building Blocks

Information Systems Development

Project Management

Systems Analysis

Fact-Finding Techniques for Requirements Discovery

Modeling System Requirements With Use Cases

Data Modeling and Analysis

Process Modeling

Object-Oriented Analysis and Modeling Using the Uml

Feasibility Analysis and the System Proposal

Systems Design

Application Architecture and Modeling

Output Design and Prototyping

Input Design and Prototyping

User Interface Design

Object-Oriented Design and Modeling Using the UML

Systems Construction and Implementation

Systems Operations and Support

Filters

Exam 14: Database Design

Master files or tables contain records that are relatively permanent. Thus, once a record has been added to a master file, it remains in the system indefinitely. The values of fields for the record will change over its lifetime, but the individual records are retained indefinitely.

Appropriate controls must be designed to ensure that no field takes on a value that is outside of the range of legal values. This refers to:

A collection of similar records is known as:

The primary key for a record can have a NULL value. This defines a template record.

______________________________________ files contain relatively static data that can be shared by applications to maintain consistency and improve performance.

Database design should proceed only if the underlying logical data model is in at least _____________________ normal form.

When entire tables are duplicated and stored in multiple locations or file servers, it is known as:

The physical, relational database implementation of the data model is known as the scenario.

Most organizations build several databases leading to significant and uncontrolled redundancy between databases.

A primary key is a field whose values identify one and only one record in a file.

A role name is an alternate name for a foreign key that clearly distinguishes the purpose that the foreign key serves in the table.

Files that are special records of updates to other files, especially master and transaction files, are known as:

Database technology is ______________________ (simpler or more complex) than file technology.

A database management system (DBMS) is specialized computer software available from computer vendors that is used to create, access, control, and manage the database.

Some database systems can compress unused fields and values to conserve disk storage space.

Which of the following are not criteria for producing a quality data model?

Foreign keys are pointers to the records of a different file in a database.

A(n) _____________________________ is a collection of similar records.

A single file in a database may only have one _______________________ key, but it may have several ____________________________keys.

_________________________________ record structures allow different records in the same file to have different lengths.

The Context of Systems Analysis and Design Methods

Information System Building Blocks

Information Systems Development

Project Management

Systems Analysis

Fact-Finding Techniques for Requirements Discovery

Modeling System Requirements With Use Cases

Data Modeling and Analysis

Process Modeling

Object-Oriented Analysis and Modeling Using the Uml

Feasibility Analysis and the System Proposal

Systems Design

Application Architecture and Modeling

Output Design and Prototyping

Input Design and Prototyping

User Interface Design

Object-Oriented Design and Modeling Using the UML

Systems Construction and Implementation

Systems Operations and Support

Filters

A single file in a database may only have one _ key, but it may have several ______keys.