Question 1

Match each of the following terms with its corresponding definition.
-The rows in the file are stored in sequence according to a primary key value.

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 2

Sequential retrieval on the primary key is very fast with the hashed file organization.

Accepted Answer

A) True 
 B)False

Question 3

If an associative entity exists,then:

Accepted Answer

A) a separate relation C is created; the primary key of relation C is a composite key consisting of the primary key for each of the two entities in the relationship 
B) the primary keys of relation A and relation B are designated as functionally dependent attributes 
C) secondary keys are used to establish the relationship 
D) place the primary key of either entity in the relation for the other entity or do this for both entities 
A) a separate relation C is created; the primary key of relation C is a composite key consisting of the primary key for each of the two entities in the relationship 
B) the primary keys of relation A and relation B are designated as functionally dependent attributes 
C) secondary keys are used to establish the relationship 
D) place the primary key of either entity in the relation for the other entity or do this for both entities

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

The network database model is a popular database technology for new information systems.

Accepted Answer

A) True 
 B)False

Question 6

For a binary 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 7

A relation is in __________ if every nonprimary key attribute is functionally dependent on the whole primary key.

Accepted Answer

The answer of A relation is in __________ if every...

Question 8

Match each of the following terms with its corresponding definition.
-A field that can be derived from other database fields.

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

In general,data structure refers to grouping attributes from the logical database model into physical records.

Accepted Answer

A) True 
 B)False

Question 10

A data model that represents data in the form of tables or relations is called a:

Accepted Answer

A) hierarchical database model 
B) network database model 
C) relational database model 
D) hybrid database model 
A) hierarchical database model 
B) network database model 
C) relational database model 
D) hybrid database model

Question 11

Match each of the following terms with its corresponding definition.
-A relation is in this form if it is in second normal form and no transitive dependencies exist.

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 12

Generally speaking,logical and physical database design is performed in parallel with other systems design steps.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following is not a key step in logical database modeling and design?

Accepted Answer

A) Combine normalized data requirements from all user interfaces into one consolidated logical database model. 
B) Compare the consolidated logical database design with the translated E-R model and produce,through view integration,one final logical database design for the application. 
C) Model how data flow through an information system,the relationships among the data flows,and how data come to be stored at specific locations. 
D) Translate the conceptual E-R data model for the application into normalized data requirements. 
A) Combine normalized data requirements from all user interfaces into one consolidated logical database model. 
B) Compare the consolidated logical database design with the translated E-R model and produce,through view integration,one final logical database design for the application. 
C) Model how data flow through an information system,the relationships among the data flows,and how data come to be stored at specific locations. 
D) Translate the conceptual E-R data model for the application into normalized data requirements.

Question 14

__________ is an integrity constraint specifying that the value (or existence)of an attribute in one relation depends on the value (or existence)of the same attribute in another relation.

Accepted Answer

Referentia

Question 15

__________ is a single attribute name that is used for two or more different attributes.

Accepted Answer

The answer of __________ is a single attribute name that...

Question 16

The most common style for a logical database model is the:

Accepted Answer

A) relational database model 
B) hierarchical database model 
C) network database model 
D) object-oriented database model 
A) relational database model 
B) hierarchical database model 
C) network database model 
D) object-oriented database model

Question 17

A well-structured relation contains data about two or more entities.

Accepted Answer

A) True 
 B)False

Question 18

Efficient use of secondary storage and data processing speed are two goals of physical table design.

Accepted Answer

A) True 
 B)False

Question 19

Which of the following properties should be satisfied when the identifier of the entity type becomes the primary key of the corresponding relation?

Accepted Answer

A) The value of the key must uniquely identify every row in the relation. 
B) The key should serve as a foreign key in at least two other relations. 
C) The key must be a composite of a primary key and a secondary key. 
D) The key should be an intelligent key. 
A) The value of the key must uniquely identify every row in the relation. 
B) The key should serve as a foreign key in at least two other relations. 
C) The key must be a composite of a primary key and a secondary key. 
D) The key should be an intelligent key.

Question 20

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) 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

Match each of the following terms with its corresponding definition. -The rows in the file are stored in sequence according to a primary key value.

Sequential retrieval on the primary key is very fast with the hashed file organization.

If an associative entity exists,then:

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

The network database model is a popular database technology for new information systems.

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

A relation is in __________ if every nonprimary key attribute is functionally dependent on the whole primary key.

Match each of the following terms with its corresponding definition. -A field that can be derived from other database fields.

In general,data structure refers to grouping attributes from the logical database model into physical records.

A data model that represents data in the form of tables or relations is called a:

Match each of the following terms with its corresponding definition. -A relation is in this form if it is in second normal form and no transitive dependencies exist.

Generally speaking,logical and physical database design is performed in parallel with other systems design steps.

Which of the following is not a key step in logical database modeling and design?

__________ is an integrity constraint specifying that the value (or existence)of an attribute in one relation depends on the value (or existence)of the same attribute in another relation.

__________ is a single attribute name that is used for two or more different attributes.

The most common style for a logical database model is the:

A well-structured relation contains data about two or more entities.

Efficient use of secondary storage and data processing speed are two goals of physical table design.

Which of the following properties should be satisfied when the identifier of the entity type becomes the primary key of the corresponding 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 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

Match each of the following terms with its corresponding definition. -The rows in the file are stored in sequence according to a primary key value.

Sequential retrieval on the primary key is very fast with the hashed file organization.

If an associative entity exists,then:

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

The network database model is a popular database technology for new information systems.

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

A relation is in __________ if every nonprimary key attribute is functionally dependent on the whole primary key.

Match each of the following terms with its corresponding definition. -A field that can be derived from other database fields.

In general,data structure refers to grouping attributes from the logical database model into physical records.

A data model that represents data in the form of tables or relations is called a:

Match each of the following terms with its corresponding definition. -A relation is in this form if it is in second normal form and no transitive dependencies exist.

Generally speaking,logical and physical database design is performed in parallel with other systems design steps.

Which of the following is not a key step in logical database modeling and design?

__________ is an integrity constraint specifying that the value (or existence)of an attribute in one relation depends on the value (or existence)of the same attribute in another relation.

__________ is a single attribute name that is used for two or more different attributes.

The most common style for a logical database model is the:

A well-structured relation contains data about two or more entities.

Efficient use of secondary storage and data processing speed are two goals of physical table design.

Which of the following properties should be satisfied when the identifier of the entity type becomes the primary key of the corresponding 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 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