Question 1

For a unary one-to-one relationship between two entities A and B,the relationship is represented by:

Accepted Answer

A) adding the primary key of A as a foreign key of B 
B) adding the primary key of B as a foreign key of A 
C) combining the two entities into one relation 
D) either A or B 
A) adding the primary key of A as a foreign key of B 
B) adding the primary key of B as a foreign key of A 
C) combining the two entities into one relation 
D) either A or B

Question 2

Match each of the following file organizations with a corresponding description.(Answers may occur more than once.)
-Referencing storage space,this method has no wasted space.

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 3

When using the relational notation,the primary key attribute is indicated by a dashed underline.

Accepted Answer

A) True 
 B)False

Question 4

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

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 5

A __________ is a field that can be derived from other database fields.

Accepted Answer

The answer of A __________ is a field that can...

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

"Create a relation with primary key and nonkey attributes" is the relational representation for which E-R structure?

Accepted Answer

A) weak entity 
B) regular entity 
C) gerund 
D) IS-A relationship 
A) weak entity 
B) regular entity 
C) gerund 
D) IS-A relationship

Question 8

A single name that is used for two or more different attributes best defines:

Accepted Answer

A) homonym 
B) synonym 
C) transitive dependency 
D) alias 
A) homonym 
B) synonym 
C) transitive dependency 
D) alias

Question 9

A foreign key in a relation that references the primary key values of that same relation is referred to as a:

Accepted Answer

A) secondary key 
B) recursive foreign key 
C) composite key 
D) complex key 
A) secondary key 
B) recursive foreign key 
C) composite key 
D) complex key

Question 10

Each regular entity type in an E-R diagram is transformed into a:

Accepted Answer

A) row in a relation 
B) column in a relation 
C) relation 
D) tuple in a relation 
A) row in a relation 
B) column in a relation 
C) relation 
D) tuple in a relation

Question 11

Match each of the following E-R structures with its relational representation.
-Place the primary key of either entity in the relation for the other entity or do this for both entities.

Accepted Answer

A) regular entity 
B) weak entity 
C) binary or unary 1:1 relationship 
D) binary 1:N relationship 
E) binary or unary M:N relationship or associative entity
F)binary or unary M:N relationship or associative entity with its own key 
A) regular entity 
B) weak entity 
C) binary or unary 1:1 relationship 
D) binary 1:N relationship 
E) binary or unary M:N relationship or associative entity
F)binary or unary M:N relationship or associative entity with its own key

Question 12

Multiple key retrieval is possible with the hashed file organization.

Accepted Answer

A) True 
 B)False

Question 13

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

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 14

Match each of the following E-R structures with its relational representation.
-Create a relation with a composite primary key using the primary keys of the related entities,plus any nonkey attributes of the relationship or associative entity.

Accepted Answer

A) regular entity 
B) weak entity 
C) binary or unary 1:1 relationship 
D) binary 1:N relationship 
E) binary or unary M:N relationship or associative entity
F)binary or unary M:N relationship or associative entity with its own key 
A) regular entity 
B) weak entity 
C) binary or unary 1:1 relationship 
D) binary 1:N relationship 
E) binary or unary M:N relationship or associative entity
F)binary or unary M:N relationship or associative entity with its own key

Question 15

The process of splitting or combining normalized relations into physical tables based on affinity of use of rows and fields best describes:

Accepted Answer

A) normalization 
B) simplification 
C) denormalization 
D) data structure 
A) normalization 
B) simplification 
C) denormalization 
D) data structure

Question 16

If a relationship exists among three or more entities,then:

Accepted Answer

A) recursive relationships must be established through the use of recursive foreign keys 
B) a separate relation with a primary key that is the composite of the primary keys of each of the participating entities is created 
C) separate relations are established for each class and for each of the subclasses 
D) use the primary key of relation A as a foreign key in relations B and C 
A) recursive relationships must be established through the use of recursive foreign keys 
B) a separate relation with a primary key that is the composite of the primary keys of each of the participating entities is created 
C) separate relations are established for each class and for each of the subclasses 
D) use the primary key of relation A as a foreign key in relations B and C

Question 17

When transforming an E-R diagram into normalized relations,the identifier of the entity type becomes:

