Question 1

Merging relations is also referred to as:

Accepted Answer

A) view integration 
B) view consolidation 
C) encompassing 
D) normalizing 
A) view integration 
B) view consolidation 
C) encompassing 
D) normalizing A

Question 2

An entity whose primary key depends on the primary key of another entity is called a:

Accepted Answer

A) referential entity 
B) candidate entity 
C) transitive entity 
D) weak entity 
A) referential entity 
B) candidate entity 
C) transitive entity 
D) weak entity D

Question 3

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

Accepted Answer

A) second normal form 
B) third normal form 
C) fourth normal form 
D) fifth normal form 
A) second normal form 
B) third normal form 
C) fourth normal form 
D) fifth normal form A

Question 4

An attribute can be functionally dependent on more than attribute.

Accepted Answer

A) True 
 B)False

Question 5

Match each of the following file organizations with a corresponding description.(Answers may occur more than once.)
-Referencing sequential retrieval on the primary key,this method is impractical.

Accepted Answer

A) indexed file organization 
B) hashed file organization 
C) sequential file organization 
A) indexed file organization 
B) hashed file organization 
C) sequential file organization

Question 6

Match each of the following terms with its corresponding definition.
-A data model that represents data in the form of tables or relations.

Accepted Answer

A) foreign key 
B) functional dependency 
C) homonym 
D) recursive foreign key 
E) referential integrity
F)relation
G)relational database model
H)synonym
I)well-structured relation 
A) foreign key 
B) functional dependency 
C) homonym 
D) recursive foreign key 
E) referential integrity
F)relation
G)relational database model
H)synonym
I)well-structured relation

Question 7

Match each of the following terms with its corresponding definition.
-A field of data that can be used to locate a related field or row of data.

Accepted Answer

A) calculated field 
B) data type 
C) default value 
D) denormalization 
E) field
F)hashed file organization
G)index
H)indexed file organization
I)pointer
J)sequential file organization 
A) calculated field 
B) data type 
C) default value 
D) denormalization 
E) field
F)hashed file organization
G)index
H)indexed file organization
I)pointer
J)sequential file organization

Question 8

Match each of the following terms with its corresponding definition.
-The smallest unit of named application data recognized by system software.

Accepted Answer

A) calculated field 
B) data type 
C) default value 
D) denormalization 
E) field
F)hashed file organization
G)index
H)indexed file organization
I)pointer
J)sequential file organization 
A) calculated field 
B) data type 
C) default value 
D) denormalization 
E) field
F)hashed file organization
G)index
H)indexed file organization
I)pointer
J)sequential file organization

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

Match each of the following terms with its corresponding definition.
-A single name that is used for two or more different attributes.

Accepted Answer

A) foreign key 
B) functional dependency 
C) homonym 
D) recursive foreign key 
E) referential integrity
F)relation
G)relational database model
H)synonym
I)well-structured relation 
A) foreign key 
B) functional dependency 
C) homonym 
D) recursive foreign key 
E) referential integrity
F)relation
G)relational database model
H)synonym
I)well-structured relation

Question 11

When using the sequential file organization,the addition of rows requires rewriting the file.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

A relation corresponds to a computer file.

Accepted Answer

A) True 
 B)False

Question 14

A __________ is a field of data that can be used to locate a related field or row of data.

Accepted Answer

The answer of A __________ is a field of data...

Question 15

Random key retrieval on the primary key is comparatively slow with the hashed file organization.

Accepted Answer

A) True 
 B)False

Question 16

The network model is the most common style for a logical database model.

Accepted Answer

A) True 
 B)False

Question 17

If for every valid value of A the value of B is determined by the value of A,then B is functionally dependent on A.

Accepted Answer

A) True 
 B)False

Question 18

Identify the five properties of a relation.

Accepted Answer

The five properties that distinguish a r

Question 19

Match each of the following terms with its corresponding definition.
-Two different names that are used to refer to the same data item.

Accepted Answer

