Question 1

In theory, if there are six sets of requirements, four implementation environments, and five sources of application software, then there would be one hundred twenty possible design strategies.

Accepted Answer

The total number of possible design strategies would be the product of the number of sets of requirements, implementation environments, and sources of application software: 6 x 4 x 5 = 120. Therefore, the statement is true.

Question 2

Conceptual data modeling for an Internet-based electronic commerce application differs significantly from the process followed when analyzing the data needs for other types of applications.

Accepted Answer

The answer of Conceptual data modeling for an Internet-based electronic...

Question 3

Conceptual data modeling is typically done in parallel with other requirements analysis and structuring steps during:
A) systems planning and selection.
B) systems design.
C) systems analysis.
D) systems implementation and operation.
E) systems evaluation.

Accepted Answer

Conceptual data modeling is a part of systems analysis which involves studying the current system, identifying the needs of the new system, and defining its requirements. Therefore, conceptual data modeling is typically done in parallel with other requirements analysis and structuring steps during systems analysis.

Question 4

During systems analysis:
A) a conceptual data model (E-R with attributes) is prepared.
B) a logical model (relational) is prepared.
C) physical files and database designs are prepared.
D) an enterprise-wide data model is prepared.
E) database and file definitions are prepared.

Accepted Answer

During systems analysis, a conceptual data model, such as an Entity-Relationship (E-R) diagram with attributes, is prepared to represent the data requirements and relationships at a high level.

Question 5

The primary deliverable from the conceptual data-modeling step within the analysis phase is:
A) a state-transition diagram.
B) an entity-relationship diagram.
C) a context data flow diagram.
D) a decision table.
E) Structured English.

Accepted Answer

The primary deliverable from the conceptual data-modeling step within the analysis phase is an entity-relationship diagram (ERD). It shows the entities involved in a system, their attributes, and the relationships between them. Other deliverables listed are typically associated with different modeling techniques or analysis steps.

Question 6

Cost is the primary focus of high-end alternatives.

Accepted Answer

High-end alternatives typically prioritize quality, features, and performance over cost. Their primary focus is not on providing a low price point, but rather on offering a premium product or service that justifies its higher cost.

Question 7

The minimum requirements for a new system are also its mandatory features.

Accepted Answer

The minimum requirements for a new system are the essential features that must be present for the system to function properly. Therefore, they are mandatory and cannot be excluded from the system.

Question 8

During the designing the human interface step of the design phase, you would enumerate different potential implementation environments that could be used to deliver the different sets of capabilities.

Accepted Answer

Enumerating potential implementation environments is typically part of the system architecture design, not the human interface design, which focuses on user interaction and experience.

Question 9

The most common format used for data modeling is:
A) state-transition diagramming.
B) entity-relationship diagramming.
C) process modeling.
D) logic modeling.
E) a flowchart.

Accepted Answer

Entity-relationship diagramming is the most common format used for data modeling. It is widely used in database design, allows for the visual representation of entities, attributes, and relationships between them. State-transition diagramming, process modeling, logic modeling, and flowcharts are used in other areas of modeling but are not as commonly used in data modeling.

Question 10

Which of the following is a True statement?
A) A data model explains what the organization does and what rules govern how work is done in the organization.
B) To construct a data model, you need to know how data are processed.
C) To construct a data model, you need to know when data are processed.
D) A data flow diagram graphically illustrates the structure and relationships among data items.
E) During conceptual data modeling, the preparation of a Network diagram is necessary.

Accepted Answer

A data model is a representation of an organization's data which explains what the organization does and what rules govern how work is done in the organization.

Option B is incorrect because to construct a data model, one does not necessarily need to know how data are processed.

Option C is incorrect because again, knowing when data is processed is not a requirement for constructing a data model.

Option D is incorrect because a data flow diagram historically illustrates the movement of data through a system, not the structure and relationships among data items.

Option E is incorrect because preparing a network diagram is not a requirement during conceptual data modeling.

Question 11

Asking system users and business managers, "What are the subjects of the business?" would help determine:
A) the data entities and their descriptions.
B) the candidate key.
C) attributes and secondary keys.
D) relationships and their cardinality and degrees.
E) integrity rules, minimum and maximum cardinality, and time dimensions of data.

Accepted Answer

Asking about the subjects of the business would help determine the data entities and their descriptions, which are the core components of any system's data model. This information is crucial in identifying what type of data will be stored in the system and how it will be organized.

Question 12

Essential features are those that everyone agrees are necessary to solve the problem or meet the opportunity.

