Question 1

Transaction files:

Accepted Answer

A)  are large files, containing all main information about an entity. 
B)  are used to update master files and produce reports. 
C)  cannot contain several record types. 
D)  are always stored using indexed-sequential organization. 
A)  are large files, containing all main information about an entity. 
B)  are used to update master files and produce reports. 
C)  cannot contain several record types. 
D)  are always stored using indexed-sequential organization.

Question 2

What is the difference between a primary key and a secondary key?

Accepted Answer

A primary key is a key that uniquely ide

Question 3

________ is the transformation of complex user views and data stores to a set of smaller, stable
Data structures.

Accepted Answer

A)  Categorization 
B)  Capitalization 
C)  Alphabetization 
D)  Normalization 
A)  Categorization 
B)  Capitalization 
C)  Alphabetization 
D)  Normalization

Question 4

Entity integrity constraints are rules that govern the composition of primary keys.

Accepted Answer

A) True 
 B)False

Question 5

Give two examples of primary keys that can be used to identify a person or thing.

Accepted Answer

Students may have a wide range of exampl

Question 6

An entity subtype is an entity that is used to represent a many-to-many relationship.

Accepted Answer

A) True 
 B)False

Question 7

Transaction files contain information necessary to produce reports but are not able to update master files.

Accepted Answer

A) True 
 B)False

Question 8

Master files are large and contain all the information about an entity.

Accepted Answer

A) True 
 B)False

Question 9

One of the primary advantages of the relational structure is that ad hoc queries are efficiently handled.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following is not one of the four anomalies that may occur when creating database tables?

Accepted Answer

A)  data redundancy 
B)  update anomaly 
C)  primary anomaly 
D)  insert anomaly 
E)  deletion anomaly 
A)  data redundancy 
B)  update anomaly 
C)  primary anomaly 
D)  insert anomaly 
E)  deletion anomaly

Question 11

Any object or event about which someone chooses to collect data is an attribute.

Accepted Answer

A) True 
 B)False

Question 12

What is a collection of data items that have something in common with the entity?

Accepted Answer

A)  a record 
B)  an attribute 
C)  a data item 
D)  an entity 
A)  a record 
B)  an attribute 
C)  a data item 
D)  an entity

Question 13

Which is not related to conventional files?

Accepted Answer

A)  Files will remain a practical way to store data for some applications. 
B)  A file can be designed and built quite rapidly. 
C)  Files are a central source of data meant to be shared by many users for a variety of applications. 
D)  The concerns for data availability and security are minimized. 
A)  Files will remain a practical way to store data for some applications. 
B)  A file can be designed and built quite rapidly. 
C)  Files are a central source of data meant to be shared by many users for a variety of applications. 
D)  The concerns for data availability and security are minimized.

Question 14

In relational structures, a file is called a relation, a record is usually referred to as a tuple, and the attribute value set is called a domain.

Accepted Answer

A) True 
 B)False

Question 15

Data have a better chance of being available in a conventional file system than in a database.

Accepted Answer

A) True 
 B)False

Question 16

Many data items can be packed into a field; the field can be read and converted to a number of data items.

Accepted Answer

A) True 
 B)False

Question 17

Presentation of the data abstracted from the database must take one of two forms: graphs and tabular forms.

Accepted Answer

A) True 
 B)False

Question 18

An object identifier is a unique key for each record in the database, not just in a table.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

When an entity has a relationship connecting it to itself, it is called a(n):

Accepted Answer

A)  unitary relationship. 
B)  inverse relationship. 
C)  extensible join. 
D)  self-join. 
A)  unitary relationship. 
B)  inverse relationship. 
C)  extensible join. 
D)  self-join.

Transaction files:

What is the difference between a primary key and a secondary key?

________ is the transformation of complex user views and data stores to a set of smaller, stable Data structures.

Entity integrity constraints are rules that govern the composition of primary keys.

Give two examples of primary keys that can be used to identify a person or thing.

An entity subtype is an entity that is used to represent a many-to-many relationship.

Transaction files contain information necessary to produce reports but are not able to update master files.

Master files are large and contain all the information about an entity.

One of the primary advantages of the relational structure is that ad hoc queries are efficiently handled.

Which of the following is not one of the four anomalies that may occur when creating database tables?

Any object or event about which someone chooses to collect data is an attribute.

What is a collection of data items that have something in common with the entity?

Which is not related to conventional files?

In relational structures, a file is called a relation, a record is usually referred to as a tuple, and the attribute value set is called a domain.

Data have a better chance of being available in a conventional file system than in a database.

Many data items can be packed into a field; the field can be read and converted to a number of data items.

Presentation of the data abstracted from the database must take one of two forms: graphs and tabular forms.

An object identifier is a unique key for each record in the database, not just in a table.

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

When an entity has a relationship connecting it to itself, it is called a(n):

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

Transaction files:

What is the difference between a primary key and a secondary key?

________ is the transformation of complex user views and data stores to a set of smaller, stable Data structures.

Entity integrity constraints are rules that govern the composition of primary keys.

Give two examples of primary keys that can be used to identify a person or thing.

An entity subtype is an entity that is used to represent a many-to-many relationship.

Transaction files contain information necessary to produce reports but are not able to update master files.

Master files are large and contain all the information about an entity.

One of the primary advantages of the relational structure is that ad hoc queries are efficiently handled.

Which of the following is not one of the four anomalies that may occur when creating database tables?

Any object or event about which someone chooses to collect data is an attribute.

What is a collection of data items that have something in common with the entity?

Which is not related to conventional files?

In relational structures, a file is called a relation, a record is usually referred to as a tuple, and the attribute value set is called a domain.

Data have a better chance of being available in a conventional file system than in a database.

Many data items can be packed into a field; the field can be read and converted to a number of data items.

Presentation of the data abstracted from the database must take one of two forms: graphs and tabular forms.

An object identifier is a unique key for each record in the database, not just in a table.

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

When an entity has a relationship connecting it to itself, it is called a(n):

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