Question 1

File and database design occurs in two steps.

Accepted Answer

A) True 
 B)False

Question 2

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 3

Which of the following properties should be satisfied when the identifier of the entity type becomes the primary key of the corresponding relation?

Accepted Answer

A) The value of the key must uniquely identify every row in the relation. 
B) The key should serve as a foreign key in at least two other relations. 
C) The key must be a composite of a primary key and a secondary key. 
D) The key should be an intelligent key. 
A) The value of the key must uniquely identify every row in the relation. 
B) The key should serve as a foreign key in at least two other relations. 
C) The key must be a composite of a primary key and a secondary key. 
D) The key should be an intelligent key.

Question 4

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 5

Transitive attributes are attributes that determine other attributes.

Accepted Answer

A) True 
 B)False

Question 6

A relation corresponds to a computer file.

Accepted Answer

A) True 
 B)False

Question 7

A ________ is a coding scheme recognized by system software for representing organizational data.

Accepted Answer

The answer of A ________ is a coding scheme recognized...

Question 8

A ________ is an attribute that appears as a nonprimary key attribute in one relation and as a primary key attribute (or part of a primary key)in another relation.

Accepted Answer

The answer of A ________ is an attribute that appears...

Question 9

When using the relational notation,the primary key attribute is indicated by a dashed underline.

Accepted Answer

A) True 
 B)False

Question 10

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 11

For a binary many-to-many relationship existing between entity types A and B:

Accepted Answer

A) a separate relation C is created;the primary key of relation C is a composite key consisting of the primary key for each of the two entities in the relationship 
B) the primary keys of relation A and relation B are designated as functionally dependent attributes 
C) secondary keys are used to establish the relationship 
D) place the primary key of either entity in the relation for the other entity or do this for both entities 
A) a separate relation C is created;the primary key of relation C is a composite key consisting of the primary key for each of the two entities in the relationship 
B) the primary keys of relation A and relation B are designated as functionally dependent attributes 
C) secondary keys are used to establish the relationship 
D) place the primary key of either entity in the relation for the other entity or do this for both entities

Question 12

________ refers to a particular relationship between two attributes.

Accepted Answer

Functional

Question 13

When using the sequential file organization,the addition of rows requires rewriting the file.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

Identify the five properties of a relation.

Accepted Answer

The five properties that distinguish a r

Question 16

A relation is said to be in second normal form when its nonprimary key attributes do not depend on each other.

Accepted Answer

A) True 
 B)False

Question 17

________ 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 18

Identify several advantages and disadvantages of using an index.

Accepted Answer

By using an index,both random and sequen

Question 19

A foreign key in a relation that references the primary key values of that same relation is referred to as a:

Accepted Answer

A) secondary key 
B) recursive foreign key 
C) composite key 
D) complex key 
A) secondary key 
B) recursive foreign key 
C) composite key 
D) complex key

Question 20

For a unary one-to-one relationship between two entities A and B,the relationship is represented by:

Accepted Answer

A) adding the primary key of A as a foreign key of B 
B) adding the primary key of B as a foreign key of A 
C) combining the two entities into one relation 
D) either A or B 
A) adding the primary key of A as a foreign key of B 
B) adding the primary key of B as a foreign key of A 
C) combining the two entities into one relation 
D) either A or B

File and database design occurs in two steps.

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

Which of the following properties should be satisfied when the identifier of the entity type becomes the primary key of the corresponding relation?

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

Transitive attributes are attributes that determine other attributes.

A relation corresponds to a computer file.

A ________ is a coding scheme recognized by system software for representing organizational data.

A ________ is an attribute that appears as a nonprimary key attribute in one relation and as a primary key attribute (or part of a primary key)in another relation.

When using the relational notation,the primary key attribute is indicated by a dashed underline.

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:

For a binary many-to-many relationship existing between entity types A and B:

________ refers to a particular relationship between two attributes.

When using the sequential file organization,the addition of rows requires rewriting the file.

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

Identify the five properties of a relation.

A relation is said to be in second normal form when its nonprimary key attributes do not depend on each other.

________ 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.

Identify several advantages and disadvantages of using an index.

A foreign key in a relation that references the primary key values of that same relation is referred to as a:

For a unary one-to-one relationship between two entities A and B,the relationship is represented by:

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

File and database design occurs in two steps.

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

Which of the following properties should be satisfied when the identifier of the entity type becomes the primary key of the corresponding relation?

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

Transitive attributes are attributes that determine other attributes.

A relation corresponds to a computer file.

A ________ is a coding scheme recognized by system software for representing organizational data.

A ________ is an attribute that appears as a nonprimary key attribute in one relation and as a primary key attribute (or part of a primary key)in another relation.

When using the relational notation,the primary key attribute is indicated by a dashed underline.

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:

For a binary many-to-many relationship existing between entity types A and B:

________ refers to a particular relationship between two attributes.

When using the sequential file organization,the addition of rows requires rewriting the file.

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

Identify the five properties of a relation.

A relation is said to be in second normal form when its nonprimary key attributes do not depend on each other.

________ 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.

Identify several advantages and disadvantages of using an index.

A foreign key in a relation that references the primary key values of that same relation is referred to as a:

For a unary one-to-one relationship between two entities A and B,the relationship is represented by:

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