W2 Quiz 2 System Analysis

What is the initial step in the step-by-step approach for analyzing business processes to define system requirements?

• Identify tasks performed by users.

• Understand organizational goals and workflows.

• Extract data involved in tasks.

• Translate into system requirements.

What term describes the number of times an entity of an entity set participates in a relationship set?

• Multiplicity

• Attribute

• Cardinality

• Constraint

In an Entity-Relationship Diagram (ERD), what do nouns in a narrative typically represent?

• Relationships

• Attributes

• Entities

• Business Rules

Which data gathering technique involves observing how users perform their tasks in a real-world setting?

• Interviews

• Document Review

• Observation

• Surveys

Which of the following best describes the role of system analysis in database design?

• To only create SQL queries for data retrieval.

• To analyze business processes for system requirements.

• To solely manage database security.

• To conduct performance tuning of existing databases.

Business rules primarily influence which aspects of database design?

• The choice of database software only.

• Relationship design, data integrity, and constraints.

• User interface aesthetics.

• Hardware specifications.

A relationship where one entity in set A can be associated with any number of entities in set B, and one entity in set B can be associated with any number of entities in set A, is known as:

• One-to-One

• One-to-Many

• Many-to-One

• Many-to-Many

Which of these is NOT a method mentioned for gathering data during system analysis?

• Observation

• Interviews

• Brainstorming

• Document Review

What type of participation constraint requires every entity in one set to take part in a relationship in another set?

• Optional Participation

• Partial Participation

• Total Participation

• Conditional Participation

In the context of database logic, what do business rules translate into?

• Only visual diagrams.

• Primary and Foreign Key Constraints, Validation Rules, and Default Values/Triggers.

• User manual documentation.

• Marketing strategies.