Question 1

A __________ is the smallest unit of named application data recognized by system software.

Accepted Answer

The answer of A __________ is the smallest unit of...

Question 2

The selection of data storage technologies is made during the systems implementation and operation phase.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Match each of the following terms with its corresponding definition.
-A relation that contains a minimum amount of redundancy and allows users to insert,modify,and delete the rows in a table without errors or inconsistencies.

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 6

Match each of the following terms with its corresponding definition.
-The address for each row is determined using an algorithm.

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 7

A relation is in second normal form if every nonprimary key attribute is functionally dependent on the whole primary key.

Accepted Answer

A) True 
 B)False

Question 8

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 9

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

Accepted Answer

A relation is a named two-dimensional ta

Question 10

Assume the structure of a relation is EMPLOYEE (Emp_ID,Name,Dept,Salary).The number of attributes for this relation would be:

Accepted Answer

A) three 
B) four 
C) five 
D) six 
A) three 
B) four 
C) five 
D) six

Question 11

A physical file is a named set of table rows stored in a contiguous section of secondary memory.

Accepted Answer

A) True 
 B)False

Question 12

Conceptual modeling is performed during systems design.

Accepted Answer

A) True 
 B)False

Question 13

Briefly identify the three file organizations.

Accepted Answer

Sequential,indexed,and hashed are the th

Question 14

Match each of the following E-R structures with its relational representation.
-Place the primary key of the entity on the one side of the relationship as a foreign key in the relation for the entity on the many side.

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 15

Discuss the rules for normalization.

Accepted Answer

Although first normal form is not direct

Question 16

A file organization is an arrangement of related records in secondary memory so that individual and groups of records can be stored,retrieved,and updated rapidly.

Accepted Answer

A) True 
 B)False

Question 17

Match each of the following file organizations with a corresponding description.(Answers may occur more than once.)
-Referencing updating rows,this method is easy but requires maintenance of indexes.

Accepted Answer

A) indexed file organization 
B) hashed file organization 
C) sequential file organization 
A) indexed file organization 
B) hashed file organization 
C) sequential file organization

Question 18

Normalization helps build a data model that is simple,not redundant,and requires minimum maintenance.

Accepted Answer

A) True 
 B)False

Question 19

__________ is the process of converting complex data structures into simple,stable data structures.

Accepted Answer

The answer of __________ is the process of converting complex...

Question 20

Combining all normalized user views into one consolidated logical database model refers to:

Accepted Answer

A) requirements structuring 
B) view integration 
C) normalization 
D) file integration 
A) requirements structuring 
B) view integration 
C) normalization 
D) file integration

A __________ is the smallest unit of named application data recognized by system software.

The selection of data storage technologies is made during the systems implementation and operation phase.

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

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

Match each of the following terms with its corresponding definition. -A relation that contains a minimum amount of redundancy and allows users to insert,modify,and delete the rows in a table without errors or inconsistencies.

Match each of the following terms with its corresponding definition. -The address for each row is determined using an algorithm.

A relation is in second normal form if every nonprimary key attribute is functionally dependent on the whole primary key.

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

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

Assume the structure of a relation is EMPLOYEE (Emp_ID,Name,Dept,Salary).The number of attributes for this relation would be:

A physical file is a named set of table rows stored in a contiguous section of secondary memory.

Conceptual modeling is performed during systems design.

Briefly identify the three file organizations.

Match each of the following E-R structures with its relational representation. -Place the primary key of the entity on the one side of the relationship as a foreign key in the relation for the entity on the many side.

Discuss the rules for normalization.

A file organization is an arrangement of related records in secondary memory so that individual and groups of records can be stored,retrieved,and updated rapidly.

Match each of the following file organizations with a corresponding description.(Answers may occur more than once.) -Referencing updating rows,this method is easy but requires maintenance of indexes.

Normalization helps build a data model that is simple,not redundant,and requires minimum maintenance.

__________ is the process of converting complex data structures into simple,stable data structures.

Combining all normalized user views into one consolidated logical database model refers to:

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 the smallest unit of named application data recognized by system software.

The selection of data storage technologies is made during the systems implementation and operation phase.

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

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

Match each of the following terms with its corresponding definition. -A relation that contains a minimum amount of redundancy and allows users to insert,modify,and delete the rows in a table without errors or inconsistencies.

Match each of the following terms with its corresponding definition. -The address for each row is determined using an algorithm.

A relation is in second normal form if every nonprimary key attribute is functionally dependent on the whole primary key.

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

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

Assume the structure of a relation is EMPLOYEE (Emp_ID,Name,Dept,Salary).The number of attributes for this relation would be:

A physical file is a named set of table rows stored in a contiguous section of secondary memory.

Conceptual modeling is performed during systems design.

Briefly identify the three file organizations.

Match each of the following E-R structures with its relational representation. -Place the primary key of the entity on the one side of the relationship as a foreign key in the relation for the entity on the many side.

Discuss the rules for normalization.

A file organization is an arrangement of related records in secondary memory so that individual and groups of records can be stored,retrieved,and updated rapidly.

Match each of the following file organizations with a corresponding description.(Answers may occur more than once.) -Referencing updating rows,this method is easy but requires maintenance of indexes.

Normalization helps build a data model that is simple,not redundant,and requires minimum maintenance.

__________ is the process of converting complex data structures into simple,stable data structures.

Combining all normalized user views into one consolidated logical database model refers to:

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