Question 1

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 2

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

Data security can be built into a file through encryption,passwords,or prohibiting users from directly manipulating a file.

Accepted Answer

A) True 
 B)False

Question 4

__________ is a technique for physically arranging the records of a file.

Accepted Answer

The answer of __________ is a technique for physically arranging...

Question 5

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 6

Which of the following is not a true statement regarding a relation?

Accepted Answer

A) Each relation consists of a set of named columns and an arbitrary number of unnamed rows. 
B) Each column in a relation corresponds to an attribute of that relation. 
C) An entry at the intersection of each row and column has a single value. 
D) Each row in a relation corresponds to an attribute of that relation. 
A) Each relation consists of a set of named columns and an arbitrary number of unnamed rows. 
B) Each column in a relation corresponds to an attribute of that relation. 
C) An entry at the intersection of each row and column has a single value. 
D) Each row in a relation corresponds to an attribute of that relation.

Question 7

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 8

Match each of the following terms with its corresponding definition.
-A coding scheme recognized by system software for representing organizational data.

Accepted Answer

A) calculated field 
B) data type 
C) default value 
D) denormalization 
E) field
F)hashed file organization
G)index
H)indexed file organization
I)pointer
J)sequential file organization 
A) calculated field 
B) data type 
C) default value 
D) denormalization 
E) field
F)hashed file organization
G)index
H)indexed file organization
I)pointer
J)sequential file organization

Question 9

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

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 10

A __________ is a named set of rows and columns that specifies the fields in each row of the table.

Accepted Answer

The answer of A __________ is a named set of...

Question 11

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 12

Match each of the following terms with its corresponding definition.
-A named two-dimensional table of data.

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 13

Identify several advantages and disadvantages of using an index.

Accepted Answer

By using an index,both random and sequen

Question 14

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 15

When two 3NF relations are merged to form a single relation:

Accepted Answer

A) weak entities are created 
B) recursive relationships may result 
C) transitive dependencies may result 
D) IS-A relationships are formed 
A) weak entities are created 
B) recursive relationships may result 
C) transitive dependencies may result 
D) IS-A relationships are formed

Question 16

The primary deliverable from logical database design is:

Accepted Answer

A) normalized relations 
B) design specifications 
C) an updated baseline project plan 
D) a list of alternative design strategies 
A) normalized relations 
B) design specifications 
C) an updated baseline project plan 
D) a list of alternative design strategies

Question 17

Match each of the following terms with its corresponding definition.
-A table used to determine the location of rows in a file that satisfy some condition.

Accepted Answer

A) calculated field 
B) data type 
C) default value 
D) denormalization 
E) field
F)hashed file organization
G)index
H)indexed file organization
I)pointer
J)sequential file organization 
A) calculated field 
B) data type 
C) default value 
D) denormalization 
E) field
F)hashed file organization
G)index
H)indexed file organization
I)pointer
J)sequential file organization

Question 18

__________ refers to two different names that are used for the same attribute.

Accepted Answer

The answer of __________ refers to two different names that...

Question 19

Match each of the following terms with its corresponding definition.
-The rows are stored either sequentially or nonsequentially,and a table is created that allows software to locate individual rows.

Accepted Answer

A) calculated field 
B) data type 
C) default value 
D) denormalization 
E) field
F)hashed file organization
G)index
H)indexed file organization
I)pointer
J)sequential file organization 
A) calculated field 
B) data type 
C) default value 
D) denormalization 
E) field
F)hashed file organization
G)index
H)indexed file organization
I)pointer
J)sequential file organization

Question 20

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.

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

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.

Data security can be built into a file through encryption,passwords,or prohibiting users from directly manipulating a file.

__________ is a technique for physically arranging the records of a file.

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

Which of the following is not a true statement regarding a relation?

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

Match each of the following terms with its corresponding definition. -A coding scheme recognized by system software for representing organizational data.

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

A __________ is a named set of rows and columns that specifies the fields in each row of the table.

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

Match each of the following terms with its corresponding definition. -A named two-dimensional table of data.

Identify several advantages and disadvantages of using an index.

Which of the following is not associated with database design?

When two 3NF relations are merged to form a single relation:

The primary deliverable from logical database design is:

Match each of the following terms with its corresponding definition. -A table used to determine the location of rows in a file that satisfy some condition.

__________ refers to two different names that are used for the same attribute.

Match each of the following terms with its corresponding definition. -The rows are stored either sequentially or nonsequentially,and a table is created that allows software to locate individual rows.

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

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 an attribute whose value is unique across all occurrences of a relation.

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.

Data security can be built into a file through encryption,passwords,or prohibiting users from directly manipulating a file.

__________ is a technique for physically arranging the records of a file.

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

Which of the following is not a true statement regarding a relation?

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

Match each of the following terms with its corresponding definition. -A coding scheme recognized by system software for representing organizational data.

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

A __________ is a named set of rows and columns that specifies the fields in each row of the table.

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

Match each of the following terms with its corresponding definition. -A named two-dimensional table of data.

Identify several advantages and disadvantages of using an index.

Which of the following is not associated with database design?

When two 3NF relations are merged to form a single relation:

The primary deliverable from logical database design is:

Match each of the following terms with its corresponding definition. -A table used to determine the location of rows in a file that satisfy some condition.

__________ refers to two different names that are used for the same attribute.

Match each of the following terms with its corresponding definition. -The rows are stored either sequentially or nonsequentially,and a table is created that allows software to locate individual rows.

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

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