Font size
WorksheetsECM3434 Business Analysis 1 - Data Modelling
Total questions: 10
Worksheet time: 10mins
Why do we need data modeling in Business Analysis projects? (Select all that apply)
To model data to be created, stored, and manipulated by a system
To understand the required functionality of a system
To understand business rules that govern data creation, storage, manipulation and retrieval in a system
Data models help decrease the development costs of a solution
Is data modelling exclusively useful for BA projects that involve creating new systems from scratch?
Yes, it is only useful for such projects
No, data modelling is versatile and can aid various BA projects
No, it is only useful for projects involving off-the-shelf solutions
Which of the following are recognized as data modelling techniques or notations? (Select all that apply)
UML class diagram
UML use case diagrams
Chen's notation
IDEF1X
Ellis-Barker notation
Which of the following methods are effective for gathering data necessary for developing data models?
(Select all that apply)
Interviewing stakeholders
Observing business processes
Analysing organisational documentation
Just guessing
Creating and analysing business process models
What type of data model should be created to understand the main blocks of information and data in the business environment?
Logical data model
Conceptual data model
Physical data model
What type of data model should be created in order to design a data structure in detail, for example, a database?
Conceptual data model
Physical data model
Logical data model
What aspects can business rules define? (Select all that apply)
Organisational policy constraints
Legal and regulatory constraints
Operational procedures
Select one statement you mostly agree with
A business analyst should never question business rules
A business analyst should understand the reasons behind business rules and question them only if it is allowed and necessary for process improvement
A business analyst should always question business rules as this is the only approach to process improvement
What role do business rules play in data modelling?
(Select all that apply)
They determine the structure and constraints of the data model
They are crucial for defining the relationships between different data entities
They have no role in the data modelling process
They help in pinpointing essential data entities for accurate business analysis
Why is it important to resolve M2M relationships in data models?
(Select all that apply)
Data models can't have M2M relationships
Relational DBMS can't model M2M relationships
A diagram with M2M relationships does not represent data items efficiently
M2M relationships can hide other important entities and their attributes, which can be useful for accurate modelling
