Question 1

A many-to-many relationship that associates certain items with their component items is called a:

Accepted Answer

A) binary structure 
B) bill-of-materials structure 
C) binary relationship 
D) ternary relationship 
A) binary structure 
B) bill-of-materials structure 
C) binary relationship 
D) ternary relationship

Question 2

Match each of the following terms with its corresponding definition.
-A single name that is used for two or more different attributes.

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 3

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 4

If order number serves as the primary key in the ORDER relation and also appears as a nonprimary key attribute in the INVOICE relation,then order number is said to be a:

Accepted Answer

A) foreign key 
B) candidate key 
C) pointer 
D) relationship key 
A) foreign key 
B) candidate key 
C) pointer 
D) relationship key

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Object-oriented database models are the most frequently used database technologies for new information systems development.

Accepted Answer

A) True 
 B)False

Question 7

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 8

__________ refers to a particular relationship between two attributes.

Accepted Answer

Functional

Question 9

A named two-dimensional table of data is a:

Accepted Answer

A) network 
B) tree structure 
C) relation 
D) tuple 
A) network 
B) tree structure 
C) relation 
D) tuple

Question 10

Each row of a relation corresponds to a record that contains data values for an entity.

Accepted Answer

A) True 
 B)False

Question 11

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

Question 12

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 13

To convert a relation to second normal form,you decompose the relation into new relations using the attributes,called:

Accepted Answer

A) determinants 
B) foreign key 
C) pointer 
D) relationship key 
A) determinants 
B) foreign key 
C) pointer 
D) relationship key

Question 14

Match each of the following terms with its corresponding definition.
-An attribute that appears as a nonkey attribute in one relation and as a primary key attribute (or part of a primary key)in another relation.

Accepted Answer

A) foreign key 
B) functional dependency 
C) homonym 
D) recursive foreign key 
E) referential integrity
F)relation
G)relational database model
H)synonym
I)well-structured relation 
A) foreign key 
B) functional dependency 
C) homonym 
D) recursive foreign key 
E) referential integrity
F)relation
G)relational database model
H)synonym
I)well-structured relation

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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 17

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

Accepted Answer

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

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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 20

A __________ is one or a combination of fields for which more than one row may have the same combination of values.

Accepted Answer

The answer of A __________ is one or a combination...

A many-to-many relationship that associates certain items with their component items is called a:

Match each of the following terms with its corresponding definition. -A single name that is used for two or more different attributes.

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

If order number serves as the primary key in the ORDER relation and also appears as a nonprimary key attribute in the INVOICE relation,then order number is said to be a:

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

Object-oriented database models are the most frequently used database technologies for new information systems development.

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

__________ refers to a particular relationship between two attributes.

A named two-dimensional table of data is a:

Each row of a relation corresponds to a record that contains data values for an entity.

A particular relationship between two attributes best defines:

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:

To convert a relation to second normal form,you decompose the relation into new relations using the attributes,called:

Match each of the following terms with its corresponding definition. -An attribute that appears as a nonkey attribute in one relation and as a primary key attribute (or part of a primary key)in another relation.

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

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

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.

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

A __________ is one or a combination of fields for which more than one row may have the same combination of values.

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

A many-to-many relationship that associates certain items with their component items is called a:

Match each of the following terms with its corresponding definition. -A single name that is used for two or more different attributes.

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

If order number serves as the primary key in the ORDER relation and also appears as a nonprimary key attribute in the INVOICE relation,then order number is said to be a:

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

Object-oriented database models are the most frequently used database technologies for new information systems development.

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

__________ refers to a particular relationship between two attributes.

A named two-dimensional table of data is a:

Each row of a relation corresponds to a record that contains data values for an entity.

A particular relationship between two attributes best defines:

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:

To convert a relation to second normal form,you decompose the relation into new relations using the attributes,called:

Match each of the following terms with its corresponding definition. -An attribute that appears as a nonkey attribute in one relation and as a primary key attribute (or part of a primary key)in another relation.

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

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

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.

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

A __________ is one or a combination of fields for which more than one row may have the same combination of values.

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