Question 1

How is a binary one-to-one relationship represented?

Accepted Answer

A binary one-to-one relationship can be

Question 2

A ________ is an attribute whose value is unique across all occurrences of a relation.

Accepted Answer

The answer of A ________ is an attribute whose value...

Question 3

A field of data that can be used to locate a related field or row of data best describes:

Accepted Answer

A) pointer 
B) marker 
C) field locator 
D) reference locator 
A) pointer 
B) marker 
C) field locator 
D) reference locator

Question 4

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

Question 5

Normalization is based on an analysis of weak entities.

Accepted Answer

A) True 
 B)False

Question 6

Combining all normalized user views into one consolidated logical database model refers to:

Accepted Answer

A) requirements structuring 
B) view integration 
C) normalization 
D) file integration 
A) requirements structuring 
B) view integration 
C) normalization 
D) file integration

Question 7

A binary one-to-many relationship in an E-R diagram is best represented by:

Accepted Answer

A) the creation of a separate relation;the primary key of this new relation is a composite key consisting of the primary key for each of the two entities in the relationship 
B) adding the primary key attribute (or attributes)of the entity on the one side of the relationship as a foreign key in the relation that is on the many side of the relationship 
C) adding the primary key attribute (or attributes)of the entity on the many side of the relationship as a foreign key in the relation that is on the one side of the relationship 
D) creating a relation with a composite primary key and nonkey attributes 
A) the creation of a separate relation;the primary key of this new relation is a composite key consisting of the primary key for each of the two entities in the relationship 
B) adding the primary key attribute (or attributes)of the entity on the one side of the relationship as a foreign key in the relation that is on the many side of the relationship 
C) adding the primary key attribute (or attributes)of the entity on the many side of the relationship as a foreign key in the relation that is on the one side of the relationship 
D) creating a relation with a composite primary key and nonkey attributes

Question 8

A ________ is a foreign key in a relation that references the primary key values of that same relation.

Accepted Answer

recursive

Question 9

During logical modeling,the normalized data requirements from all user interfaces are combined into one consolidated logical database model.

Accepted Answer

A) True 
 B)False

Question 10

A default value is a value a field will assume unless an explicit value is entered for that field.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

A relation is in ________ if it is in second normal form and there are no functional dependencies between two (or more)nonprimary key attributes.

Accepted Answer

The answer of A relation is in ________ if it...

Question 13

Assume the structure of a relation is EMPLOYEE (Emp_ID,Name,Dept,Salary).The number of attributes for this relation would be:

Accepted Answer

A) three 
B) four 
C) five 
D) six 
A) three 
B) four 
C) five 
D) six

Question 14

Discuss the rules for normalization.

Accepted Answer

Although first normal form is not direct

Question 15

A ________ is a value a field will assume unless an explicit value is entered for that field.

Accepted Answer

The answer of A ________ is a value a field...

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

How is a binary one-to-one relationship represented?

A ________ is an attribute whose value is unique across all occurrences of a relation.

A field of data that can be used to locate a related field or row of data best describes:

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

Normalization is based on an analysis of weak entities.

Combining all normalized user views into one consolidated logical database model refers to:

A binary one-to-many relationship in an E-R diagram is best represented by:

A ________ is a foreign key in a relation that references the primary key values of that same relation.

During logical modeling,the normalized data requirements from all user interfaces are combined into one consolidated logical database model.

A default value is a value a field will assume unless an explicit value is entered for that field.

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

A relation is in ________ if it is in second normal form and there are no functional dependencies between two (or more)nonprimary key attributes.

Assume the structure of a relation is EMPLOYEE (Emp_ID,Name,Dept,Salary).The number of attributes for this relation would be:

Discuss the rules for normalization.

A ________ is a value a field will assume unless an explicit value is entered for that field.

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

If an associative entity exists,then:

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

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

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

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

Object-Oriented Analysis and Design: Sequence Diagrams

Business Process Modeling

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

Filters

Exam 9: Designing Databases

How is a binary one-to-one relationship represented?

A ________ is an attribute whose value is unique across all occurrences of a relation.

A field of data that can be used to locate a related field or row of data best describes:

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

Normalization is based on an analysis of weak entities.

Combining all normalized user views into one consolidated logical database model refers to:

A binary one-to-many relationship in an E-R diagram is best represented by:

A ________ is a foreign key in a relation that references the primary key values of that same relation.

During logical modeling,the normalized data requirements from all user interfaces are combined into one consolidated logical database model.

A default value is a value a field will assume unless an explicit value is entered for that field.

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

A relation is in ________ if it is in second normal form and there are no functional dependencies between two (or more)nonprimary key attributes.

Assume the structure of a relation is EMPLOYEE (Emp_ID,Name,Dept,Salary).The number of attributes for this relation would be:

Discuss the rules for normalization.

A ________ is a value a field will assume unless an explicit value is entered for that field.

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

If an associative entity exists,then:

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

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

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

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

Object-Oriented Analysis and Design: Sequence Diagrams

Business Process Modeling

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

Filters