Question 1

Define each of the following terms: relation,functional dependency,foreign key,and normalization.

Accepted Answer

A relation is a named two-dimensional ta

Question 2

Conceptual modeling is performed during systems design.

Accepted Answer

A) True 
 B)False

Question 3

Sequential files are practical for random row retrievals.

Accepted Answer

A) True 
 B)False

Question 4

Indexes should be used generously for databases intended primarily to support data retrievals.

Accepted Answer

A) True 
 B)False

Question 5

Indexes should be used judiciously for databases that support transaction processing and other applications with heavy updating requirements.

Accepted Answer

A) True 
 B)False

Question 6

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 7

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 8

Each column in a relation corresponds to an entity type.

Accepted Answer

A) True 
 B)False

Question 9

The following are steps to transforming an E-R diagram into normalized relations and then merging all the relations into one final,consolidated set of relations except for:

Accepted Answer

A) represent entities 
B) represent relationships 
C) normalize the relations 
D) denormalize the relations 
A) represent entities 
B) represent relationships 
C) normalize the relations 
D) denormalize the relations

Question 10

Which of the following is not associated with database design?

Accepted Answer

A) Structure the data in stable structures that are not likely to change over time and that have minimal redundancy. 
B) The preparation of a final conceptual model and the implementation of the database. 
C) Develop a logical database design from which we can do physical database design. 
D) Develop a logical database design that reflects the actual data requirements that exist in the forms and reports of an information system. 
A) Structure the data in stable structures that are not likely to change over time and that have minimal redundancy. 
B) The preparation of a final conceptual model and the implementation of the database. 
C) Develop a logical database design from which we can do physical database design. 
D) Develop a logical database design that reflects the actual data requirements that exist in the forms and reports of an information system.

Question 11

A ________ represents data as a set of related tables or relations.

Accepted Answer

relational

Question 12

A functional dependency between two (or more)nonprimary key attributes in a relation defines a:

Accepted Answer

A) weak dependency 
B) partial dependency 
C) simple dependency 
D) transitive dependency 
A) weak dependency 
B) partial dependency 
C) simple dependency 
D) transitive dependency

Question 13

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 14

One property of a relation is that entries in a given column are from the same set of values.

Accepted Answer

A) True 
 B)False

Question 15

A table used to determine the location of rows in a file that satisfy some condition best describes:

Accepted Answer

A) relation 
B) structure chart 
C) index 
D) domain table 
A) relation 
B) structure chart 
C) index 
D) domain table

Question 16

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

Question 17

A special field value,distinct from 0,blank,or any other value,that indicates that the value for the field is missing or otherwise unknown best defines:

Accepted Answer

A) transitive value 
B) primary key 
C) null value 
D) pointer 
A) transitive value 
B) primary key 
C) null value 
D) pointer

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

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

Question 20

A ________ is a relation that contains a minimum amount of redundancy and allows users to insert,modify,and delete the rows without errors or inconsistencies.

Accepted Answer

well-struc

Define each of the following terms: relation,functional dependency,foreign key,and normalization.

Conceptual modeling is performed during systems design.

Sequential files are practical for random row retrievals.

Indexes should be used generously for databases intended primarily to support data retrievals.

Indexes should be used judiciously for databases that support transaction processing and other applications with heavy updating requirements.

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

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

Each column in a relation corresponds to an entity type.

The following are steps to transforming an E-R diagram into normalized relations and then merging all the relations into one final,consolidated set of relations except for:

Which of the following is not associated with database design?

A ________ represents data as a set of related tables or relations.

A functional dependency between two (or more)nonprimary key attributes in a relation defines a:

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

One property of a relation is that entries in a given column are from the same set of values.

A table used to determine the location of rows in a file that satisfy some condition best describes:

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

A special field value,distinct from 0,blank,or any other value,that indicates that the value for the field is missing or otherwise unknown best defines:

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

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

A ________ is a relation that contains a minimum amount of redundancy and allows users to insert,modify,and delete the rows without errors or inconsistencies.

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

Define each of the following terms: relation,functional dependency,foreign key,and normalization.

Conceptual modeling is performed during systems design.

Sequential files are practical for random row retrievals.

Indexes should be used generously for databases intended primarily to support data retrievals.

Indexes should be used judiciously for databases that support transaction processing and other applications with heavy updating requirements.

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

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

Each column in a relation corresponds to an entity type.

The following are steps to transforming an E-R diagram into normalized relations and then merging all the relations into one final,consolidated set of relations except for:

Which of the following is not associated with database design?

A ________ represents data as a set of related tables or relations.

A functional dependency between two (or more)nonprimary key attributes in a relation defines a:

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

One property of a relation is that entries in a given column are from the same set of values.

A table used to determine the location of rows in a file that satisfy some condition best describes:

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

A special field value,distinct from 0,blank,or any other value,that indicates that the value for the field is missing or otherwise unknown best defines:

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

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

A ________ is a relation that contains a minimum amount of redundancy and allows users to insert,modify,and delete the rows without errors or inconsistencies.

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