Exam 8: Structuring System Data Requirements

Explore all topics

Match each of the following terms with its corresponding definition. -Specifies that each entity instance of the supertype must be a member of some subtype in the relationship.

(Multiple Choice)

4.9/5

(32)

Question 121

Use a verb or verb phrase to name an entity.

(True/False)

4.9/5

(37)

Question 122

The primary deliverable from the conceptual data modeling step within the analysis phase is an entity-relationship diagram.

(True/False)

4.8/5

(34)

Question 123

Match each of the following terms with its corresponding definition. -An entity instance is a single occurrence of an entity type.

(Multiple Choice)

4.8/5

(40)

Question 124

An ellipse represents an entity on an entity-relationship diagram.

(True/False)

4.8/5

(35)

Question 125

Analysts should substitute single-attribute surrogate keys for large composite keys.

(True/False)

4.9/5

(29)

Question 126

If entity B is a mandatory participant,then:

(Multiple Choice)

4.9/5

(35)

Question 127

A __________ is an assertion or rule that governs the validity of data manipulation operations such as insert,update,and delete.

(Short Answer)

4.7/5

(29)

Question 128

Match each of the following terms with its corresponding definition. -A person,place,object,event or concept in the user environment about which the organization wishes to maintain data.

(Multiple Choice)

4.9/5

(35)

Question 129

An attribute (or combination of attributes)that uniquely identifies each instance of an entity type defines:

(Multiple Choice)

4.7/5

(41)

Question 130

The __________ specifies that an entity instance of the supertype is allowed not to belong to any subtype.

(Short Answer)

4.7/5

(41)

Question 131

Domains are constraints on valid values for attributes.

(True/False)

4.8/5

(35)

Question 132

Match each of the following terms with its corresponding definition. -Many instances of an entity type are represented by data stored in the database.

(Multiple Choice)

4.8/5

(38)

Question 133

An E-R model with attributes is prepared during:

(Multiple Choice)

4.9/5

(45)

Question 134

A primary key should be null.

(True/False)

4.8/5

(29)

Question 135

The set of all data types and ranges of values that an attribute can assume defines:

(Multiple Choice)

5.0/5

(28)

Question 136

__________ refers to the number of instances of entity B that can (or must)be associated with each instance of entity A.

(Short Answer)

4.9/5

(33)

Question 137

Which of the following specifies that each entity instance of the supertype must be a member of some subtype in the relationship?

(Multiple Choice)

4.8/5

(35)

Question 138

When selecting an identifier,one should choose a candidate key that will not change its value over the life of each instance of the entity type.

(True/False)

4.9/5

(33)

Question 139

A concise statement of the business rule to be enforced by the triggering operation refers to:

(Multiple Choice)

4.8/5

(31)

Question 140

Showing 121 - 140 of 153

Match each of the following terms with its corresponding definition. -Specifies that each entity instance of the supertype must be a member of some subtype in the relationship.

Use a verb or verb phrase to name an entity.

The primary deliverable from the conceptual data modeling step within the analysis phase is an entity-relationship diagram.

Match each of the following terms with its corresponding definition. -An entity instance is a single occurrence of an entity type.

An ellipse represents an entity on an entity-relationship diagram.

Analysts should substitute single-attribute surrogate keys for large composite keys.

If entity B is a mandatory participant,then:

A __________ is an assertion or rule that governs the validity of data manipulation operations such as insert,update,and delete.

Match each of the following terms with its corresponding definition. -A person,place,object,event or concept in the user environment about which the organization wishes to maintain data.

An attribute (or combination of attributes)that uniquely identifies each instance of an entity type defines:

The __________ specifies that an entity instance of the supertype is allowed not to belong to any subtype.

Domains are constraints on valid values for attributes.

Match each of the following terms with its corresponding definition. -Many instances of an entity type are represented by data stored in the database.

An E-R model with attributes is prepared during:

A primary key should be null.

The set of all data types and ranges of values that an attribute can assume defines:

__________ refers to the number of instances of entity B that can (or must)be associated with each instance of entity A.

Which of the following specifies that each entity instance of the supertype must be a member of some subtype in the relationship?

When selecting an identifier,one should choose a candidate key that will not change its value over the life of each instance of the entity type.

A concise statement of the business rule to be enforced by the triggering operation 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

Designing Databases

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