Question 1

To resolve potential database connectivity and access problems, companies use ODBC-compliant software that enables communication among various systems and DBMSs.

Accepted Answer

A) True 
 B)False

Question 2

Three main types of relationships can exist between entities: a one-to-one relationship, abbreviated 1:1; a one-to-many relationship, abbreviated 1:M; and a many-to-many relationship, abbreviated M:N.

Accepted Answer

A) True 
 B)False

Question 3

Matching
​Identify the letters of the choices that best match the phrases or definitions.
-Could help a consumer products firm identify potential customers based on their prior purchases

Accepted Answer

A) Unified Modeling Language (UML) 
B) Cardinality 
C) Foreign key 
D) Data mining 
E) Referential integrity
F)Subschema
G)Extended Binary Coded Decimal Interchange Code (EBCDI
C) 
H)Entity
I)Logical record
J)Logical storage 
A) Unified Modeling Language (UML) 
B) Cardinality 
C) Foreign key 
D) Data mining 
E) Referential integrity
F)Subschema
G)Extended Binary Coded Decimal Interchange Code (EBCDI
C) 
H)Entity
I)Logical record
J)Logical storage

Question 4

_____ combine data from different item attributes, or characteristics, to build a code.

Accepted Answer

A) Sequence codes 
B) Category codes 
C) Significant digit codes 
D) Derivation codes 
A) Sequence codes 
B) Category codes 
C) Significant digit codes 
D) Derivation codes

Question 5

_____ means that a system can be expanded, modified, or downsized easily to meet the rapidly changing needs of a business enterprise.

Accepted Answer

A) Scalability 
B) Compatibility 
C) Cardinality 
D) Functionality 
A) Scalability 
B) Compatibility 
C) Cardinality 
D) Functionality

Question 6

A common field is an attribute that appears in only one entity.

Accepted Answer

A) True 
 B)False

To resolve potential database connectivity and access problems, companies use ODBC-compliant software that enables communication among various systems and DBMSs.

Three main types of relationships can exist between entities: a one-to-one relationship, abbreviated 1:1; a one-to-many relationship, abbreviated 1:M; and a many-to-many relationship, abbreviated M:N.

Matching Identify the letters of the choices that best match the phrases or definitions. -Could help a consumer products firm identify potential customers based on their prior purchases

_____ combine data from different item attributes, or characteristics, to build a code.

_____ means that a system can be expanded, modified, or downsized easily to meet the rapidly changing needs of a business enterprise.

A common field is an attribute that appears in only one entity.

Introduction to Systems Analysis and Design

Analyzing the Business Case

Managing Systems Projects

Requirements Modeling

Data and Process Modeling

Object Modeling

Development Strategies

User Interface Design

System Architecture

Managing Systems Implementation

Managing Systems Support and Security

Toolkit A: The Systems Analysts Toolkit

Toolkit B: Case Tools

Toolkit C: Financial Analysis Tools

Toolkit D: Internet Resource Tools

Filters

Exam 9: Data Design

To resolve potential database connectivity and access problems, companies use ODBC-compliant software that enables communication among various systems and DBMSs.

Three main types of relationships can exist between entities: a one-to-one relationship, abbreviated 1:1; a one-to-many relationship, abbreviated 1:M; and a many-to-many relationship, abbreviated M:N.

Matching ​Identify the letters of the choices that best match the phrases or definitions. -Could help a consumer products firm identify potential customers based on their prior purchases

_____ combine data from different item attributes, or characteristics, to build a code.

_____ means that a system can be expanded, modified, or downsized easily to meet the rapidly changing needs of a business enterprise.

A common field is an attribute that appears in only one entity.

Introduction to Systems Analysis and Design

Analyzing the Business Case

Managing Systems Projects

Requirements Modeling

Data and Process Modeling

Object Modeling

Development Strategies

User Interface Design

System Architecture

Managing Systems Implementation

Managing Systems Support and Security

Toolkit A: The Systems Analysts Toolkit

Toolkit B: Case Tools

Toolkit C: Financial Analysis Tools

Toolkit D: Internet Resource Tools

Filters

Matching Identify the letters of the choices that best match the phrases or definitions. -Could help a consumer products firm identify potential customers based on their prior purchases