Question 1

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

Question 2

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 3

Relationships between instances of a single entity type are referred to as:

Accepted Answer

A) binary relationships 
B) transitive relationships 
C) recursive relationships 
D) dependent relationships 
A) binary relationships 
B) transitive relationships 
C) recursive relationships 
D) dependent relationships

Question 4

You have recently been hired by an appliance repair company.Your first task is to normalize the following relation.

Accepted Answer

After normalization,students should iden

Question 5

The selection of the appropriate storage format for each attribute from the logical database model is made during physical database design.

Accepted Answer

A) True 
 B)False

Question 6

Match each of the following terms with its corresponding definition.
-An integrity constraint that specifies 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

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 7

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

Accepted Answer

The answer of __________ is a special field value,distinct from...

Question 8

Match each of the following E-R structures with its relational representation.
-Create a relation with primary key and nonkey attributes.

Accepted Answer

A) regular entity 
B) weak entity 
C) binary or unary 1:1 relationship 
D) binary 1:N relationship 
E) binary or unary M:N relationship or associative entity
F)binary or unary M:N relationship or associative entity with its own key 
A) regular entity 
B) weak entity 
C) binary or unary 1:1 relationship 
D) binary 1:N relationship 
E) binary or unary M:N relationship or associative entity
F)binary or unary M:N relationship or associative entity with its own key

Question 9

The index file organization:

Accepted Answer

A) provides very fast random retrieval on the primary key 
B) provides slow random retrieval on the primary key 
C) provides moderately fast random retrieval on the primary key 
D) does not provide random retrieval on the primary key 
A) provides very fast random retrieval on the primary key 
B) provides slow random retrieval on the primary key 
C) provides moderately fast random retrieval on the primary key 
D) does not provide random retrieval on the primary key

Question 10

Denormalization reduces the chance of errors introduced by normalizing relations.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

relational

Question 12

Sequential files are practical for random row retrievals.

Accepted Answer

A) True 
 B)False

Question 13

During logical database design,the work of all systems development team members is coordinated and shared through:

Accepted Answer

A) the project dictionary 
B) scheduled weekly meetings 
C) the project leader 
D) JAD sessions 
A) the project dictionary 
B) scheduled weekly meetings 
C) the project leader 
D) JAD sessions

Question 14

A transitive dependency is an integrity constraint specifying that the value of an attribute in one relation depends on the value of the same attribute in another relation.

Accepted Answer

A) True 
 B)False

Question 15

Match each of the following E-R structures with its relational representation.
-Create a relation with a composite primary key that includes the primary key of the entity on which this entity depends and nonkey attributes.

Accepted Answer

A) regular entity 
B) weak entity 
C) binary or unary 1:1 relationship 
D) binary 1:N relationship 
E) binary or unary M:N relationship or associative entity
F)binary or unary M:N relationship or associative entity with its own key 
A) regular entity 
B) weak entity 
C) binary or unary 1:1 relationship 
D) binary 1:N relationship 
E) binary or unary M:N relationship or associative entity
F)binary or unary M:N relationship or associative entity with its own key

Question 16

For a unary M:N relationship:

Accepted Answer

A) the entity type is modeled as one relation; using as its primary key a composite key,a separate relation is created to represent the M:N relationship 
B) the entity type and the M:N relationship are modeled as one relation; a composite key is used 
C) separate relations for the class and for each subclass are created; primary and foreign keys are established for each class 
D) the primary key of the entity on the one side of the relationship serves as a foreign key in the relation on the many side of the relationship 
A) the entity type is modeled as one relation; using as its primary key a composite key,a separate relation is created to represent the M:N relationship 
B) the entity type and the M:N relationship are modeled as one relation; a composite key is used 
C) separate relations for the class and for each subclass are created; primary and foreign keys are established for each class 
D) the primary key of the entity on the one side of the relationship serves as a foreign key in the relation on the many side of the relationship

Question 17

Match each of the following terms with its corresponding definition.
-A particular relationship between two attributes.For every valid instance of A,the value of A uniquely determines the value of B.

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

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.

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

Relationships between instances of a single entity type are referred to as:

You have recently been hired by an appliance repair company.Your first task is to normalize the following relation.

The selection of the appropriate storage format for each attribute from the logical database model is made during physical database design.

Match each of the following terms with its corresponding definition. -An integrity constraint that specifies 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 special field value,distinct from 0,blank,or any other value,that indicates that the value for the field is missing or otherwise unknown.

Match each of the following E-R structures with its relational representation. -Create a relation with primary key and nonkey attributes.

The index file organization:

Denormalization reduces the chance of errors introduced by normalizing relations.

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

Sequential files are practical for random row retrievals.

During logical database design,the work of all systems development team members is coordinated and shared through:

A transitive dependency is an integrity constraint specifying that the value of an attribute in one relation depends on the value of the same attribute in another relation.

Match each of the following E-R structures with its relational representation. -Create a relation with a composite primary key that includes the primary key of the entity on which this entity depends and nonkey attributes.

For a unary M:N relationship:

Match each of the following terms with its corresponding definition. -A particular relationship between two attributes.For every valid instance of A,the value of A uniquely determines the value of B.

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 __________ is a relation that contains a minimum amount of redundancy and allows users to insert,modify,and delete the rows without errors or inconsistencies.

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

Relationships between instances of a single entity type are referred to as:

You have recently been hired by an appliance repair company.Your first task is to normalize the following relation.

The selection of the appropriate storage format for each attribute from the logical database model is made during physical database design.

Match each of the following terms with its corresponding definition. -An integrity constraint that specifies 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 special field value,distinct from 0,blank,or any other value,that indicates that the value for the field is missing or otherwise unknown.

Match each of the following E-R structures with its relational representation. -Create a relation with primary key and nonkey attributes.

The index file organization:

Denormalization reduces the chance of errors introduced by normalizing relations.

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

Sequential files are practical for random row retrievals.

During logical database design,the work of all systems development team members is coordinated and shared through:

A transitive dependency is an integrity constraint specifying that the value of an attribute in one relation depends on the value of the same attribute in another relation.

Match each of the following E-R structures with its relational representation. -Create a relation with a composite primary key that includes the primary key of the entity on which this entity depends and nonkey attributes.

For a unary M:N relationship:

Match each of the following terms with its corresponding definition. -A particular relationship between two attributes.For every valid instance of A,the value of A uniquely determines the value of B.

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