Accepted Answer

A) the primary key of the corresponding relation 
B) the foreign key in the corresponding relation 
C) a nonkey attribute in the corresponding relation 
D) a secondary key in the corresponding relation 
A) the primary key of the corresponding relation 
B) the foreign key in the corresponding relation 
C) a nonkey attribute in the corresponding relation 
D) a secondary key in the corresponding relation

Question 18

During physical design,you consider:

Accepted Answer

A) the definitions of each attribute 
B) the descriptions of where and when data are entered,retrieved,deleted,and updated 
C) the expectations for response time and data integrity 
D) all of the above 
A) the definitions of each attribute 
B) the descriptions of where and when data are entered,retrieved,deleted,and updated 
C) the expectations for response time and data integrity 
D) all of the above

Question 19

Match each of the following terms with its corresponding definition.
-A foreign key in a relation that references the primary key values of that same relation.

Accepted Answer

A) foreign key 
B) functional dependency 
C) homonym 
D) normalization 
E) recursive foreign key
F)referential integrity
G)relation
H)relational database model
I)second normal form (2NF)
J)synonym
K)third normal form (3NF)
L)well-structured relation 
A) foreign key 
B) functional dependency 
C) homonym 
D) normalization 
E) recursive foreign key
F)referential integrity
G)relation
H)relational database model
I)second normal form (2NF)
J)synonym
K)third normal form (3NF)
L)well-structured relation

Question 20

What is second normal form? What conditions determine if a relation is in second normal form?

Accepted Answer

A relation is in second normal form if e

For a unary one-to-one relationship between two entities A and B,the relationship is represented by:

Match each of the following file organizations with a corresponding description.(Answers may occur more than once.) -Referencing storage space,this method has no wasted space.

When using the relational notation,the primary key attribute is indicated by a dashed underline.

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

A __________ is a field that can be derived from other database fields.

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

"Create a relation with primary key and nonkey attributes" is the relational representation for which E-R structure?

A single name that is used for two or more different attributes best defines:

A foreign key in a relation that references the primary key values of that same relation is referred to as a:

Each regular entity type in an E-R diagram is transformed into a:

Match each of the following E-R structures with its relational representation. -Place the primary key of either entity in the relation for the other entity or do this for both entities.

Multiple key retrieval is possible with the hashed file organization.

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

Match each of the following E-R structures with its relational representation. -Create a relation with a composite primary key using the primary keys of the related entities,plus any nonkey attributes of the relationship or associative entity.

The process of splitting or combining normalized relations into physical tables based on affinity of use of rows and fields best describes:

If a relationship exists among three or more entities,then:

When transforming an E-R diagram into normalized relations,the identifier of the entity type becomes:

During physical design,you consider:

Match each of the following terms with its corresponding definition. -A foreign key in a relation that references the primary key values of that same relation.

What is second normal form? What conditions determine if a relation is in second normal form?

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

For a unary one-to-one relationship between two entities A and B,the relationship is represented by:

Match each of the following file organizations with a corresponding description.(Answers may occur more than once.) -Referencing storage space,this method has no wasted space.

When using the relational notation,the primary key attribute is indicated by a dashed underline.

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

A __________ is a field that can be derived from other database fields.

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

"Create a relation with primary key and nonkey attributes" is the relational representation for which E-R structure?

A single name that is used for two or more different attributes best defines:

A foreign key in a relation that references the primary key values of that same relation is referred to as a:

Each regular entity type in an E-R diagram is transformed into a:

Match each of the following E-R structures with its relational representation. -Place the primary key of either entity in the relation for the other entity or do this for both entities.

Multiple key retrieval is possible with the hashed file organization.

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

Match each of the following E-R structures with its relational representation. -Create a relation with a composite primary key using the primary keys of the related entities,plus any nonkey attributes of the relationship or associative entity.

The process of splitting or combining normalized relations into physical tables based on affinity of use of rows and fields best describes:

If a relationship exists among three or more entities,then:

When transforming an E-R diagram into normalized relations,the identifier of the entity type becomes:

During physical design,you consider:

Match each of the following terms with its corresponding definition. -A foreign key in a relation that references the primary key values of that same relation.

What is second normal form? What conditions determine if a relation is in second normal form?

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