Question 1

The relation state specifying that nonprimary key attributes do not depend on other nonprimary key attributes is:

Accepted Answer

A) first normal form 
B) second normal form 
C) Boyce-Codd normal form 
D) third normal form 
A) first normal form 
B) second normal form 
C) Boyce-Codd normal form 
D) third normal form

Question 2

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 3

A ________ is a named,two-dimensional table of data.

Accepted Answer

The answer of A ________ is a named,two-dimensional table of...

Question 4

File restoration can be achieved through backup copies of a file,audit trails,and row image files.

Accepted Answer

A) True 
 B)False

Question 5

For any relation R,if,for every valid instance of A,that value of A uniquely determines the value of B:

Accepted Answer

A) then a primary dependency exists in the relation 
B) then A is said to be functionally dependent on B 
C) then B is said to be functionally dependent on A 
D) then A and B are candidate keys for the relation 
A) then a primary dependency exists in the relation 
B) then A is said to be functionally dependent on B 
C) then B is said to be functionally dependent on A 
D) then A and B are candidate keys for the relation

Question 6

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 7

A named set of rows and columns that specifies the fields in each row of the table best describes:

Accepted Answer

A) relation 
B) data structure 
C) entity type 
D) physical table 
A) relation 
B) data structure 
C) entity type 
D) physical table

Question 8

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

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

A null value is used to represent the zero digit in a relation.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following properties of a relation states that an entry at the intersection of each row and column is single-valued?

Accepted Answer

A) Entries in cells are simple. 
B) Entries in columns are from the same set of values. 
C) Each row is unique. 
D) The sequence of rows is insignificant. 
A) Entries in cells are simple. 
B) Entries in columns are from the same set of values. 
C) Each row is unique. 
D) The sequence of rows is insignificant.

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Two different names that refer to the same data item best defines:

Accepted Answer

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

Question 14

A particular relationship between two attributes best defines:

Accepted Answer

A) context 
B) functional dependency 
C) normal form 
D) structure 
A) context 
B) functional dependency 
C) normal form 
D) structure

The relation state specifying that nonprimary key attributes do not depend on other nonprimary key attributes is:

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

A ________ is a named,two-dimensional table of data.

File restoration can be achieved through backup copies of a file,audit trails,and row image files.

For any relation R,if,for every valid instance of A,that value of A uniquely determines the value of B:

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

A named set of rows and columns that specifies the fields in each row of the table best describes:

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

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

A null value is used to represent the zero digit in a relation.

Which of the following properties of a relation states that an entry at the intersection of each row and column is single-valued?

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

Two different names that refer to the same data item best defines:

A particular relationship between two attributes best defines:

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

The relation state specifying that nonprimary key attributes do not depend on other nonprimary key attributes is:

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

A ________ is a named,two-dimensional table of data.

File restoration can be achieved through backup copies of a file,audit trails,and row image files.

For any relation R,if,for every valid instance of A,that value of A uniquely determines the value of B:

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

A named set of rows and columns that specifies the fields in each row of the table best describes:

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

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

A null value is used to represent the zero digit in a relation.

Which of the following properties of a relation states that an entry at the intersection of each row and column is single-valued?

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

Two different names that refer to the same data item best defines:

A particular relationship between two attributes best defines:

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