Accepted Answer

The answer of Essential features are those that everyone agrees...

Question 13

The data modeling perspective that derives the business rules for a data model from an intimate understanding of the nature of the business, rather than from any specific information requirements in screens, reports, or business forms, is referred to as the:
A) top-down approach.
B) bottom-up approach.
C) overview approach.
D) business approach.
E) conceptual approach.

Accepted Answer

The top-down approach is focused on understanding the overall business and deriving the business rules from that understanding, rather than starting with specific information requirements. This approach allows for a more holistic and comprehensive view of the business and its data needs.

Question 14

A person, place, object, event, or concept in the user environment about which the organization wishes to maintain data refers to a(n):
A) attribute.
B) data element.
C) relationship.
D) entity.
E) process.

Accepted Answer

An entity is a person, place, object, event, or concept in the user environment about which the organization wishes to maintain data.

Question 15

Asking system users and managers, "Who is responsible for establishing legitimate values for these data?" helps determine:
A) the candidate key.
B) security controls and understanding who really knows the meaning of data.
C) relationships and their cardinality and degrees.
D) attributes and secondary keys.
E) integrity rules, minimum and maximum cardinality, and time dimensions of data.

Accepted Answer

Asking who is responsible for establishing legitimate values for data helps determine who understands the meaning of the data and who should have input into security controls. This is important for ensuring data integrity and accuracy. The other options listed are not directly relevant to this question.

Question 16

On an entity-relationship diagram, a rectangle represents a(n):
A) data flow.
B) entity.
C) multivalued attribute.
D) repeating group.
E) relationship.

Accepted Answer

On an entity-relationship diagram, a rectangle represents an entity. This can include a person, place, thing, or event for which information needs to be stored and managed within the database.

Question 17

Gathering the information you need for data modeling by reviewing specific business documents handled within the system describes the:
A) bottom-up approach.
B) conceptual approach.
C) top-down approach.
D) investigative approach.
E) business approach.

Accepted Answer

The bottom-up approach involves reviewing existing business documents and data within the system to gather information for data modeling. This approach is focused on analyzing specific details and components of the system before creating an overall conceptual model.

Question 18

In theory, if there are four sets of requirements, three implementation environments, and four sources of application software, then there would be thirty-six possible design strategies.

Accepted Answer

The number of possible design strategies would be the product of the number of requirements, implementation environments, and sources of application software i.e., 4 x 3 x 4 = 48.

Question 19

Reviewing computer screens, reports, and business forms for the purpose of gaining an understanding of data is indicative of the:
A) investigative approach.
B) business approach.
C) bottom-up approach.
D) top-down approach.
E) conceptual approach.

Accepted Answer

The answer of Reviewing computer screens, reports, and business forms...

Question 20

A good number of alternatives to generate is five.

Accepted Answer

The answer of A good number of alternatives to generate...

Quiz 7: Structuring System Requirements: Conceptual Data Modeling

In theory, if there are six sets of requirements, four implementation environments, and five sources of application software, then there would be one hundred twenty possible design strategies.

Conceptual data modeling for an Internet-based electronic commerce application differs significantly from the process followed when analyzing the data needs for other types of applications.

Conceptual data modeling is typically done in parallel with other requirements analysis and structuring steps during:

During systems analysis:

The primary deliverable from the conceptual data-modeling step within the analysis phase is:

Cost is the primary focus of high-end alternatives.

The minimum requirements for a new system are also its mandatory features.

During the designing the human interface step of the design phase, you would enumerate different potential implementation environments that could be used to deliver the different sets of capabilities.

The most common format used for data modeling is:

Which of the following is a True statement?

Asking system users and business managers, "What are the subjects of the business?" would help determine:

Essential features are those that everyone agrees are necessary to solve the problem or meet the opportunity.

The data modeling perspective that derives the business rules for a data model from an intimate understanding of the nature of the business, rather than from any specific information requirements in screens, reports, or business forms, is referred to as the:

A person, place, object, event, or concept in the user environment about which the organization wishes to maintain data refers to a(n) :

Asking system users and managers, "Who is responsible for establishing legitimate values for these data?" helps determine:

On an entity-relationship diagram, a rectangle represents a(n) :

Gathering the information you need for data modeling by reviewing specific business documents handled within the system describes the:

In theory, if there are four sets of requirements, three implementation environments, and four sources of application software, then there would be thirty-six possible design strategies.

Reviewing computer screens, reports, and business forms for the purpose of gaining an understanding of data is indicative of the:

A good number of alternatives to generate is five.