Question 1

Discuss unary,binary,and ternary relationships.Provide an example of each.

Accepted Answer

The number of entity types participating

Question 2

A relationship must be turned into an associative entity when the associative entity has other relationships with entities besides the relationship that caused its creation.

Accepted Answer

A) True 
 B)False

Question 3

The bottom-up approach to data modeling derives a data model by reviewing specific business documents.

Accepted Answer

A) True 
 B)False

Question 4

During requirements structuring:

Accepted Answer

A) an E-R model represents conceptual data requirements for a particular system 
B) the conceptual E-R data model is refined before it is translated into a logical format from which database definition and physical database design are done 
C) an enterprise-wide data model with very broad categories of data and little detail is prepared 
D) a specific E-R model is built to help explain the scope of a particular systems analysis and design effort 
A) an E-R model represents conceptual data requirements for a particular system 
B) the conceptual E-R data model is refined before it is translated into a logical format from which database definition and physical database design are done 
C) an enterprise-wide data model with very broad categories of data and little detail is prepared 
D) a specific E-R model is built to help explain the scope of a particular systems analysis and design effort

Question 5

An assertion or rule that governs the validity of data manipulation operations such as insert,update,and delete is:

Accepted Answer

A) triggering operation 
B) entity integrity 
C) referential integrity constraints 
D) domains 
A) triggering operation 
B) entity integrity 
C) referential integrity constraints 
D) domains

Question 6

An ________ is a named property or characteristic of an entity that is of interest to the organization.

Accepted Answer

The answer of An ________ is a named property or...

Question 7

Contrast data modeling to process modeling and logic modeling.

Accepted Answer

Data modeling,process modeling,and logic

Question 8

Which of the following specifies that if an entity instance of the supertype is a member of one subtype it cannot simultaneously be a member of any other subtype?

Accepted Answer

A) total specialization rule 
B) partial specialization rule 
C) disjoint rule 
D) overlap rule 
A) total specialization rule 
B) partial specialization rule 
C) disjoint rule 
D) overlap rule

Question 9

An order number is a good example of a candidate key.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following specifies that an entity instance can simultaneously be a member of two (or more)subtypes?

Accepted Answer

A) total specialization rule 
B) partial specialization rule 
C) disjoint rule 
D) overlap rule 
A) total specialization rule 
B) partial specialization rule 
C) disjoint rule 
D) overlap rule

Question 11

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

Accepted Answer

A) total specialization rule 
B) partial specialization rule 
C) disjoint rule 
D) overlap rule 
A) total specialization rule 
B) partial specialization rule 
C) disjoint rule 
D) overlap rule

Question 12

Which of the following addresses the rules concerning the relationships between entity types?

Accepted Answer

A) referential integrity constraints 
B) triggering operations 
C) entity integrity 
D) domains 
A) referential integrity constraints 
B) triggering operations 
C) entity integrity 
D) domains

Question 13

On an entity relationship diagram,total specialization is shown by a single line from the supertype to the subtype.

Accepted Answer

A) True 
 B)False

Question 14

A ________ is a relationship between instances of two entity types.

Accepted Answer

The answer of A ________ is a relationship between instances...

Question 15

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.

Accepted Answer

A) True 
 B)False

Question 16

Domains are other business rules that protect the validity of attribute values.

Accepted Answer

A) True 
 B)False

Question 17

A primary key should be null.

Accepted Answer

A) True 
 B)False

Question 18

All of the following are benefits of database patterns and packaged data models EXCEPT:

Accepted Answer

A) purchased models are proven from extensive experience 
B) systems analysis is facilitated 
C) purchased models are very specific 
D) purchased models anticipate future needs 
A) purchased models are proven from extensive experience 
B) systems analysis is facilitated 
C) purchased models are very specific 
D) purchased models anticipate future needs

Question 19

Employee identification number,name,address,and skill are attributes.

Accepted Answer

A) True 
 B)False

Question 20

Processes,rather than data,are the most complex aspects of many modern information systems.

Accepted Answer

A) True 
 B)False

Discuss unary,binary,and ternary relationships.Provide an example of each.

A relationship must be turned into an associative entity when the associative entity has other relationships with entities besides the relationship that caused its creation.

The bottom-up approach to data modeling derives a data model by reviewing specific business documents.

During requirements structuring:

An assertion or rule that governs the validity of data manipulation operations such as insert,update,and delete is:

An ________ is a named property or characteristic of an entity that is of interest to the organization.

Contrast data modeling to process modeling and logic modeling.

Which of the following specifies that if an entity instance of the supertype is a member of one subtype it cannot simultaneously be a member of any other subtype?

An order number is a good example of a candidate key.

Which of the following specifies that an entity instance can simultaneously be a member of two (or more)subtypes?

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

Which of the following addresses the rules concerning the relationships between entity types?

On an entity relationship diagram,total specialization is shown by a single line from the supertype to the subtype.

A ________ is a relationship between instances of two entity types.

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.

Domains are other business rules that protect the validity of attribute values.

A primary key should be null.

All of the following are benefits of database patterns and packaged data models EXCEPT:

Employee identification number,name,address,and skill are attributes.

Processes,rather than data,are the most complex aspects of many modern information systems.

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

Object-Oriented Analysis and Design: Sequence Diagrams

Business Process Modeling

Objected-Oriented Analysis and Design: Object Modeling-Class Diagrams

Filters

Exam 8: Structuring System Data Requirements

Discuss unary,binary,and ternary relationships.Provide an example of each.

A relationship must be turned into an associative entity when the associative entity has other relationships with entities besides the relationship that caused its creation.

The bottom-up approach to data modeling derives a data model by reviewing specific business documents.

During requirements structuring:

An assertion or rule that governs the validity of data manipulation operations such as insert,update,and delete is:

An ________ is a named property or characteristic of an entity that is of interest to the organization.

Contrast data modeling to process modeling and logic modeling.

Which of the following specifies that if an entity instance of the supertype is a member of one subtype it cannot simultaneously be a member of any other subtype?

An order number is a good example of a candidate key.

Which of the following specifies that an entity instance can simultaneously be a member of two (or more)subtypes?

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

Which of the following addresses the rules concerning the relationships between entity types?

On an entity relationship diagram,total specialization is shown by a single line from the supertype to the subtype.

A ________ is a relationship between instances of two entity types.

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.

Domains are other business rules that protect the validity of attribute values.

A primary key should be null.

All of the following are benefits of database patterns and packaged data models EXCEPT:

Employee identification number,name,address,and skill are attributes.

Processes,rather than data,are the most complex aspects of many modern information systems.

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

Object-Oriented Analysis and Design: Sequence Diagrams

Business Process Modeling

Objected-Oriented Analysis and Design: Object Modeling-Class Diagrams

Filters