WorksheetsW2 Quiz 2 System Analysis
Total questions: 15
Worksheet time: 8mins
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.
Scenario: A project manager is reviewing a new database design for a library system. One business rule states, "A book can only be loaned once at a time." Question: This business rule is crucial for ensuring which aspect of the database?
Data security
Data integrity
User interface
Query performance
Scenario: A small tutoring center wants to develop a system to manage students, tutors, subjects, and scheduled tutoring sessions. They begin by listing "enrolling students," "assigning tutors to subjects," and "scheduling sessions" as key processes. Question: What is the next logical step in defining the business requirements for their system, according to the provided methodology?
Immediately drafting the ER Diagram.
Identifying the specific data needed for each process (e.g., student names, session dates).
Choosing the database management system.
Training staff on the new system.
Scenario: A clinic database needs to connect Doctor entities to Patient entities. A single doctor can serve many patients, but each patient is served by only one doctor. Question: How would this relationship between Doctor and Patient most accurately be represented in an ER diagram in terms of cardinality?
Many-to-Many
One-to-One
One-to-Many
Many-to-One
Scenario: During the analysis phase for a new college database, it is decided that courses can exist even if no students are currently enrolled in them. However, every student must be enrolled in at least one course. Question: This scenario exemplifies which types of participation constraints for the relationship between Courses and Students?
Total participation for Courses, Partial participation for Students.
Partial participation for Courses, Total participation for Students.
Total participation for both Courses and Students.
Partial participation for both Courses and Students.
Scenario: An analyst is extracting entities from a narrative for a new inventory system. The narrative mentions "products," "suppliers," and "orders." They also note that each product has a "price" and a "stock quantity." Question: In this context, what do "price" and "stock quantity" represent for the "products" entity?
Relationships
Attributes
Foreign Keys
Column