A) foreign key 
B) functional dependency 
C) homonym 
D) recursive foreign key 
E) referential integrity
F)relation
G)relational database model
H)synonym
I)well-structured relation 
A) foreign key 
B) functional dependency 
C) homonym 
D) recursive foreign key 
E) referential integrity
F)relation
G)relational database model
H)synonym
I)well-structured relation

Question 20

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

Accepted Answer

A) True 
 B)False

Merging relations is also referred to as:

An entity whose primary key depends on the primary key of another entity is called a:

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

An attribute can be functionally dependent on more than attribute.

Match each of the following file organizations with a corresponding description.(Answers may occur more than once.) -Referencing sequential retrieval on the primary key,this method is impractical.

Match each of the following terms with its corresponding definition. -A data model that represents data in the form of tables or relations.

Match each of the following terms with its corresponding definition. -A field of data that can be used to locate a related field or row of data.

Match each of the following terms with its corresponding definition. -The smallest unit of named application data recognized by system software.

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

Match each of the following terms with its corresponding definition. -A single name that is used for two or more different attributes.

When using the sequential file organization,the addition of rows requires rewriting the file.

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

A relation corresponds to a computer file.

A __________ is a field of data that can be used to locate a related field or row of data.

Random key retrieval on the primary key is comparatively slow with the hashed file organization.

The network model is the most common style for a logical database model.

If for every valid value of A the value of B is determined by the value of A,then B is functionally dependent on A.

Identify the five properties of a relation.

Match each of the following terms with its corresponding definition. -Two different names that are used to refer to the same data item.

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

The Systems Development Environment

The Origins of Software

Managing the Information Systems Project

Identifying and Selecting Systems Development Projects

Initiating and Planning Systems Development Projects

Determining System Requirements

Structuring System Process Requirements

Structuring System Data Requirements

Designing Forms and Reports

Designing Interfaces and Dialogues

Designing Distributed and Internet Systems

System Implementation

Maintaining Information Systems

Object-Oriented Analysis and Design: Use Cases

Object-Oriented Analysis and Design: Activity Diagrams

Objected-Oriented Analysis and Design: Object Modeling-Class Diagrams

Object-Oriented Analysis and Design: Sequence Diagrams

Filters

Exam 9: Designing Databases

Merging relations is also referred to as:

An entity whose primary key depends on the primary key of another entity is called a:

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

An attribute can be functionally dependent on more than attribute.

Match each of the following file organizations with a corresponding description.(Answers may occur more than once.) -Referencing sequential retrieval on the primary key,this method is impractical.

Match each of the following terms with its corresponding definition. -A data model that represents data in the form of tables or relations.

Match each of the following terms with its corresponding definition. -A field of data that can be used to locate a related field or row of data.

Match each of the following terms with its corresponding definition. -The smallest unit of named application data recognized by system software.

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

Match each of the following terms with its corresponding definition. -A single name that is used for two or more different attributes.

When using the sequential file organization,the addition of rows requires rewriting the file.

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

A relation corresponds to a computer file.

A __________ is a field of data that can be used to locate a related field or row of data.

Random key retrieval on the primary key is comparatively slow with the hashed file organization.

The network model is the most common style for a logical database model.

If for every valid value of A the value of B is determined by the value of A,then B is functionally dependent on A.

Identify the five properties of a relation.

Match each of the following terms with its corresponding definition. -Two different names that are used to refer to the same data item.

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

The Systems Development Environment

The Origins of Software

Managing the Information Systems Project

Identifying and Selecting Systems Development Projects

Initiating and Planning Systems Development Projects

Determining System Requirements

Structuring System Process Requirements

Structuring System Data Requirements

Designing Forms and Reports

Designing Interfaces and Dialogues

Designing Distributed and Internet Systems

System Implementation

Maintaining Information Systems

Object-Oriented Analysis and Design: Use Cases

Object-Oriented Analysis and Design: Activity Diagrams

Objected-Oriented Analysis and Design: Object Modeling-Class Diagrams

Object-Oriented Analysis and Design: Sequence Diagrams

Filters